Creating an SQL Server Login ID

5/10/2007

Login IDs are the accounts that control access to the SQL Server system. A login ID must be associated with a user ID in each database before anyone connecting with that login ID can access objects in the database. By default the login ID and the user ID are the same.

To create a SQL Server login ID

  1. Start SQL Server Enterprise Manager from the Start menu.

  2. Expand the Microsoft SQL Servers node, and then expand the SQL Server Group node. Your database server registration is located under this node.

  3. Expand the <database server registration> node, and then expand the Security folder.

  4. Double-click the Logins icon, and then choose New Login from the Action menu.

  5. In the SQL Server Login Properties – New Login dialog box, type the user name in the Name box using the <domain\Name> format. Be sure that the Windows Authentication option is selected.

  6. Choose OK.

  1. Start SQL Server Enterprise Manager from the Start menu.

  2. Expand the Microsoft SQL Servers node, and then expand the SQL Server Group node. Your database server registration is located under this node.

  3. Expand the <database server registration> node, and then expand the Security folder.

  4. Double-click the Logins icon, and then choose New Login from the Action menu.

  5. In the SQL Server Login Properties – New Login dialog box, type the user name in the Name box using the <domain\Name> format. Be sure that the Windows Authentication option is selected.

  6. Choose OK.

See Also

Other Resources

User Account Setup