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 0

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