x****9
发帖数: 2 | 1 下面两行程序在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'. |
|
y*****g
发帖数: 677 | 2 I am using sql server 2008 R2 management studio,
whenever I connect to remote sql server,
I always get "cannot generate SSPI context",
I uninstalled and reinstalled the studio, still didn't work.
Is something wrong with my windows AD account?
I am using Windows authentication.
Can somebody help? |
|
|
|
D***a
发帖数: 516 | 5 amp抗性的质粒可以选择scaI或PvuI
kan抗性的可以选择puvI，NruI或SspI
都是细菌抗性基因上的位点。 |
|
q**j
发帖数: 10612 | 6 This is my code for connecting to sql 2005
library(RODBC)
Connection = odbcDriverConnect("Driver=SQL Server;Server=;
Initial Catalog=;Integrated Security=SSPI;UID=;PWD="
)
Q = paste("your statements",
sep = "")
Link = sqlQuery(Connection,Q)
close(Connection) |
|
