John Baird
Coatesville, Pennsylvania, United States
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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only