菜鸟提问：关于webservice的数据连接

[gugu1981]

小弟初学webservice，请各位大虾指点一下。呵呵

调用webservice时候连接数据库时报错：System.Web.Services.Protocols.SoapException: Server was unable to process request. ---> System.Data.SqlClient.SqlException: 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.

但是单独调用webservice的asmx文件测试时候，都可以通过的。
调用的代码很简单：
private Hotel.Service ser;
private CTSCHotel ser1;
ser = new Hotel.Service();
ser1 = ser.getHotelByHtlId(99064);
跟踪后发现在SqlConnection对象的open方法报错

webservice部分代码：
[WebService(Namespace = "Hotel")]
[WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)]
public class Service : System.Web.Services.WebService
{
public Service () {

//Uncomment the following line if using designed components
//InitializeComponent();
}

[WebMethod]
public string HelloWorld() {
return "Hello World";
}

[WebMethod]
public CTSCHotel getHotelById(int Id)
{
CTSCHotel test = new CTSCHotel();
test.getHotelById(Id);
return test;
}

[WebMethod]
public CTSCHotel getHotelByHtlId(int htlId)
{
CTSCHotel test = new CTSCHotel();
test.getHotelByHtlId(htlId);
return test;
}

[chouer523]

不明白你的意思 你可以說得清楚店嗎

[fanliang11]

SqlConnection 是否已经打开,或者连接的数据库是否出错
把错误信息贴出来

[forever9918]

the default settings SQL Server does not allow remote connections

[丰云]

所谓的open方法就是连接问题，sql2005对安全检查要求很严，你还是调试你的连接字符串吧

[gugu1981]

连接字符串没有问题啊。在webservice那个工程里面都可以打开的

[gugu1981]

up

[gugu1981]

Up

[sbsrg3000]

没用过2005....