Skip to main content
  • EN

Hello everyone,
A customer of mine wants to restore the SQL backup taken on the VBR Server on a different server. There is no problem so far, but it wants to make the TCP - 1433, 1434 ports 1435 ports required in SQL Restore. Can he do this? If so, does anyone have information on how to do it?

Those ports would be required to be open on any firewalls and on the SQL box where you want to restore to.  Check this page - https://helpcenter.veeam.com/docs/backup/explorers/vesql_used_ports.html?ver=120

 

​@tarik.yenisey, SQL connection utility (native tool) supports custom port connections in the registry. See these topics, you’d place this on Veeam Server and Console Server you run the Application Restore Explorers from:

 

Feature request: Custom SQL port for database connection - R&D Forums
https://forums.veeam.com/post263916.html#p263916
SQL Restore Fails, TLS 1.2, custom port - R&D Forums
https://forums.veeam.com/veeam-backup-replication-f2/sql-restore-fails-tls-1-2-custom-port-t64894.html

 

Similarly, I know in some cases you can pass the port as part of the server connection string, I think it’s comma separated. E.g.,

 

my-sql-host.local,1816

my-sql-host.local;1816

 

But I’ve not done this in a bit, so please do some testing. But should be doable.

 

Comment


Terms & Conditions