Sign in to follow this  
will266

Ms Sql Connection Using Windows Authentication

Recommended Posts

My company recently purchased an Enterprise license of Fusion Charts XT Suite, and now I have downloaded Collabion, and want to make a business case for its purchase as well across our 4 WFE servers for MOSS 2007.

 

I am preparing 'ease of use" demos, and can easily create demos for data coming from SharePoint lists, and Excel spreadsjeets.

 

We also store a lot of data in MS SQL databases, but to access does NOT require a username and password, but uses Windows Authentication. I do not see an option to Connect to SQL using the current users credentials. I have tried using my domin, username and password, but no luck. Plus this information can change over time...

 

If I had to, I assume I could create a BDC, which apparently does not require a username and password, but wish to avoid any unnecessary effort, since there are only a handful of us in the company comfortable creating application definition files.

 

And while my department does not leverage Oracle much, other lines of business do, so I assume the username/pw presents an issue as well.

 

Help!

 

Thanks

Share this post


Link to post
Share on other sites
Guest vishal@fusioncharts

My company recently purchased an Enterprise license of Fusion Charts XT Suite, and now I have downloaded Collabion, and want to make a business case for its purchase as well across our 4 WFE servers for MOSS 2007.

 

I am preparing 'ease of use" demos, and can easily create demos for data coming from SharePoint lists, and Excel spreadsjeets.

 

We also store a lot of data in MS SQL databases, but to access does NOT require a username and password, but uses Windows Authentication. I do not see an option to Connect to SQL using the current users credentials. I have tried using my domin, username and password, but no luck. Plus this information can change over time...

 

If I had to, I assume I could create a BDC, which apparently does not require a username and password, but wish to avoid any unnecessary effort, since there are only a handful of us in the company comfortable creating application definition files.

 

And while my department does not leverage Oracle much, other lines of business do, so I assume the username/pw presents an issue as well.

 

Help!

 

Thanks

 

Hi will266,

 

Thanks for using our products. We do not support Windows Auth for SQL connections. We only support SQL auth which requires a username and password set on the SQL servers.

 

Please let me know if I could help you with something else.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this