Online Documentation for SQL Query for SQL Server

Editing connection properties

The Connection section of the Database Registration Info dialog allows you to view and edit the 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: SQL Server Authentication or Windows Authentication. It is strongly recommended to avoid using SQL Server authentication with "sa" as the login.

Authorization settings: User name and Password.

If necessary, you can also select a different Database name or edit the Database alias - an optional name to display the database in the DB Explorer tree and all SQL Query tools.

This section of the Database Registration Info dialog also allows you to modify the Font Charset for the SQL Server database.