Registered SQL Server Properties (General Tab)
New Information - SQL Server 2000 SP3.
Use this tab to view or specify the following options.
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.
Specify the login name you want to use when connecting to the server using SQL Server Authentication.
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.
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.