Online Documentation for SQL Query for SQL Server

Setting connection properties


Enter the necessary settings to establish connection to SQL Server.

 

hs3211 - Setting connection properties

 

Host name

Type in, or use the drop-down list to specify the host name of the SQL Server server.

 

Please note that if SQL Server is installed as a named instance, you should enter the name of your machine and the instance name in the Host name field in the following format: computer_name\sqlserver_instance_name (e.g. "MYCOMPUTER\SQLEXPRESS").

 

Authentication Type

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

 

Afterwards you should specify authorization settings: User name and Password.

 

Click the Advanced button to view/edit additional parameters for connection using SQL Server Client Network Utility.

 

CheckBox Register a single database

Check this option if you wish to register one database at the host.

 

If the Register a single database option has been unchecked, you should also specify the databases you wish to be registered at the host. To select a database, you need to move it from the Available databases list to the Selected databases list. Use the Move to Selected Move all to Selected Move to Available Move all to Available buttons or drag-and-drop operations to move the databases from one list to another.

 

hs3211 - Selecting databases

 

Click the Next button to proceed to the Setting registration options step of the wizard.