Services stops automatically

(0) Share

Report

Posted on by Community Member Microsoft Employee

Hi All,

NAV services automatically stopped. When I checked in event viewer, I found below error-

"Login failed for user 'NT AUTHORITY\NETWORK SERVICE'. Reason: Failed to open the explicitly specified database 'Anglo NAV 2013'. [CLIENT: <local machine>]"

I checked the permissions, its dbowner.

Can anyone help in this...

Thanks

Ratnesh

*This post is locked for comments

All responses (3)

Answers (0)

Suggested answer

TharangaC 23,116 on at

Like (0)

Report

RE: Services stops automatically

As Suresh said Map the "NT AUTHORITY\NETWORK SERVICE" user to your database.

Follow this link : http://blog.sqlauthority.com/2009/08/20/sql-server-fix-error-cannot-open-database-requested-by-the-login-the-login-failed-login-failed-for-user-nt-authoritynetwork-service/

Provide following rights :

- db_Owner,

- db_ddladmin,

- public
Suggested answer

TharangaC 23,116 on at

Like (0)

Report

RE: Services stops automatically

Remove the user and assign it again and check.
Suggested answer

Suresh Kulla 43,745 on at

Like (0)

Report

RE: Services stops automatically

Please verify it again, open SQL Server Management Studio and from the security check the Network Service Properties and make sure in the user mapping it is mapped to the database and has the permissions.

Was this service working fine before?