We having some strange performance issues with one or our SQL 2005 servers. Let me explain:
We have two Windows 2003 servers with MS SQL 2005 standard edition loaded. (server1, server2)
We have some workstations with XP Pro and some with Vista Ultimate loaded.
Using an XP PRO client machine we can connect to either server with NO performance issues.
If I use a VISTA machine, I can connect to server2 with NO performance issues, but if I try to connect to server1 the performance is extremly slow.
Its slow trying to setup an ODBC connection or even connecting with the SQL Management Studio. I've even tried using the SQL Native Client, but it gives me a time out error on Server1.
Since both servers work on XP, and only server1 as a problem with VISTA, we've concluded that the problem is on server1.
We checked every setting that we think of, and I tried some suggestions from the 'net but so far no luck.
I would appreciate any suggestions that anybody has to offer. Thanks.
We have two Windows 2003 servers with MS SQL 2005 standard edition loaded. (server1, server2)
We have some workstations with XP Pro and some with Vista Ultimate loaded.
Using an XP PRO client machine we can connect to either server with NO performance issues.
If I use a VISTA machine, I can connect to server2 with NO performance issues, but if I try to connect to server1 the performance is extremly slow.
Its slow trying to setup an ODBC connection or even connecting with the SQL Management Studio. I've even tried using the SQL Native Client, but it gives me a time out error on Server1.
Since both servers work on XP, and only server1 as a problem with VISTA, we've concluded that the problem is on server1.
We checked every setting that we think of, and I tried some suggestions from the 'net but so far no luck.
I would appreciate any suggestions that anybody has to offer. Thanks.