Connection string keep connecting as database admin in sql server -
hi developing first web site , having problems sql connections sql server. connecting via c#. here connection string :
string _connectionstring = "user id= badusername; password= badpassword; server = myserver; trusted_connection = yes; database= mydatabase; connection timeout = 30;
even bad username , bad password connection success , able perform select on database. ote database has 1 user : adminuser utilize windows credential connection. have tried sp_who
stored procedure , user connected connection string adminuser. seems no matter set username or password in connection string, resulting user adminuser. have disable invitee connection , it's doing same thing. thought how avoid ?
because of trusted_connection = yes;(windows authentication)
when false, user id , password taken business relationship authentication. when true, current windows business relationship credentials used authentication.
sql-server
No comments:
Post a Comment