Post reply

I am unable to connect the SQL instances without giving port number.

  • January 20, 2014 at 11:43 am

    #303128

    Hi All,

    I am unable to connect the SQL instances without giving port number. I am getting below error.

    Please help me on this and let me know why its happend

    A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) (Microsoft SQL Server, Error: -1)

  • January 20, 2014 at 11:50 am

    #1681654

    I got the result ..... i started the browser it started connecting..:laugh:

  • January 20, 2014 at 3:51 pm

    #1681690

    rajeshjaiswalraj (1/20/2014)

    I got the result ..... i started the browser it started connecting..:laugh:

    Some would say that's a bad thing. Hackers use the presence of Browser to more easily find servers.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

  • January 21, 2014 at 6:38 am

    #1681869

    If you're connecting to SQL 2005, sometimes you get this when you're network admin has blocked UDP 1434 as protection against the SQLSlammer worm.

    ..and that would happen even if the Browser service is started.

    Connecting to SQL2008 and above won't give you this problem, even if UDP 1434 gets blocked. Later versions connect using TCP 1434. But you still need to specify the port if the browser service isn't running 🙂

    [font="Courier New"]sqlmunkee[/font]
    [font="Courier New"]Bringing joy and happiness via SQL Server since 1998[/font]

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

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