December 18, 2014 at 2:11 pm
This is my first SQL2014 install. We want to have it listen on a different port than the default. I have followed these instructions but after I change it when I attempt to connect via Mgt Studio on my PC I can no longer connect. When SQL Server starts on the server it says it is listening on the new port and I start SQL Browswer as well. What am I doing wrong?
December 18, 2014 at 2:16 pm
what happens if you try connecting with
computername, portnumber
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 18, 2014 at 2:33 pm
could you also post the output of this run from a command prompt
netstat -anp TCP
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 18, 2014 at 6:20 pm
Markus (12/18/2014)
This is my first SQL2014 install. We want to have it listen on a different port than the default. I have followed these instructions but after I change it when I attempt to connect via Mgt Studio on my PC I can no longer connect. When SQL Server starts on the server it says it is listening on the new port and I start SQL Browswer as well. What am I doing wrong?
You could check Firewall and make sure that open your port to allow connections to SQL SERVER.
December 19, 2014 at 5:10 am
Dang... my bad.... I was attempting to connect to the server with servername:portnumber.... not servername,portnumber
Thanks for the help!
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply