Can't connect Backup Pro on non-default port

• 
  The error indicates that the SQL Backup Agent service was unable to connect to the local SQL Server instance. Assuming that only the TCP/IP protocol has been enabled on the server side, your options are as follows:
  
  - enable the shared memory protocol
  Enable the shared memory protocol for both the server and client configuration.
  
  - change the default port
  Using the SQL Server client configuration utility, change the default port to which TCP/IP connections are made on the server.
  
  - use an alias
  Set up a TCP/IP alias using the SQL Server client configuration utilities. The alias needs to be identical to the SQL Server instance name, and map it to the correct port number.
  
  - add a SQL Backup registry key
  In the registry node HKLM\Software\Red Gate\SQL Backup\BackupSettingsGlobal\<instance name>, add a string value named SQLServerName. Enter the server name/IP address and the port number e.g. 127.0.0.1,1435
  
  The first 3 options are SQL Server options, and would affect other applications running on the server. The last option is a SQL Backup specific option.
  
  Thanks.

  petey October 11, 2009 03:19

  - 0 +
• 
  Petey,
  Thanks for the tips. I went with the registry option and all is working well now on the non-standard port.
  
  --John

  john.vanda October 12, 2009 08:21

  - 0 +
• 
  Add a new SQL Server, then use SERVERNAME\INSTANCE,PORT to connect. You can then change the alias to just display the server name if you want your list to look clean.

  cgriffin December 14, 2010 16:22

  - 0 +

Add comment

Please sign in to leave a comment.