SQL Server Management Studio 直接连接 SQL SERVER 2000默认实例(8.0.2039) 没问题.
SQL SERVER 2000再创建一个实例,这个实例在打补丁前可以连接,但是SP4后(version 8.0.2039)SQL Server Management Studio 连接就会报错了 An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) (.Net SqlClient Data Provider) 奇怪的是 用SQLSERVER 2000的 SQL Server Enterprise Manager 连接是可以的~~
SQL SERVER 2000再创建一个实例,这个实例在打补丁前可以连接,但是SP4后(version 8.0.2039)SQL Server Management Studio 连接就会报错了 An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) (.Net SqlClient Data Provider) 奇怪的是 用SQLSERVER 2000的 SQL Server Enterprise Manager 连接是可以的~~
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货