You work as the network database administrator at MiracleInfocom .com. The MiracleInfocom .com network consists of a single Active Directory domain named MiracleInfocom .com. All servers on the MiracleInfocom .com network run Windows Server 2003 and all client computers run Windows XP Professional. The MiracleInfocom .com network contains a Microsoft SQL Server 2005 database server named MiracleInfocom -DB01 configured to support both Windows authentication and SQL Server authentication. You have received instruction from the CIO to audit the passwords for the SQL Server logins. You are required to determine which logins require strong passwords and which require password expiration. What should you do?
A. Query the sys.syslogins.
B. Query the sys.login_token.
C. Query the sys.server_principals.
D. Query the sys.sql_logins.
Answer:D
You work as the network database administrator at MiracleInfocom .com. The MiracleInfocom .com network consists of a single Active Directory domain named MiracleInfocom .com. All servers on the MiracleInfocom .com network run Windows Server 2003 and all client computers run Windows XP Professional. The MiracleInfocom .com network contains a Microsoft SQL Server 2005 database server named MiracleInfocom -DB01 configured to support both Windows authentication and SQL Server authentication. You have received instruction from the CIO to audit the passwords for the SQL Server logins. You are required to determine which logins require strong passwords and which require password expiration. What should you do?
A. Query the sys.syslogins. B. Query the sys.login_token. C. Query the sys.server_principals. D. Query the sys.sql_logins.