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 failed. 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?()
- AChange the SQL Server security mode from Windows Authentication mode to SQL Server and Windows authentication mode.
- BChange the SQL Server security mode from SQL Server and Windows Authentication mode to Windows authentication mode.
- CEnsure that the login name is created with square brackets ([]).
- DGive the login access to a specific database by using the CREATE USER Transact-SQL statement.