SureBackup SQL Script Verification

KB ID: 1249
Products: Veeam Backup & Replication
Version: 5.x
Published:
Last Modified: 2016-09-13

Challenge

Port 1433 is not enabled on the SQL server or there is a firewall preventing the server from establishing a connection to port 1433. SureBackup jobs will fail if they cannot establish a connection on the correct port.

Cause

Port 1433 is disabled on the SQL server or there is a firewall preventing port 1433 from being used to communicate with the SQL server.

Solution

The SQL Server Configuration Manager provides basic configuration management for SQL Server services, server protocols, client protocols and client aliases.

On the SQL Server Instance you will need to ensure the TCP/IP Protocols is listening on port 1433 for the TCP port. You may also need to list this port for the TCP Dynamic Ports.

If you have changed this port for some reason, you will need to deploy a custom script for the verification section in SureBackup. After performing the script change in production, please perform another backup job for verification.

More Information

Confirm the status of this port by performing "netstat -ban" on the masqueraded SQL server, from the command prompt.

For information on deploying a custom script please review this Veeam article: 
http://www.veeam.com/KB1312

4 / 5 (3 votes cast)

Report a typo on this page:

Please select a spelling error or a typo on this page with your mouse and press CTRL + Enter to report this mistake to us. Thank you!

Orphus system