Can't connect SQLServer using "INTEGRATED SECURITY=SSPI"

[Liu Feng]

Hi,

I want connect SQLServer in InfoPath, but prompt connecting is timeout,
"Timeout expired. The timeout period elapsed prior to completion of the
operation or the server is not responding"
The same code can work in a WinForm application.

code:
string connstr = "SERVER=\"LIUFENG2\";DATABASE=\"A2K\";INTEGRATED
SECURITY=SSPI;POOLING=TRUE;";
SqlConnection sql = new SqlConnection(connstr);
sql.Open();

liufeng2 and junwei be in a domain, the code will got the different results
of running in a different user name.
1. user name(alias): liufeng2, WinForm, can work.
2. user name(alias): junwei, WinForm, can work.
3. user name(alias): liufeng2, InfoPath, can work.
4. user name(alias): junwei, InfoPath, can't work.

How do I resolve 4th? (Please don't change the connection string)




--


Thanks,
LiuFeng
MSN Messenger: (e-mail address removed)

 

[Franck Dauché]

Hi Liu,

Did you try to increase the default timeout in InfoPath for the
dataconnection. See 2 posts on the issue today in this forum.

Regards,

Franck Dauché

 

[Liu Feng]

Thank you, I resolved the problem. Windows Firewall play tricks. I add the
instance of SQLServer for exceptions.

--


Thanks,
LiuFeng
MSN Messenger: (e-mail address removed)
Hi Liu,

Did you try to increase the default timeout in InfoPath for the
dataconnection. See 2 posts on the issue today in this forum.

Regards,

Franck Dauch¨¦