You work 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_Sales. CK_Sales is located on a database server named Certkiller -DB01.
A new Domain.com employee named Mia Hamm works in the Finance department. You have received instruction from the CIO to give a new employee, Mia Hamm, access to CK_Sales. You create a login named mhamm by using the following Transact-SQL statement. CREATE LOGIN mhamm WITH PASSWORD = Certkiller -DB01′
Mia Hamm reports that as soon as she logs in, she receives the following error message: “Login failed. You are not associated with a trusted SQL Server connection.” You need to resolve the error and allow the Mia Hamm to gain access to Certkiller -DB01.
What should he do?
A.
The login name needs be created with square brackets ([]).
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.