SQL: Microsoft SQL Server, error:916

6 Jul 2009

I created a SQL User named UserA which was DB_Owner of 1 database. When I connected to this database with SQL Authentication I received the following error:

The server principal “User A” is not able to access the database “DatabaseA” under the current security context. (Microsoft SQL Server, error:916)

image

To resolve this error I logged in as SQL User UserA, and open theVObject Explorer Details View (press F7). I then right Clicked on the column header and de-selected ‘Collation’. Refresh your databases again and now it should work.

Share This:
  • Print
  • Digg
  • del.icio.us
  • Facebook
  • Google Bookmarks
  • LinkedIn
  • PDF
  • Twitter

1 Response to SQL: Microsoft SQL Server, error:916

Avatar

Botha

March 25th, 2010 at 07:17

How if it’s happen with SQL Server 2005?
It doesn’t have Object Explorer Details View and cannot do the same way as yours.

Please help. :’(
Thank you.

Comment Form