SQL Server not seen

[sjmike]

For some reason retrospect does not want to see the SQL container on one our newest networked computers. However it recognizes it on the old system. The 2 systems with SQL Server 2000 running are using the 7.0.106 client. The backup system is running Retrospect 7.0.249 with a Multi Server License and the SQL Backup Add-on. All 3 systems are on Windows 2003. I even attempted to install Retrospect server locally on the problem system and it didn't see the SQL container either.

 

Any suggestions?

[AmyJ]

Hi -

 

I have seen reports that problems with the SQLDMO can prevent visibility of the SQL container. See if the following link provides any assistance:

 

Registering SQLDMO

 

Can the Enterprise Manager access the SQL instance?

 

Amy

[sjmike]

Hi Amy,

 

I registered the Sqldmo.dll like the link said, and deleted the client from Retrospect and re-added it afterwards and still have the same problem. The Enterprise Manager can access the SQL instance without any problems. Even the the SQL Server Service Manager can access / see it on all 3 systems. Just Retrospect can't see it on the newest system.

 

Any other suggestions?

[AmyJ]

I would try rebuilding the registry entries for SQL. Stop the SQL services and copy your SQL flat files - or run a backup with the Enterprise Manager - before doing anything. In fact, make a copy of your registry too. Better safe then sorry.

 

Rebuild SQL registry entries