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
Post a Comment