c# - WCF Service Error accessing DB -
i have wcf service running under iis 7.0. app pool identity set user account lets call "mydomain\myacc." have given "mydomain\myacc" login permissions sql 2005 server, , 2 dbs uses on server.
when try invoke 1 of wcf methods following in logs: "login failed user 'mydomain\myacc'..." have tried removing , re-adding user on sql server.
i tried accessing dbs management studio running "mydomain\myacc" , worked.
what missing?
finally figured out, using linq sql , last guy checked code in commented out code used pass in connection string web.config file. using connection string dbml file instead. connection string pointing db user account did not have access to.
Comments
Post a Comment