Solution - Cannot connect remote via Veeam Client

[Stevester]

Good Day Everyone,

The solution to the issue where one cannot connect remote via the Veeam Client has been solved. I did two things. From the SQL Server Configuration Manager:

a) Enabled SQL Server Browser

b) Enabled VIA in protocols

This seemed to have worked for me. Just wanted to share.

Thanks
Steve

[Vitaliy S.]

Hello Steve,

Thank you for posting the resolution on our forums, this is very useful information. Glad that you're up and running right now.

[simm0]

I also had this issue and found it was linked to SQL connectivity and firewall settings.

You must have:

SQL Server browser enabled.
IP protocol enabled.
SQL set to use fixed IP ports, SQL 2005 Express defaults to using dynamic ports.
Firewalls configured to pass both the SQL server instance port and the SQL server browser port (1433 & 1434 are the defaults).

For more information the following link is excellent:

http://msdn.microsoft.com/en-us/library/ms175043.aspx

HTH,
Simon.