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

Popular posts from this blog

c++ - Convert big endian to little endian when reading from a binary file -

C#: Application without a window or taskbar item (background app) that can still use Console.WriteLine() -

unicode - Are email addresses allowed to contain non-alphanumeric characters? -