Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to specify Trusted Connection?
Message
General information
Forum:
ASP.NET
Category:
Databases
Environment versions
Environment:
C# 2.0
Miscellaneous
Thread ID:
01438452
Message ID:
01438461
Views:
44
This message has been marked as a message which has helped to the initial question of the thread.
>Hi,
>
>When calling a stored procedure from a simple/test .NET project and using "sa" for user ID I get error
>
>Login failed for user 'sa'
>The user is not associated with a trusted SQL connection
>
>
>In comparison, when calling SQL from my VFP application I have connection string with [Trusted_Connection=Yes]. Is this what is missing in my .NET connection string? If so, who do I specify it in my .NET connection string?
>
>TIA

Trusted connection means you are using your windows username/password that you logged in to windows with. You do not specify a username or password in the connectionstring - just that trusted_connection = True.

If you want to specufy a SQL username/password in your connectionstring, then do not include the Trusted_Connection parameter or set it to False.
____________________________________

Don't Tread on Me

Overthrow the federal government NOW!
____________________________________
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform