SQL Server does not exist or access denied error message

“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

Resolution

  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 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.

SQL Server Log Explorer稿源:SQL Server Log Explorer (源链) | 关于 | 阅读提示

本站遵循[CC BY-NC-SA 4.0]。如您有版权、意见投诉等问题,请通过eMail联系我们处理。
酷辣虫 » 后端存储 » SQL Server does not exist or access denied error message

喜欢 (0)or分享给?

专业 x 专注 x 聚合 x 分享 CC BY-NC-SA 4.0

使用声明 | 英豪名录