John Baird
Coatesville, Pennsylvanie, États-Unis
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
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement