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?
A.
The login needs to be created with you must make sure that the login name is created with square brackets ([]) to ensure the new employee to be granted entry.
B.
The login needs to be given access to a specific database by using the CREATE USER Transact-SQL statement.
C.
The SQL Server security mode should be changed from Windows Authentication mode to SQL Server and Windows Authentication mode.
D.
The SQL Server security mode should be changed from SQL Server and Windows Authentication mode to Windows Authentication mode.
Explanation:
The syntax to create a Windows login is:
CREATE LOGIN [DomainUser] FROM WINDOWS
The Syntax to create a SQL Server login is
CREATE LOGIN login_name WITH PASSWORD=’password’
You have created a SQL Server login on a SQL Server that is configured to only accept Windows Authentication mode.