下麵兩行程序在console application上運行成功,但在web service proxy裏麵卻不行。
為什麽?
SqlConnection ucidConn = new SqlConnection("Data Source=localhost\\MYSQLENGINE
; database=xxx; Integrated Security=SSPI;Initial Catalog=xxx");
ucidConn.Open();
in proxy: (suppose above codes is class A method B)
[WebMethod]
a = new A();
a.B()
結果拋出異常:
System.Data.SqlClient.SqlException: Login failed for user 'ItIsMe'.
如果用管理員賬戶,即用uid=sa;pwd=;代替Integrated Security=SSPI,則是:
System.Data.SqlClient.SqlException: Login failed for user 'sa'. Reason: Not
associated with a trusted SQL Server connection.
而且將來deploy時並不想用sa,而用用戶自己的credential校驗。
上麵code或configurations哪裏不對了?搞死了~~
--