SUMMARY
RRC does not see SQL instance for Windows XP
ISSUE
Purpose
To explain why the RRC does not see SQL on a XP machine
Applies To
Windows XP running any version of SQL
Description
There is a XP machine connected to the DPU that is running SQL but the RRC does not show the SQL instance.
Cause
XP machines do not have the VSS writer for SQL by default from Microsoft. Our client uses the VSS writer for SQL to take snapshots of the SQL instance but cannot see the VSS writer so it will not show up in the RRC.
Resolution
The resolution for this is to use the maintenance plans for the SQL server from Microsoft to take backups of the databases then use our product to backup the .bak file that it creates. If a restore needs to be accomplished you can restore the .bak file from the DPU and then use the maintenance plan to import that .bak file and recreate the database.