Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Making sure a database requires a username
Message
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Sécurité
Divers
Thread ID:
01299694
Message ID:
01299727
Vues:
9
"Integrated Security=True" in the connection string is forcing the Windows authentication (i.e. Trusted Connection). If you want to use username and password in the connection string then you need to set
Integrated Security=false, UID=MyUserName, PWD=MyPassword
Cheers,

Zoran

>>You cannot acces SQL Server DB w/o login. It sounds like the connection string configured to use Windows authentication. Can you post it?
>
>It is specified but the username and password are blank.
>
>
>Connection1=Data Source=MyServer;Initial Catalog=MyDatabase;Integrated Security=True;User Id=;Password=
>
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform