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

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS

Comments

No Comments

Leave a Comment

(required) 
(required) 
Submit

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.
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement