Online Documentation for SQL Manager for SQL server

Setting connection properties


Use this step of the wizard to set the necessary connection parameters for the database being created. Use the corresponding boxes and options: Server name, Authentication, User name and Password.

 

Create Database Wizard - Setting connection properties

 

 

Specify the host where the database being created will reside: type in the host name in the Server name field or select one in the drop-down list.

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

 

Authentication type

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.

 

If 'SQL Server' has been selected as the authentication type, you should also provide authorization settings: User name and Password.

 

 

Click the Next button to proceed to the Defining database files step of the wizard.