News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics GP (Archived) The server principal &...

Microsoft Dynamics GP (Archived)

The server principal "NT AUTHORITY\NETWORK SERVICE" is not able to access the database "DYNAMICS" under the current security context.

(0) Share

Report

Report

Posted on by nsrinivasdax

40

Hi All,

I am able to successfully create user by using eConnect. After creation update some information by using sql queries.

At the time i am facing this problem.

Master Data Base : DYNAMICS

Company Data Base: TWO

i am using "NT AUTHORITY\NETWORK SERVICE" to communicate to the sql server.

i pass the connection string related to TWO database.

By Sql server Throws an error

Error : The server principal "NT AUTHORITY\NETWORK SERVICE" is not able to access the database "DYNAMICS" under the current security context.

Is econnect checks the user permission,Is econnect or Sql server check the permission on each action.

Pleas give some idea about problem.

Thanks,

Srinivasulun.

*This post is locked for comments

All responses Img

All responses (1)

Answers Img

Answers (0)

Suggested answer

Community Member Microsoft Employee on at

Like (0)

Report

RE: The server principal "NT AUTHORITY\NETWORK SERVICE" is not able to access the database "DYNAMICS" under the current security context.

Follow the below mentioned link..... hope this will fix your problem.

blog.sqlauthority.com/.../sql-server-fix-error-cannot-open-database-requested-by-the-login-the-login-failed-login-failed-for-user-nt-authoritynetwork-service

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 291,253 Super User 2024 Season 2

#2

Martin Dráb 230,188 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans