I cannot coonet to remote sql server

Nikon Green 20 Reputation points
2023-04-26T05:31:29.64+00:00

The error said that make sure instance name is correct and enable the remote server. I'm sure the name is correct and remote server is enbaled

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,702 questions
SQL Server Other
0 comments No comments
{count} votes

Accepted answer
  1. ZoeHui-MSFT 41,491 Reputation points
    2023-04-26T05:44:00.2166667+00:00

    Hi @Nikon Green,

    It seems that you are getting the error message like:

    A network-related or instance-specific error occurred while establishing a connection to SQL Server. Verify that the instance name is correct and that SQL Server is configured to allow remote connections

    Please check it out here for details.

    A network-related or instance-specific error occurred while establishing a connection to SQL Server

    Do not forget to restart the server.

    Regards,

    Zoe Hui


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

    0 comments No comments

1 additional answer

Sort by: Most helpful
  1. Olaf Helper 47,436 Reputation points
    2023-04-26T05:49:49.4033333+00:00

    That's really to less on informations to assist your. See https://learn.microsoft.com/en-us/troubleshoot/sql/database-engine/connect/resolve-connectivity-errors-overview for a step-by-step guide.

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.