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.
Looks like A is the right answer
It is tricky, I think you cannot update the SSID, you have to drop user and recreate it with the old SSID.
Actually you can update User’s SID through
ALTER USER [Account1] WITH LOGIN=’Account1′
Source: https://msdn.microsoft.com/en-us/library/ms176060.aspx
I think the correct answer is B, https://www.mssqltips.com/sqlservertip/2761/sql-server-management-studio-error-916/
B is correct given the information. You have a login, now it just needs access.
Nope.
In production environment option B is unacceptable, because you might give more permissions than [Account1] had on Server1
The right answer is A
Sorry, I must have been tired, it is clearly A.
A
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
A
A