connectionString="Data Source=server;Initial Catalog=db_name; Integrated
Security=SSPI " providerName="System.Data.SqlClient".
I get an error for timeout.
I tried to connect with ODBC from WEBSERVER to SQLSERVER with the custom
service account I created & integrated security and it works fine. I can view
the data of stored procedures. So there is no problem with permissions of
custom service account.
What could be the problem ? In application pool the configurable identity is
"SQLSERVER\TestUser". The SQL server login is "SQLSERVER\TestUser" with same
password. What have I missed ?
Thanks a lot in advance!
George.
"chris" <ch...@discussions.microsoft.com> wrote in message
news:94AAB872-8BB1-4352...@microsoft.com...
Does custom service account require a different port than 1433 ?
The problem is that SQL server allows 2 way connections
1. Named Pipes
2. TCP/IP
Try to add following to your connection string
Network Library=DBMSSOCN;
I am not sure but with Integrated Security=SSPI provider might try to force
the Named Pipes connection. And you need totally different ports open on
firewall for that.
George.
"chris" <ch...@discussions.microsoft.com> wrote in message
news:D8AA0F40-EC43-481A...@microsoft.com...
It seems that custom service account needs more time for connecting....