O'Reilly logo

Microsoft® SQL Server™ 2005 Administrator's Pocket Consultant by William R. Stanek

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Managing Server Logins

SQL Server can use Windows logons as well as logins for SQL Server. If you have configured the server for mixed security, you can use both logon types. Otherwise, you can use only Windows logons.

Viewing and Editing Existing Logins

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

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

  2. Expand the Security folder 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 8-1, has four pages:

    • General. Provides an overview of the login configuration, including the ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required