Export (0) Print
Expand All
Expand Minimize

Registered SQL Server Properties (General Tab)

SQL Server 2000

  New Information - SQL Server 2000 SP3.

Use this tab to view or specify the following options.

Options

Server

View the registered server running the instance of Microsoft® SQL Server™ that you want to edit. Click the search (...) button to perform a search for the server you want to view.

Use Windows Authentication

Use Windows Authentication when connecting to an instance of SQL Server. It is recommended that you use this option for security because users who connect through a Microsoft Windows NT® 4.0 or Windows® 2000 user account can make use of trusted connections. Trusted connections are those validated by Windows NT 4.0 or Windows 2000.

Security Note  When possible, use Windows Authentication.

Use SQL Server Authentication

Use SQL Server Authentication when connecting to the server.

Login name

Specify the login name you want to use when connecting to the server using SQL Server Authentication.

Password

Specify the password you want to use when connecting to the server using SQL Server Authentication.

Always prompt for login name and password

Specify that SQL Server must always prompt for the login name and password when a user connects to the server using SQL Server Authentication.

Important  For security purposes, you should select to prompt for the login name and password when possible.

Server group

Select the server group with which to associate the server. Click the add (...) button to add a server group to the list.

Display SQL Server state in console

Specify that the SQL Server state be displayed in the console.

Show system databases and system objects

Specify that system databases and system objects be displayed.

Automatically start SQL Server when connecting

Specify that an instance of SQL Server start automatically when you connect to the server.

See Also

Registering Servers

Show:
© 2014 Microsoft