SSMS 远程连接SERVER 设置

问题描述:

       新装了一台SERVER,在SERVER本地打开SSMS链接sever,一且正常。但是用我自己local去链接的时候出现以下错误。

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

解决方案:

      1. 在打开SERVER端 sql server configuration manger. 如果打开失败,按照这个步骤(http://www.cnblogs.com/Jesse-Li/p/7473195.html)操作。

      2. 找到: SQL Server Network Configuration 查看端口号, 一般都是1433

      3. Enable TCP/IP.

      4. 开发防火墙把这个端口号(1433)开放。(http://jingyan.baidu.com/article/f96699bbadafca894f3c1b7a.html)

原文地址:https://www.cnblogs.com/Jesse-Li/p/7486214.html