Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2005 Forums  Other SQL Server Topics (2005)  ipsec win7 sql2005 problem

Author  Topic  geka22 Starting Member 1 Post Posted - 2010-09-18 : 05:28:35 I have windows 2000 domain. Ipsec is configured to protect traffic on port of microsoft sql server (1433). Also, we have .net 2.0 application, and we use ADO to connect to microsoft sql server 2005. Everything works ok in windows 2000/xp. But in windows 7 we have very slow responses from sql - server when using direct sql-queries. That's not the problem of the server. When I turn off ipsec-policy, which requires security with kerberos authentication, on server side, everything works well. Ipsec-policy is provided through group policy to the clients and the policy is 'request security' ipsec diagnostic tool does not show anything useful. Sniffer also, because sql-queries are packed into ipsec. Another application, which uses odbc and written in visual c, works fine. We are trying to resolve problem ourselves. And we performed some tests. Here is he result. We've got windows 7 with microsoft sql 2005 management studio installed (client tools). And when we try to execute the same sql-statement through the studio several times, each time the response time from the server INCREASES. But when we turn on showing "execution plan" there is no delays. That's strange. However, no problems in xp/2000. Have not tried in Vista, because does not have any. MS sql 2005 x64 used. sp3 installed. Ipsec disabling on server side resolves the problem.