Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How to specify Trusted Connection?
Message
Information générale
Forum:
ASP.NET
Catégorie:
Bases de données
Versions des environnements
Environment:
C# 2.0
Divers
Thread ID:
01438452
Message ID:
01438460
Vues:
73
This message has been marked as the solution 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

What is your current connection string?

You should be doiong something like..

Server=myServerAddress;Database=myDataBase;Trusted_Connection=True;

or

Data Source=myServerAddress;Initial Catalog=myDataBase;Integrated Security=SSPI;

these came from http://www.connectionstrings.com/sql-server-2005
____________________________________

Don't Tread on Me

Overthrow the federal government NOW!
____________________________________
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform