Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Trusted_Connection Problem with VS2005
Message
From
24/09/2006 11:24:46
John Baird
Coatesville, Pennsylvania, United States
 
 
To
23/09/2006 19:38:38
General information
Forum:
ASP.NET
Category:
Web Services
Miscellaneous
Thread ID:
01156747
Message ID:
01156778
Views:
20
Hi:

At work we use truested connections (I'm assuming you mean windows authentication) all the time, but the windows user name has to be a user of the sql database in question. Once we did that, we have no trouble logging in via a connection string using trusted connections.



>I'm sure this is a known problem, but I can't seem to find the fix.
>
>My VS2005 app connects to the SQL Server database through web services. If I connect with a connection string that uses userid and password, no problem. But, if I change that to use a Trusted_Connection instead, it won't work.
>
>This worked fine when the app was compiled under VS2003, but has not since migrating it to VS2005. Is there some setting I need to tweak somewhere? In IIS maybe? This is only a problem with Web Services.
>
>TIA,
>
>~~Bonnie
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform