What should you do to resolve the error and allow the new employee to gain access to Certkiller -DB01?
You are employed as a database administrator at Domain.com. The Domain.com network consists of a single Active Directory domain named Domain.com. Domain.com makes use of a SQL Server 2005 database named CK_DATA. CK_DATA is located on a server named Certkiller -DB01. You have received instruction from the CIO to give a new employee, Mia Hamm, access to CK_DATA. You create a login named mhamm by using the following Transact-SQL statement. CREATE LOGIN mhamm WITH PASSWORD = Certkiller -DB01
When you login on the server he received the following error message: "Login failed. The user is not associated with a trusted SQL Server connection." Mia Hamm report that as soon as she logs in, she receives the following error message:
"Login failed. She is not associated with a trusted SQL Server connection." You resolve the error and allow the new employee to gain access to Certkiller -DB01.
What should you do?