Quick Maintenance & Backup for MS SQL
SQL server connection parameters
| Registering an SQL server > SQL server connection parameters |
Enter SQL Server connection parameters on this form.
SQL Server name – the name of the SQL Server (IP address entry also supported). To connect to a named SQL Server instance, enter its name in the following format: SqlServerName\InstanceName.
 |
If the SQL server uses a port different from the default one (1433), enter it after the name of the server separated with a comma. Example: SqlSrv,1500 |
You can connect to an SQL Server using Windows authentication or SQL Server authentication. The user connecting to the server must have sysadmin rights. Otherwise, a corresponding warning message will be shown.
When using Windows authentication, connection is performed on behalf of the user under whose name the service was started (LocalMachine\QmbServiceUser by default). This user must have sysadmin rights for all maintained SQL Servers. To grant permissions, open the SSMS console and connect to SQL Server. Then go to the Security ->Logins section and add a user with a sysadmin role.
When using SQL server authentication, you need to specify the name of the account with sysadmin rights (sa by default) and the password.
 |
When using the SQL Server authentication, make sure that mixed authentication (SQL Server and Windows Authentication mode) is enabled in SQL Server settings. To change the authentication mode, open the SSMS console, go to SQL Server Properties and change the authentication mode in the “Security” section. |
|
QMB stores SQL connection credentials in an encrypted form. |
To test the connection and access rights, click the Test connection button.