November 28, 2004 at 11:40 pm
At one of my client location, when the system reboot occurred, SQL Server started automatically as configured. But on this particular occassion the Port address that it started with changed from 1411 to 3306. Previous shut down this never happened. What could be the reason that SQL Server changed the Port Number. All the client application stopped working and the user did reboot of the Server. Have not been able to figure out why All the client machines stopped suddenly and why SQL Server assigned a new port?
Thanks in advance for the help....
S.Krishnan
November 29, 2004 at 1:07 am
When SQL Server starts up, if it cannot use the port it has been assigned, then it will dynamically allocate itself a different port.
I've seen this on several occasions. Most times were when a SQL Agent job was running xp_cmdshell, and seemed to become unresponsive. Restarting SQL Server didn't clear the process, and SQL Server came up using a different port number.
It obviously writes the port number to the registry, because even after re-booting the whole server, it still used that new port number.
Changing the port number back to what it should be using Server Network Utility worked, and it came backup with the correct port the next time SQL Server was restarted.
November 29, 2004 at 9:00 pm
Thank you Ian....
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply