1
kudos
spam Kudos Remove

Msg 916, Level 14, State 1, Procedure Line 0 server principal "sa" is not able to access the database "DBName" under the current security context
published 580 days, 29 minutes ago posted by sasa 587 days, 22 hours, 44 minutes ago
Thursday, July 08, 2010 1:42:05 PM GMT Wednesday, June 30, 2010 3:26:43 PM GMT
Msg 916, Level 14, State 1, Procedure Line 0 server principal "sa" is not able to access the database "DBName" under the current security context
A typical error suggesting that user is unable to access the database within the security context, I would say it is serious one. Why I said typical at the beginning that it is not a regular error number you should see within the day-to-day stuff, a brief overview on BOL about the text reveals that when you run a TSQL statement to raise the DDL related actions such as trigger then youw will get such message. Also further to that note KBA913422 refers that this occurs when following conditions are...(read more)
category: News | clicked: 1 | | source: sqlserver-qa.net | show counter code
tags: css, data file, DDL triggers, impersonate, Implicit conversion, Security, SQL Server, trigger, trustworthy, TSQL

No comments yet, be the first one to post comment.

To post your comment please login or signup