A new employee needs access to a SQL Server 2005 database that is located on a server named SQL1. You create a login named ajones by using the following Transact-SQL statement. CREATE LOGIN ajones WITH PASSWORD = SQLServer$1 The new employee reports that when he logs in, he receives the following error message: Login faile The user is not associated with a trusted SQL Server connection. You need to resolve the error and allow the new employee to gain access to SQL1. What should you do?
A. Change the SQL Server security mode from Windows Authentication mode to SQL Server and Windows Authentication mode.
B. Change the SQL Server security mode from SQL Server and Windows Authentication mode to Windows Authentication mode.
C. Ensure that the login name is created with square brackets ([]).
D. Give the login access to a specific database by using the CREATE USER Transact-SQL statement.
Answer:A
A new employee needs access to a SQL Server 2005 database that is located on a server named SQL1. You create a login named ajones by using the following Transact-SQL statement. CREATE LOGIN ajones WITH PASSWORD = SQLServer$1 The new employee reports that when he logs in, he receives the following error message: Login faile The user is not associated with a trusted SQL Server connection. You need to resolve the error and allow the new employee to gain access to SQL1. What should you do?
A. Change the SQL Server security mode from Windows Authentication mode to SQL Server and Windows Authentication mode. B. Change the SQL Server security mode from SQL Server and Windows Authentication mode to Windows Authentication mode. C. Ensure that the login name is created with square brackets ([]). D. Give the login access to a specific database by using the CREATE USER Transact-SQL statement.