The server principal is not able to access the database under the current security context.

When you get this message, what exactly does it mean?

The server principal is not able to access the database "LiteTrack" under the current security context.

Thanks
LVL 6
anushahannaAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
Chris LuttrellConnect With a Mentor Senior Database ArchitectCommented:
what are you doing?  this problem is usually seen when an account didn’t have enough rights to a database, often when a trigger or stored procedure was created with the EXECUTE AS clause.   Basically either the account/principal you logged in as or the one it is trying to EXECUTE AS has not been granted access to your LiteTrack database.  You can look up more info under ownership chaining:
http://technet.microsoft.com/en-us/library/ms188676.aspx
0
 
anushahannaAuthor Commented:
Thanks CGLuttrell.

the link was fascinating.

the account did not have access to the database, you as mentioned.. thanks for the clue that helped save time.
0
All Courses

From novice to tech pro — start learning today.