SQL Login

Use this property page to set preferences for logging on to the Microsoft SQL Server.

Use Windows Authentication: Select this option to use a trusted connection and allow Microsoft Windows to authenticate the logon.
Use SQL Server Authentication: Select this option to use SQL user ID security. With this type of security, you must enter the logon ID and the password to log on to the Microsoft SQL Server.
Note: The authentication of the SQL user ID and password is based on the account you used to log in to MMC GUI. Therefore, the Microsoft Windows account that is used to configure the SQL user ID and password, must be the same one that is used to log on to the Microsoft SQL Server.
User name: Specifies the SQL Server user ID.
Password: Specifies the password to log on to the Microsoft SQL Server.