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 which you administer. The MiracleInfocom .com network management has recently informed you that you should have a password policy enabled on MiracleInfocom -DB01. You enabled a password policy on MiracleInfocom -DB01. All passwords are required to meet complexity requirements. You created a SQL login using the following command: 1. CREATE LOGIN RoryA WITH PASSWORD = Rory3M4 MUST_CHANGE CHECK_EXPIRATION = ON, CHECK_POLICY = ON When Rory Allen attempts to log onto the SQL server the first time and attempts to change the password to RoryAll23$_a he receives an error message indicating that he cannot use the new password. You need to find out what is causing the problem. What should you do?
A. Part of the user name is in the password.
B. At least one invalid character is in the password.
C. There are no uppercase letters in the password.
D. The minimum number of characters is not used in the password.
Answer:A
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 which you administer. The MiracleInfocom .com network management has recently informed you that you should have a password policy enabled on MiracleInfocom -DB01. You enabled a password policy on MiracleInfocom -DB01. All passwords are required to meet complexity requirements. You created a SQL login using the following command: 1. CREATE LOGIN RoryA WITH PASSWORD = Rory3M4 MUST_CHANGE CHECK_EXPIRATION = ON, CHECK_POLICY = ON When Rory Allen attempts to log onto the SQL server the first time and attempts to change the password to RoryAll23$_a he receives an error message indicating that he cannot use the new password. You need to find out what is causing the problem. What should you do?
A. Part of the user name is in the password. B. At least one invalid character is in the password. C. There are no uppercase letters in the password. D. The minimum number of characters is not used in the password.