New or Edit Server Registration (General Tab) (Database Engine)

Use this tab to specify options when registering an instance of Microsoft SQL Server.

To access this page, in Registered Servers, click SQL Server on the Registered Servers toolbar, right-click any registered servers group, point to New, and then click Server Registration.

  • Server type
    When a server is registered from Registered Servers, the Server type box is read-only, and matches the type of server displayed in the Registered Servers pane. To register a different type of server, click Database Engine, Analysis Server, Reporting Services, SQL Server Compact Edition, or Integration Services on the Registered Servers toolbar before starting to register a new server.
  • Server name
    Select the server instance to register in the format: <servername>[\<instancename>].
  • Authentication
    Two authentication modes are available when connecting to an instance of SQL Server.
  • Windows Authentication
    Windows Authentication mode allows a user to connect through a Microsoft Windows 2000 user account.
  • SQL Server Authentication
    When a user connects with a specified login name and password from a nontrusted connection, SQL Server performs the authentication itself by checking whether a SQL Server login account has been set up and whether the specified password matches the one previously recorded. If SQL Server does not have a login account set, authentication fails, and the user receives an error message.

    ms183353.security(en-US,SQL.90).gifSecurity Note:
    When possible, use Windows Authentication. For more information, see Authentication Mode.
  • User name
    Shows the current user name you are connecting with. This read-only option is only available if you have selected to connect using Windows Authentication. To change User names, log in to the computer as a different user.
  • Login
    Enter the login to connect with. This option is available only if you have selected to connect using SQL Server Authentication.
  • Password
    Enter the password for the login. This option can be edited only if you have selected to connect by using SQL Server Authentication.
  • Remember password
    Select to have SQL Server encrypt and store the password you have entered. This option is displayed only if you have selected to connect using SQL Server Authentication.

    Note

    If you have stored the password and want to stop storing it, clear this check box, and then click Save.

  • Registered server name
    The name you want to appear in Registered Servers. This name does not have to match the Server name box.
  • Registered server description
    Enter an optional description of the server.
  • Test
    Click to test the connection to the server selected in Server name.
  • Save
    Click to save the registered server settings.