---
title: "SQL Server Configuration Troubleshooting"
slug: "sql-server-configuration-troubleshooting"
updated: 2023-08-07T13:58:50Z
published: 2023-08-07T13:58:50Z
canonical: "docs.avontus.com/sql-server-configuration-troubleshooting"
---

> ## Documentation Index
> Fetch the complete documentation index at: https://docs.avontus.com/llms.txt
> Use this file to discover all available pages before exploring further.

# 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  
![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/7923b4f0-d267-4e35-bf9f-2d4e123cd9ed.png)
2. Search for Computer Management
  1. Open the Control Panel.
  2. Search for and click Computer Management  
![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/e90fa30a-1c8a-4e25-bf8f-5f70b4feffd1.png)  
The *Computer Management* dialog appears.
3. Expand **Services and Applications**  
![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/b0c578e0-6302-4210-8832-917b4b8813fd.png)
4. Expand **SQL Server Configuration Manager**.  
![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/6ac54e81-834c-4cd2-923b-fdf209563083.png)
5. Click **SQL Server Services** and you'll find **SQL Server (MSSQLSERVER)**.  
![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/c981cd41-bc1d-4dda-a554-1392637a5da9.png)
6. Right-click **SQL Server (MSSQLSERVER)** and select **Properties** from the menu that appears.  
![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/d7aed827-cbdd-4098-bbe9-cbd23e9ac08e.png)  
The *SQL Server (MSSQLSERVER) Properties* dialog appears  
![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/358d6194-4b24-4cc6-9706-6ab9807ab067.png)
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**.  
![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/52b270bf-63a6-4a3c-8cff-02ee4b425f5a.png)
10. Right-click **Named** **Pipes and** select **Enabled** from the menu that appears.  
![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/fa882820-3ee8-42a9-8f5a-8ba3db182ced.png)
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.