c# - Why do I get the server name instaid of the UID -


i'm trying access sql server database using service account. i'm putting information so:

<add name="conn"       connectionstring="data source=mtl1sqlitmp3\mtl1sqlitmp3;initial catalog=it_ops; integrated security=sspi;user id=service account; password=password"       providername="system.data.sqlclient" /> 

for reason, gives me usermane of server.

why that?

what have change make appropriate connection?

thanks,

you specified integrated security=sspi in connection string, presumably without realizing meant. explained in connectionstring documentation (among many other places):

if user id , password specified , integrated security set true, user id , password ignored , integrated security used.

(note "sspi" means same thing "true")


Comments