vs.2005下开发的aspx 连接sql server 2000 提示:不允许远程连接
有个2005下开发的程序数据库是连接到另外一台的服务器的sqlServer 2000,连接字符串是
<add name= "ConnectionString " connectionString= "server=fanfang;database=servicseTrackerDB;uid=sa ;pwd= ' ' "
providerName= "System.Data.SqlClient " />
把程序部署到服务器(win server2003 sp1)上就提示:databaseAn 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: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) 但是放在我的电脑上的iis,程序运行一切正常,而且还有一个问题是之前我只把程序放到iis下,没有映射域名来访问(http ://192.168.18.8/server),程序正常.在我把程序放到服务器并映射了域名就出现问题了.
------解决方案--------------------1.检查外围配制里开启远程服务
2 注意目录权限