Connect to SQL Server using Win Authentication

jefferson conde

Can i add user id to the connection string below? Caz i dont want to use the credential of the user that are login in windows.

"Persist Security Info=False; Integrated Security=true;Initial Catalog=pcma_db; Server=int-sql05\\int_sql05; username:pedro";

5 Replies

Know the answer? Post it — somebody with the same question will find it here.

Satya Karki4y ago
+1
Rijwan Ansari4y ago
Replace the username and password with Integrated Security=SSPI;

sample:
<connectionStrings>
<add name="NorthwindContex"
   connectionString="data source=int-sql05\\int_sql05;
   initial catalog=pcma_db;persist security info=True;
   Integrated Security=SSPI;"
   providerName="System.Data.SqlClient" />
connectionStrings>
+2
Srinivasan Ramamoorthi4y ago
You can use application account in connection string ensure the account has privilege to add user. I would recommend separate app account to just add users, since it should have admin access.
+1
jefferson conde4y ago
can i use application account instead of windows account in SQL windows auth?

the problem is i want to use login form from the web app to connect to SQL server using SQL authentication for auditing porpuses.

but every time a new user need to be added to aapplication i also need to add that user to database which is added task for me

thanks again
+1
Sachin Singh4y ago
yes, for Windows Auth, you don't need username and password.
connectionString="data source=server_name;
  initial catalog=db_Name;persist security info=True;
  Integrated Security=SSPI;"
  providerName="System.Data.SqlClient" />
+2