SQL Server Login failed for user 'NT AUTHORITY\LOCAL SERVICE' in window service

ig9co6j1 于 2022-12-22 发布在其他

关注(0)|答案(3)|浏览(325)

I had just created a window service app and it is throwing exception Login failed for user 'NT AUTHORITY\LOCAL SERVICE' I have tried to have user id and password but it does not work on it
and go through this reference SQL Server Login error: Login failed for user 'NT AUTHORITY\SYSTEM' and created a new user on that database but again that exception

sql-server

来源：https://stackoverflow.com/questions/47505347/login-failed-for-user-nt-authority-local-service-in-window-service

3条答案

按热度按时间

p4tfgftt1#

there is solution related to my problem http://www.aspdotnet-suresh.com/2010/10/cannot-open-database-requested-by-login.html

赞(0）回复(0）举报 2022-12-22

5vf7fwbs2#

Are your service and the service running on the same machine? If they are not it is not the same 'LOCAL SERVICE' user on both machine and it will not work. If they ARE on the same machine using this connection string with no username or password:
Server=localhost;1433;Database=myDataBase;Trusted_Connection=True;

赞(0）回复(0）举报 2022-12-22

wmomyfyw3#

"DefaultConnection": "Server=(local);Database=Main_DB;Trusted_Connection=True;MultipleActiveResultSets=true;TrustServerCertificate=True",

for .Net 7.0 make sure TrustServerCertificate is available.

赞(0）回复(0）举报 2022-12-22

我来回答

SQL Server Login failed for user 'NT AUTHORITY\LOCAL SERVICE' in window service

3条答案

相关问题

热门标签

最新问答