Title: MSSQL 2005 Cannot browse database Netvault Backup window
Date: 11/2006
NV Version: 7.4.x
OS Version: Windows 2003
Application version: MSSQL 2005 server
Plugin version:4.500-2
Description:
Symptoms:
The database can be seen in the Netvault Backup window but Browsing server for backup gives "SQL Server does not exist or access denied" message in binary log.
Exerpt from Binary log:
Job Message 2006/11/10 10:54:02 16909060 Data Plugin BACK01-D10 ODBC message: [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied.
Job Message 2006/11/10 10:54:02 16909060 Data Plugin BACK01-D10 ODBC message: [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (Connect()).
Error 2006/11/10 10:54:02 16909060 Data Plugin BACK01-D10 Failed to login to SQL Instance 'test'
The server has either not been registered (within SQL server) or has been registered incorrectly (ie as a named server instead of a (local) server)
Correct the registration within SQL server and the database instance will appear in the Netvault Backup browse window.