March 10, 2016 at 10:30 am
I would appreaciate some help for this connection issue:
I cannot connect to a server with "SQL Server name \ instance name", but no problem to connect to it with "SQL Server Name, port number" from other server, or from my pc through SSMS.
I checked the server, Brower service is running fine. Firewall is disabled. TCP / IP port is not standard 1433, but a fixed number.
It was ok week ago. Log files do not show the changes.
Thank you for your help
March 10, 2016 at 2:47 pm
Not to be snarky, but google "sql server non default port"
March 15, 2016 at 12:40 pm
Thanks, Jon.
Well, contacted Microsoft, and ran portqueryUi, it was found that UDP port was blocked inside the server.
Now the question is how can we know where it is blocked?
Thank you
March 15, 2016 at 3:08 pm
yan-160997 (3/15/2016)
Thanks, Jon.Well, contacted Microsoft, and ran portqueryUi, it was found that UDP port was blocked inside the server.
Now the question is how can we know where it is blocked?
Thank you
The UDP port required for a named instance is 1434, ensure this UDP port is not blocked
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 15, 2016 at 11:23 pm
Go to SQL Server Configuration manager > SQL Server Network Configuration > Protocol for MSSQLSERVER
> Enable Shared Memory
> Enable Named Pipes
> Enable TCP/IP
> Disable VIA
March 16, 2016 at 6:20 am
Depending on your OS you could open Resource Manager and look on the Network Tab, scroll down to listening ports.
Type resmon.exe into the Start Menu search box and press enter. Go to "All Programs -> Accessories -> System Tools -> Resource Monitor". Press Ctrl-Shift-Esc or Ctrl-Alt-Del on your keyboard, to open the Task Manager. Then go to the Performance tab and click on the Resource Monitor button
March 16, 2016 at 2:11 pm
Thank you guys for the reply. OS team and network team are both working on the issue.
I know that both teams did not touch the server, only developers touched it to modify and run some SSIS packages with Visual Studio 13.
Now my question is: as a DBA, we can monitor the UDP port? Which component exactally is used for UDP port in SQL Server? I suspect that something is corrupted for Browse service to listen the UDP port. Is that possible to repair it ?
March 17, 2016 at 1:26 am
Is this clustered?
March 17, 2016 at 8:24 am
no, it is not clustered. Thank you for asking.
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply