SQL Server Management Studio Error 916


Problem
When connecting to SQL Server using Management Studio (SSMS), with the limited permissions, you do not see any user databases or receive Error 916 when expanding the database list from Object Explorer. The error message is “The server principal “Login Name” is not able to access the database “database name” under the current security context. (Microsoft SQL Server, Error: 916).” In this tip I will explain the root cause of the issue and how to fix it.

Solution
http://www.mssqltips.com/sqlservertip/2761/sql-server-management-studio-error-916/

Advertisements

3 thoughts on “SQL Server Management Studio Error 916

  1. Luigi

    Hi Jugal.
    My scenario is:

    PC1 (local): Windows 7 x64, SQL Server Management Studio 2012, one instance of SQL Express 2012, named ‘AUTOPID’ accessible via ‘(local)\AUTOPID’.

    PC2 (name:VSDS20): Windows server 2008 R2, one instance of SQL Express 2012, named AUTOPID, with ‘Windows authentication mode’ and accessible via ‘VSDS20\AUTOPID’.

    From PC1 I am able to connect to VSDS20\AUTOPID (on PC2) using Windows authentication mode with the username valid on PC1 (luigi.ballotta). Once connected I see the node named ‘database’ under ‘VSDS20\AUTOPID (SQL Server 11.0.2100 – VSD\luigi.ballotta)’.
    So right click on it and select New database. The form for creating the database
    is opened and enter the database name ‘testdb’, click OK and then an error window comes out
    with this message:
    CREATE DATABASE permission denied in database ‘master’. (Microsoft SQL Server, error: 262).

    If I try to perform a database connection another error comes out: The server principal “VSD
    \luigi.ballotta” is not able to access the database “model” under the current security
    context. (Microsoft SQL Server, error: 916).

    Same behavior running SQL Server Management Studio as administrator or not in PC1.

    I do not have any idea to solve this problem. Some tips?

    P.S.: if I try to perform the same actions in local PC1, all works fine.

    Thanks in davance.

    Luigi

    Reply
  2. Luigi

    Hi Jugal.
    My scenario is:

    PC1 (local): Windows 7 x64, SQL Server Management Studio 2012, one instance of SQL Express 2012, named ‘AUTOPID’ accessible via ‘(local)\AUTOPID’.

    PC2 (name:VSDS20): Windows server 2008 R2, one instance of SQL Express 2012, named AUTOPID, with ‘Windows authentication mode’ and accessible via ‘VSDS20\AUTOPID’.

    From PC1 I am able to connect to VSDS20\AUTOPID (PC2) using Windows authentication mode with the username valid on PC1 (luigi.ballotta). Once connected I see the node named ‘database’ under ‘VSDS20\AUTOPID (SQL Server 11.0.2100 – VSD\luigi.ballotta)’.
    So right click on it and select New database. The form for creating the database
    is opened and enter the database name ‘testdb’, click OK and then an error window comes out
    with this message:
    CREATE DATABASE permission denied in database ‘master’. (Microsoft SQL Server, error: 262).

    If I try to perform a database connection another error comes out: The server principal “VSD
    \luigi.ballotta” is not able to access the database “model” under the current security
    context. (Microsoft SQL Server, error: 916).

    Same behavior running SQL Server Management Studio as administrator or not in PC1.

    I do not have any idea to solve this problem. Some tips?

    P.S.: if I try to perform the same actions in local PC1, all works fine.

    Thanks in davance.

    Luigi

    Reply

Thanks for the comment, will get back to you soon... Jugal Shah

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s