Managing Server Logins

SQL Server can use Windows logins as well as logins for SQL Server. If you have configured the server for mixed security, you can use both login types. Otherwise, you can use only Windows logins. You manage logins at the server level.

Viewing and Editing Existing Logins

To view or edit an existing login, follow these steps:

  1. Start SQL Server Management Studio. In the Object Explorer view, connect to the appropriate server, and then work your way down to the Security folder.

  2. Expand the Security folder at the server level and the Logins folder to list the current logins. Right-click a login, and then select Properties to view the properties of the login.

  3. The Login Properties dialog box, shown in Figure 9-1, has five pages:

    1. General ...

Get Microsoft® SQL Server® 2008 Administrator's Pocket Consultant now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial