Post reply

Unble to connect named clusterd instance from SSMS of SQL Server 2008 R2

  • June 2, 2010 at 3:32 pm

    #223363

    I'm able to connect the named clustered instances with out providing port number (virtualSevrerName\instance) from SSMS (SQL Server 2005) from Windows 2003 but NOT from the SSMS (SQL Server 2008 R2) of Windows 2008 Server

    On Windows Server 2008, if I give the port number (virtualSevrerName\instance, port), then it's allowing me to connect. We have named clustered instance with dynamic ports.

    Please advice

    Thanks

  • June 3, 2010 at 5:02 pm

    #1176245

    I followed the below link and turned off the Windows firewall on Windows Server 2008 and then I'm able to connect the named clustered instance without giving port number from SSMS

    http://support.microsoft.com/kb/944390

  • June 3, 2010 at 5:12 pm

    #1176249

    Thanks for the followup.

    A clustered instance (named or not) has it's own computer name, and you should be able to connect to that instance with just that.

    Wayne
    Microsoft Certified Master: SQL Server 2008
    Author - SQL Server T-SQL Recipes

    If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
    Links:
    For better assistance in answering your questions
    Performance Problems
    Common date/time routines
    Understanding and Using APPLY Part 1 & Part 2

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply