SQL. Server does not exist or access denied

Anderas Rønning 20 Reputation points

SQL. Server does not exist or access denied

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,251 questions
0 comments No comments
{count} votes

2 additional answers

Sort by: Most helpful
  1. Erland Sommarskog 98,731 Reputation points

    That error message means that you were not able to reach the SQL Server you were trying to connect to. It could be that you misspelled the server name, you were misinformed where the server was supposed to be, there is a firewall in the way and the list just goes on. Since you did not supply any context at all, I can only refer you to this general troubleshooter.

  2. ZoeHui-MSFT 30,411 Reputation points

    Hi @Anderas Rønning,

    Are you using the default instance? Are the instance listening on port 1433?
    If the SQL Server instance is a default instance and listen on port 1433, please ensure an exception is added to TCP port 1433 in the Windows firewall. If the default instance is listening on a non-standard port, Please refer to this article which might help.
    If the SQL Server instance is a named instance and listen on dynamic port, please make sure SQL browser service is indeed started and UDP port 1434 is not blocked on the firewall between the client and the server. If you cannot do either of them, you should switch your SQL Server instance to use a static port and add static port to firewall exclusion list.
    In addition, please check if there are incorrect alias on the client machine. Regards,

    Zoe Hui

    If the answer is helpful, please click "Accept Answer" and upvote it.

    0 comments No comments