How can I configure SQL Server to listen on multiple TCP/IP ports

SQL Management Studio Ports

Port / December 31, 2021

We have a client here at SherWeb that had SQL 2000 Express instance installed on their Windows 2003 Standard Edition x86 server. They recently installed SQL 2008 R2 Express Edition on this server and wanted to be able to access this new instance remotely “SQLEXPRESS”.

To accomplish this, we launched the SQL Server Configuration Manager for the SQL Server 2008 R2 Express installation. We navigated to SQL Server Network Configuration > Protocols section and edited the properties of the TCP/IP Protocol. On the Protocol tab, we set the Enabled to Yes, Keep Alive remains default 30000, and Listen All to No. We only wanted this to be available on the primary IP address.

Next, on the IP Addresses Tab we made sure that the Primary IP was set to Active Yes, Enabled Yes, we removed the TCP Dynamic Ports 0, and set the custom TCP Port 1435. We also set the IP All to 1435 static as well.

(IP addresses and hostnames are removed to protect client confidentiality)

In order for these changes to take effect, we restarted the SQL 2008 R2 Express instance Service and the SQL Browser Service as prompted.

On our gateway firewall we opened up the SQL Browser port (1434) and the new custom port (1435) to the server from any source. This would allow the client to access the SQL instance by, “IPSQLEXPRESS”. An external port scan was completed and verified that the ports 1434, and 1435 were remotely accessible to the host.

Next, we launched SQL Server Management Studio on an off-domain remote test host and attempted to make a connection, “IPSQLEXPRESS, but it failed:

After a couple of tries were unsuccessful, we moved on to troubleshooting. We installed Microsoft’s Network Monitor utility on the server. Then on our test machine we found its current public IP address (a quick Google search on “what is my ip” or www.whatismyip.com).

Then we launched Network Monitor on the server, selected New Capture, then selected Capture Settings. In the text field we entered the public IP address of our test machine: “IPv4.Address == (Public IP)”, so that only traffic from that server would be captured. Then click close.

pets art pintler pets craigslist pets nashville tn pets in adopt me craigslist asheville pets homegrown pets petsmart pets homemade weed killer safe for pets craigslist pets bakersfield adopt me mythical egg pets irresistible pets pets plus robot pets chillicothe ohio craigslist pets las cruces craigslist pets craigslist nh pets yakima craigslist pets craigslist las cruces pets otters as pets wonder pets dailymotion legendary adopt me pets petooties pets craigslist pets indiana sims 4 pets desktop pets craigslist humboldt pets mel the secret life of pets pictures with pets advantage pets do hedgehogs make good pets noahs ark pets craigslist cleveland pets cremation services for pets wow best battle pets phoenix craigslist pets prehistoric pets pets wow cincinnati craigslist pets craigslist monterey pets lost and found pets of the midsouth craigslist greenville sc pets boise craigslist pets craigslist raleigh pets adopt me pets wonder pets save the reindeer pets in adopt me petooties pets lost and found pets corvids as pets chinchilla pets pillow pets appa entirely pets pharmacy pets without parents craigslist muskegon pets pets supermarket best birds for pets best battle pets wow snowball the secret life of pets lol remix pets true care for pets lists of pets zoo zoo pets small animal pets craigslist corpus christi pets cheetahs as pets forest lake pets a to z pets mcallen craigslist pets craigslist pets bakersfield dog tags for pets wonder pets toys everything pets how long do rabbits live as pets world of pets cbd oil for pets alabama craigslist pets pets in need gaiser pets craigslist atlanta pets pets alive craigslist pets tennessee exotic pets you can own pets alive toys stockton craigslist pets

Source: www.sherweb.com