SQL Server does not exist or access denied error message

存储架构 2016-04-20

“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


  1. SQL Server is running
  2. 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.

  3. SQL Server instance is not available or does not exist
  4. Check the connection strings and make sure that you are trying to connect to correct server and it is available on the network.

  5. Remote connection is not enabled for a SQL Server instance
  6. 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 .

  7. Port is not added in the firewall exception list
  8. 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:

  9. Go to Control Panel -> Open Adminstrative Tool -> Select Windows firewall with Advanced Security .
  10. From the left panel, click on the Inbound Rules and from right panel select New Rule…
  11. In New Inbound Rule Wizard window, select Port and click on Next button.
  12. In the next tab, enter ‘1433’ in Specific local ports and click on Next button.
  13. Under What action should be taken when a connection matches the specified condition? section, select Allow the connection option and click on Next .
  14. Check Domain , Private , Public under which does this rule apply section? and click on Next .
  15. Enter the Name and click on the Finish button.
  16. IP address of the SQL Server Instance is blocked the Firewall
  17. 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 –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).


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.

SQL Server Log Explorer

责编内容by:SQL Server Log Explorer (源链)。感谢您的支持!


Is there a SQL Server 2008 R2 development edition&... Is there an SQL Server 2008 R2 Developer Edition? I have read there is, but I on...
Azure SQL database auditing using Blob Storage SQL Server Indexing Tips and Tricks - Our next free MSSQLTips Webcast Proble...
Prepping SQL Server This is a “living document” for prepping an instance of SQL Server. Configurat...
I’m Speaking At SQL Saturday Richmond I am so excited, I was selected to speak at SQL Saturday Richmond on March 2...