Online Backup for Microsoft SQL 2005
and SQL 2005 Express

 

Online Backup for Microsoft SQL 2005 and SQL 2005 Express

Troubleshooting /  Error Messages

Problem
If you try to backup a remote instance of Microsoft SQL 2005 or SQL Express 2005, it may fail with the following error:

"SQL server does not exist or access denied. ConnectionOpen (Connect( )).SQL:exec xp_msver ProductVersion)"

Reason
The remote SQL Server instance may not be configured for remote connections.

By default, SQL Server Express 2005 is installed (configured) only for local connections.

By default, MS SQL Server 2005 is installed (configured) for remote connections, but this might have been changed.

Workaround
Use the SQL 2005 "Surface Area Configuration for Services and Connections" tool:

1. Start > All Programs > Microsoft SQL Server 2005 > Configuration Tools > SQL Server Surface Area Configuration > Surface Area Configuration for Services and Connections.

2. Browse the Instance tree for Database Engine > Remote Connections. Select “Local and remote connections” and “Using TCP/IP and named pipes”.

3. Start SQL Browser service on the remote server.

Note: This does not apply to local SQL Server instances (residing on the SecuriData Online Backup host machine).

-----------------------------------------

Problem
64-bit Windows SecuriData Online Backup Service fails to create a new MS SQL Server backup set (in New Backup Set Wizard) with the following popup error:

"Runtime Error!

Program: c:\program files\Data Storage\DS-Client\dsclient.exe

R6034

An application has made an attempt to load the C runtime library incorrectly.

Please contact the application's support team for more information."

Reason
This is a Microsoft Bug with MS SQL Server 2005.

The 64-bit MS SQL Server 2005 release (prior to Service Pack 1) has a problem with native 64-bit applications that use SQL-DMO (SQL Distributed Management Objects).

Solution
The MS SQL Server 2005 minimum requirement for SecuriData’s Online Backup Service is Service Pack 1.

Use 64-bit MS SQL Server 2005 Service Pack 1 for the SecuriData online backup service database.