Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Making sure a database requires a username
Message
 
To
07/03/2008 10:23:34
General information
Forum:
Microsoft SQL Server
Category:
Security
Miscellaneous
Thread ID:
01299694
Message ID:
01299727
Views:
8
"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=
>
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform