Description
- MS SQL not showing as available Data source in Backup Manager
- Device confirmed to be using MS SQL
Environment
- SolarWinds Backup And Recovery
- SolarWinds RMM
- Backup & Recovery
- SolarWinds N-central
- MSP Backup
- MS SQL Server (including Express Edition) 2005 and newer
Solution
- Confirm that SQL Server VSS Writer service has Status of "Started" and Startup Type set to 'Automatic'
- Press Windows Key + R
- Type services.msc
- Find the SQL Server VSS Writer
- From Command Prompt run vssadmin list writers and ensure that SqlServerWriter is present and stable
- If not stable Restart SQL server VSS Writer service and check again if it is not
- From the services.msc window in step one
- Right click the SQL Server VSS Writer and click Restart
- If not stable Restart SQL server VSS Writer service and check again if it is not
- Change permissions of SQL Server VSS Writer service to run as Administrator account
- From services.msc
- Right-click on SQL server VSS Writer service
- Click Properties > Log On tab, specify Administrator credentials
- Click Apply
- Restart following services from services.msc
- Cryptographic Services
- Volume Shadow Copy
- Microsoft Software Shadow Copy Provider
- Backup Service Controller
- Check Backup Manager to see if MS SQL data source now available