Please enable JavaScript to view this site.

SQL Backup Master Help

Navigation: Backups > Backup Job Editor

Connecting to SQL Server

 Scroll Prev Top Next More

The server name field is used to specify the fully qualified name of the SQL Server instance to which you wish to connect. This field can be a computer host name, or a combination of host and instance name.

 

Example server names:

 

•(local)\SQLExpress - Specifies the default SQL Express named instance on the local computer.

•(local) - Specifies the local SQL Server installation (without an instance name).

•Server1\SQLExpress - Specifies the default SQL Express names instance on a remote computer named "Server1".

•Server1 - Specifies an unnamed SQL Server instance on a remote computer named "Server1".

 

Clicking the drop-down arrow associated with the server name field will cause SQL Backup Master to build a listing of any SQL Server instances it can find on the local machine and/or network. Note that remote SQL Server instances need to have the SQL Server Browser feature installed and enabled in order to be discovered in this manner.

 

You can also specify logon information for the selected SQL Server instance. The following options are available:

 

•Windows authentication - Choose this option to authenticate to SQL Server using a Windows account.

•SQL Server authentication - Use this method if you have SQL Server Authentication enabled on the selected SQL Server instance and wish to specify a username and password to log on.

 

Use the Test SQL Connection button to ensure proper connectivity, and then click the OK button to proceed.

 

Connection Options

 

The following options are available when configuring your SQL Server connection.

 

•Encrypt connection - Forces encryption of the connection to SQL Server.

•Trust server certificate - Encryption will use a self-signed server certificate without validation if no verifiable certificate has been provisioned on the server

 

Note that not all versions of SQL Server support the above options. Please see your SQL Server product documentation for details.

 

Advanced

 

The advanced tab offers the ability to run SQL Backup Master using a Windows Managed Service Account.

 

For configuration details, please see this page of our product website:

 

https://www.sqlbackupmaster.com/support/managedserviceaccount