Cannot open database in windows service

Question

I am trying to connect my window service to my local db. In my OnStart() method inside Service.cs class, i am getting this error..

The underlying provider failed on Open.System.Data.SqlClient.SqlException 
(0x80131904): Cannot open database "EduFameProjectDB18" requested by the login. 
The login failed.
Login failed for user 'NT AUTHORITY\SYSTEM'.

LazyOfT · Accepted Answer · 2014-08-09 06:33:48Z

2

You are trying to use the SYSTEM account in order to access your database. This is due to the fact that you are using integrated authentication in SQL Server and running the Windows Service under the SYSTEM account.

In order to solve this you have to provide a different credential on you windows service in order for it to open the connection properly. Make sure that the same windows user is present in the logins of SQL Server for your DB, and that it has sufficient rights to access your tables.

As an alternative you can use sql authentication, by creating a SQL Login and providing the credentials in your connection string.

answered Aug 9, 2014 at 6:33

LazyOfT

1,4387 silver badges20 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Tariqul Shakil · Accepted Answer · 2016-11-26 16:10:30Z

1

Connect on Sql Server Management Studio.
Now go Security -> NT AUTHORITY\SYSTEM Right Click -> Properties
Click -> Server Roles
Check public, sysadmin
Click Ok

answered Nov 26, 2016 at 16:10

Tariqul Shakil

272 bronze badges

Collectives™ on Stack Overflow

Cannot open database in windows service

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related