sql server connectivity issue
If I am trying to run service from local machine - I get message as
Login failed for user ''. The user is not associated with truste开发者_如何转开发d SQL Server connection.
whereas, If I run the service from server - it works fine.
I am also able to connect to server from SQL Server - works fine too
Only while debugging I am getting error
Any guess why ?
thanks in advance.
Things to check:
Is the service on your local machine using a different connection string to your service from the server (check the .config files)
Is the service on your local machine running under a different user account then the service on the server
精彩评论