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

Question

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

score 3 · Answer 1 · answered Nov 27 '17 at 08:49

3

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

answered Nov 27 '17 at 08:49

Amit Singh Rawat

559
1
9
27

score 1 · Answer 2 · answered Nov 27 '17 at 07:00

1

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;

answered Nov 27 '17 at 07:00

Noah

481
5
15

dear Noah i am using this following app.config file – Amit Singh Rawat Nov 27 '17 at 07:14
code: – Amit Singh Rawat Nov 27 '17 at 07:14
and i am running my sevice on same local machine – Amit Singh Rawat Nov 27 '17 at 07:15

score 0 · Answer 3 · answered Dec 18 '22 at 09:53

0

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

for .Net 7.0 make sure TrustServerCertificate is available.

answered Dec 18 '22 at 09:53

Joseph Wambura

2,732
2
21
24

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

3 Answers3