on the toolbar.Access this form by selecting a server node in the
navigation pane and clicking the design registered server icon on the toolbar.
Server Name or IP Address
Specify the name or IP address of the SQL Server.
Enter (local) in the Server Name box to register a
default local server.
Windows NT Login
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.
SQL Server Login
Use SQL Server Authentication when connecting to the server.
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
Specify that SQL Server must always prompt for the login name and password when a user connects to the server using SQL Server Authentication.
Show system databases
Specify that system databases be displayed.
Only show databases the logged-in user can access
Specify that databases to which the user has no permissions be hidden from view.
Autostart server if it is not running
Specify that an instance of SQL Server starts automatically when you connect to the server.
See Also