You need to ensure that Account1 can connect to DB1

You have a SQL Server 2012 environment that contains two servers. The servers are
configured as shown in the following table.
After the failover is complete, a user receives the following error message when connecting
to DB1 on Server2:
“Msg 916, Level 14, State 1, Line 1

The server principal “Account1” is not able to access the database “DB1” under the
current security context.”
You verify that there is a server login for Account1 on Server2.
You need to ensure that Account1 can connect to DB1.
What should you do?
More than one answer choice may achieve the goal. Select the BEST answer.

You have a SQL Server 2012 environment that contains two servers. The servers are
configured as shown in the following table.
After the failover is complete, a user receives the following error message when connecting
to DB1 on Server2:
“Msg 916, Level 14, State 1, Line 1

The server principal “Account1” is not able to access the database “DB1” under the
current security context.”
You verify that there is a server login for Account1 on Server2.
You need to ensure that Account1 can connect to DB1.
What should you do?
More than one answer choice may achieve the goal. Select the BEST answer.

A.
Update the SID for Account1 on DB1.

B.
Add Account1 to the db_datareader role.

C.
Create a new database user on DB1.

D.
Implement Windows authentication.



Leave a Reply 11

Your email address will not be published. Required fields are marked *


Jai

Jai

Looks like A is the right answer

Modi

Modi

I think A is the right answer scince we do not have a permission problem to log to the database and the problem is that the database does not deal with this table so we have to refresh (Update) this connection