logo
Welcome Guest! To enable all features please Login or Register.

Notification

Icon
Error

Support Client
#1 Posted : Saturday, May 10, 2008 2:01:28 PM(UTC)
Support Client

Rank: Newbie

Groups: Member
Joined: 4/3/2008(UTC)
Posts: 5

I get this Error when I try to generate Data Dictionary for “AdventureWorks DB”

"The Server principal "NT AUTHORITY\NETWORK SERVICE" is not able to access the database 'AdventureWorks" under the current security context.
Support
#2 Posted : Saturday, May 10, 2008 2:02:54 PM(UTC)
Support

Rank: Administration

Groups: Member
Joined: 4/3/2008(UTC)
Posts: 43

You need to add that user ("NT AUTHORITY\NETWORK SERVICE") as a user on the database and give him system administrators rights. Or you could give him read / write rights to each of the database individually to be more secure.

The easiest way to do this is from Enterprise Manager select the Security folder, add the user, and then give him system admin rights.

Support Client
#3 Posted : Saturday, May 10, 2008 2:04:03 PM(UTC)
Support Client

Rank: Newbie

Groups: Member
Joined: 4/3/2008(UTC)
Posts: 5

Worked…..!

Thanks,
Regards
Users browsing this topic
Guest
Forum Jump  
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.

Powered by YAF 1.9.6.1 | YAF © 2003-2024, Yet Another Forum.NET
This page was generated in 0.073 seconds.