多做题,通过考试没问题!

微软认证考试

睦霖题库>其他计算机考试>微软认证考试

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?()

  • 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.
正确答案:A
答案解析:
进入题库查看解析

微信扫一扫手机做题