SQL Server Does Not Exist or Access Denied Error Message

Stephen West ~ Modified: January 2nd, 2023 ~ SQL Server Error ~ 3 Minutes Reading

SQL Server Does Not Exist or Access Denied

 

“SQL Server does not exist or access denied” is an MDAC (Microsoft Data Access Components) message that shows the computer that is running the SQL Server cannot be connected.

The possible cause of getting this error are:

  1. SQL Server is running
  2. SQL Server does not exist or unavailable
  3. Remote connection is disabled for SQL instance
  4. Port is not added in the firewall exception list
  5. IP address of the instance is blocked

If users are also getting similar errors like dbnetlib connectionopen (connect()). SQL server does not exist or access denied, then below mentioned solutions can match their expectations perfectly. Just like this, there is one another issue that causes similar problem. This is the SQL Server login failed error 233 which is similar to this access denied problem.

Possible Solutions

1. SQL Server is running

First of all you need to check that if SQL Server is running or not.

For this enter “services.msc” command in the Run window.

SQL Server Does Not Exist or Access Denied due to service stop

2. SQL Server instance is not available or does not exist

Check the connection strings and make sure that you are trying to connect to correct server and it is available on the network.

3. Remote connection is not enabled for a SQL Server instance

To check remote connection is enabled or disabled, open SQL Server Management Studio -> Connect to SQL Server where it is installed using SQL Server Management Studio ->Go to SQL Server instance property and check Allow remote connection to this server.

Remote Connection

4. Port is not added in the firewall exception list

Sometimes “SQL Server does not exist or access denied” error message occurs when SQL Server remote connection is enabled, but the port is blocked by administrator for security purpose.

SQL Server instance works on port no 1433 (by default), so you need to check that the port exception is also added to the firewall.

To check the port exception follow below-mentioned steps:

      • Go to Control Panel -> Open Adminstrative Tool -> Select Windows firewall with Advanced Security.

Windows firewall with Advanced Security

      • From the left panel, click on the Inbound Rules and from right panel select New Rule.

New Rule

      • In New Inbound Rule Wizard window, select Port and click on Next button.

Select Port

      • In the next tab, enter ‘1433’ in Specific local ports and click on Next button.

Specific Local Ports

      • Under What action should be taken when a connection matches the specified condition? section, select Allow the connection option and click on Next.

Allow the Connection

      • Check Domain, Private, Public under which does this rule apply section? and click on Next.

Check Domain

      • Enter the Name and click on the Finish button.

Click Finish to solve SQL server does not exist or access denied

5. IP address of the SQL Server Instance is blocked the Firewall

To check SQL Server does not exist or access denied is occurring because of IP address, ping IP address on the command prompt like

Ping 100.10.10.10 –t

If you are getting response from the sever then it means there is no issue with IP Address blockage but if not, then you need to an add exception (see point 4 above).

Conclusion

In this article I have described the possible reasons for “SQL Server does not exist or access denied” error and also explained the solutions to resolve the error. In next tip we will discuss Microsoft SQL Server error 5171 and its possible solutions.