Unable to Connect To SQL Server DB Instance if Port Number is not Included

  • Hi

    If I try to connect to ServerName\I01, I get the error below.

    "A network-related or instance-specific error occured 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"

    However, if I include the port number as in ServerName\I01, 3150, I'm able to connect successfully.

    What could be the issue?

    Thank you.

  • mahikero (3/28/2015)


    Hi

    If I try to connect to ServerName\I01, I get the error below.

    "A network-related or instance-specific error occured 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"

    However, if I include the port number as in ServerName\I01, 3150, I'm able to connect successfully.

    What could be the issue?

    Thank you.

    Check if SQL Server Browser service is running and active

    😎

  • Hi Eirikur Eiriksson,

    Thanks for your reply.

    the SQL Server Browser is running and active.

    By the way, Im trying to access the ServerName\I01 instance from a different server within the same domain.

    There are 8 existing production databases in that domain but I dont have any issues in terms of connectivity.

    I just recently installed this production database (ServerName\I01). According to our clients' Network team,

    they said that they have opened the firewall/port of this new database already.

    I just couldn't figure out why, when Im trying to connect to the new instance from a different server within the

    same domain, that I have to include the port number (ServerName\I01, 3150) in order to be able to connect.

    Thank you.

  • Check if UDP port 1434 is open in the firewall.

    😎

  • Hi Eirikur Eiriksson,

    Thanks for you reply.

    Okay. I will check with our client's network team whether or not they have opened UDP port 1434.

    I will send an update soon.

    Thank you.

    Best Regards

  • This sounds to me your server is configured to run on specific static port number, check under sql server configuration manager > network protocals> tcp/ip > ports.

    [font="Tahoma"]
    --SQLFRNDZ[/url]
    [/font]

  • Make sure SQL Browser service is running using port 1434. This service is the one to tell the client what Port number the instance is using.

    I still see port 1434 being blocked by the firewall, a left over from the SQL Slammer issue.

  • mahikero (3/28/2015)


    Hi

    If I try to connect to ServerName\I01, I get the error below.

    "A network-related or instance-specific error occured 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"

    However, if I include the port number as in ServerName\I01, 3150, I'm able to connect successfully.

    What could be the issue?

    Thank you.

    Correct syntax is connect either

    ServerName\I01

    or

    ServerName, 3150

    Not both. As already mentioned check that you also have the following ports open if a firewall has been implemented

    TCP 1433, 1434

    UDP 1434

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

Viewing 8 posts - 1 through 7 (of 7 total)

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