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

Question

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

Ricky Valencia

SSCommitted

Points: 1907
More actions
March 28, 2015 at 7:49 pm

#302531

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.

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

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

Eirikur Eiriksson SSC Guru Points: 182912 More actions · Answer 1

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

😎

Ricky Valencia SSCommitted Points: 1907 More actions · Answer 2

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.

Eirikur Eiriksson SSC Guru Points: 182912 More actions · Answer 3

Eirikur Eiriksson

SSC Guru

Points: 182912

March 29, 2015 at 8:39 am

#1787162

Check if UDP port 1434 is open in the firewall.

😎

Ricky Valencia SSCommitted Points: 1907 More actions · Answer 4

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

@SQLFRNDZ SSCrazy Eights Points: 9095 More actions · Answer 5

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]

ed.white SSC Enthusiast Points: 155 More actions · Answer 6

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.

Perry Whittle SSC Guru Points: 234013 More actions · Answer 7

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" 😉