Online Documentation for SQL Administrator for SQL Server

Configuring general connection settings


The General section of the Register Server Wizard allows you to view and change database server connection parameters.

 

Register server - Configuring general connection settings

 

 

SQL server name

Select server (host) to connect from the drop-down list. Click the search_server Search button to search for servers in a local network. In the list appeared choose the necessary server and press 'OK' button.

Note: If server name is not displayed in this list it can be entered manually.

 

Connection settings

SQL Server can be installed as a named instance. That is, its name is assigned during an installation process by default (e.g. SQL Server 2005 Express is set as a named instance SQLEXPRESS).

In this case you should enter the name of your machine (or IP address) and the instance name in the SQL server name field in the following format: computer_name\sqlserver_instance_name (e.g. "MYCOMPUTER\SQLEXPRESS").

If the instance is not named then specify only the name of your machine or its IP address.

 

Authentication

Specify the type of Microsoft® SQL Server™ authentication to be used for the connection: !RadioButton Windows authentication or !RadioButton SQL Server authentication. It is strongly recommended to avoid using SQL Server authentication with "sa" as the login.

 

!RadioButton Windows Authentication

SQL Administrator identifies a user by his domain name and password which are defined automatically according to his Windows domain user account.

 

!RadioButton SQL Server authentication

SQL Administrator identifies user by his server login and password. Login and password management is accomplished by Login Manager.

 

If !RadioButton Server authentication is selected as the authentication type, you should provide authorization settings: Login and Password. Analyzing them a system determines information and therefore object access permissions.

Note: It is recommended to use a login that is a sysadmin fixed server role member so as to have an access for using all features of SQL Administrator.

 

Server display name

Enter the server name to be displayed in the Explorer.

 

Server group

Select or enter server group that the server belongs to. Server groups are used to group servers in the Server Explorer visually.

 

Server description

Here you can enter some additional information.

 

Click the Test Connection button to check the ability to connect to the defined server.