SQL Server Configuration Troubleshooting

Troubleshooting your server configuration is a straightforward and simple process. Follow the steps below if:

• You receive an error message stating Cannot Open Backup Device Operating System Error 5(Access is Denied) when you try to restore a backup database
• SQL Server connections fail (Quantify cannot connect to the SQL Server database)

First, restart your computer. This usually resets the system, allowing you to log in.

If that doesn't work, follow the instructions below.

1. Click the Windows button or magnifying glass
   
2. Search for Computer Management
   1. Open the Control Panel.
   2. Search for and click Computer Management
      
      The Computer Management dialog appears.
3. Expand Services and Applications
   
4. Expand SQL Server Configuration Manager.
   
5. Click SQL Server Services and you'll find SQL Server (MSSQLSERVER).
   
6. Right-click SQL Server (MSSQLSERVER) and select Properties from the menu that appears.
   
   The SQL Server (MSSQLSERVER) Properties dialog appears
   
7. Do one of the following:
   • If the Service Status at the bottom does NOT read Running, click Start.
   • If the Service Status at the bottom does read Running, click Stop and then Start.
8. Click OK when you are done.
   The Computer Management dialog returns.
9. Expand SQL Server Network Configuration and click Protocols for MSSQLSERVER.
   
10. Right-click Named Pipes and select Enabled from the menu that appears.
    
11. Right-click TCP/IP and select Enabled from the menu that appears.
12. As necessary, restart SQL Server Services.
13. Close the Computer Management dialog.