THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Ben Miller

Windows Vista client connecting to SQL 2005 Cluster on Windows 2008

There have been a couple of issues that keep pestering the SQL Server community for those that use Vista as their client. 

Example: SQL Protocols Blog entry

Now Microsoft has created a KB on it:  http://support.microsoft.com/kb/936302

I have tried and tested a solution that fixes this, and it is related to the KB, that was not available for some reason when I originally had the problem.  So the steps that I took to solve it are as follows:

  • Open Windows Firewall in Control Panel
  • Go to the Exceptions Tab
  • Click on Add Program
  • Find SQL Server Management Studio and click OK
  • Test the connection

I did this several times with enabling and disabling the firewall and having consistent results that I could now connect to the Windows 2008 Cluster that had SQL 2005 Failover Instances on it.  I then went to a colleagues workstation and it fixed it as well.

Published Friday, February 13, 2009 10:58 AM by dbaduck

Comments

No Comments
New Comments to this post are disabled

About dbaduck

Ben Miller is a Senior Database Administrator for HealthEquity in Draper, UT. He has been working with SQL since SQL Server 6.0 (1998) and has had a variety of roles in his career, including SQL Support and MVP Lead at Microsoft.
Privacy Statement