Post reply

SQL server 2005 remote connectvity

  • December 9, 2014 at 12:11 am

    #292698

    Hello,

    I am facing a problem while connecting to SQL instance remotely. It works fine on local server but when I try to connect remotely I have to specify port number. E.g. server\instance does not work rather I have to specify server\instance,2233. Browser service is running fine, Firewall is turned off and every other setting related to this fine. Below is the SQL server edition which is running on windows Server 2008 Standard:

    Microsoft SQL Server 2005 - 9.00.4060.00 (X64) Mar 17 2011 13:06:52 Copyright (c) 1988-2005 Microsoft Corporation Developer Edition (64-bit) on Windows NT 6.0 (Build 6002: Service Pack 2)

    Any suggesstions?

    Thanks,

  • December 15, 2014 at 2:58 am

    #1764667

    Hi,

    I am sure you must have already checked these things but still to re-iterate.

    1. Check the protocols under configuration manager.

    2. Check if you are able to ping the Server from to destination client.

    Regards

    Shafat Husain

    Regards,
    Shafat Husain
    🙂
    And Your Lord Never Forgets...!! (64:19 -- Quran)

  • December 15, 2014 at 7:10 am

    #1764717

    Thanks for your reply. I am able to ping thats why I am able to connect using port no. My problem is that I am not able to connect without using port no. , I’ve checked everything like SQL browser service, SPN, DNS, Active Directory, Ports, Firewall and every other possible thing. Our network team has informed that UDP port 1434 is open too. So i am out of ideas for solving this mystery.

  • December 15, 2014 at 7:33 am

    #1764727

    And it's definitely a named instance? The SQL Server Browser service only resolves ports for named instances.

    John

  • December 15, 2014 at 8:58 am

    #1764742

    That is correct, John. Its a named instance.

Viewing 5 posts - 1 through 4 (of 4 total)

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