Interview Question in SQL Server Security
Interview Question :: Sqlexpress connection problem
i'm designing an asp.net web page. i want to connect to a sqlExpress db, but there are errors for user entrance:
'the user is not associated with a trusted sql server connection'
this is my code:
string strCon;
SqlConnection con;
strCon =
"DataSource=.\\SQLEXPRESS;
Integrated Security=False;
Initial Catalog=messages;
User ID=somthing password=somthing";
con = new SqlConnection(strCon);
con.Open();
how can i add a user to SqlExpress server(not sql server). or is the code wrong?
i have searched the web before.
Loading ...