What should you do?

You work as a database administrator at Domain.com. Domain.com is using two SQL Server
2008 sample named CKSmp1 and CKSmp2. Furthermore, CKSmp1 contains a database named CK_DB.
A Domain.com user named Mia Hamm uses her name Mia to log on to the database on CKSmp1.
During the week you have transferred CK_DB to CKSmp2 with Mia Hamm credentials.
However, when she tries to login on CK_DB at CKSmp2, she received an error message stating
that she is not allowed access. Mia Hamm needs to access CK_DB and you need to make it happen.

What should you do?

You work as a database administrator at Domain.com. Domain.com is using two SQL Server
2008 sample named CKSmp1 and CKSmp2. Furthermore, CKSmp1 contains a database named CK_DB.
A Domain.com user named Mia Hamm uses her name Mia to log on to the database on CKSmp1.
During the week you have transferred CK_DB to CKSmp2 with Mia Hamm credentials.
However, when she tries to login on CK_DB at CKSmp2, she received an error message stating
that she is not allowed access. Mia Hamm needs to access CK_DB and you need to make it happen.

What should you do?

A.
You should consider using CK_DB and ALTER LOGIN Mia WITH DEFAULT_DATABASE = CK_DB;

B.
You should consider using CK_DB and ALTER LOGIN Mia WITH PASSWORD = ‘Re#99$45’ UNLOCK;

C.
You should consider the following: USE CK_DB and ALTER LOGIN Mia ENABLE.

D.
You should consider using CK_DB and change USER Mia WITH LOGIN = Mia;



Leave a Reply 0

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