Registered SQL Server Properties (General Tab)
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.
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.
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.