Add 2nd port

[williey]

added a 2nd port other than 1433 using sql server configuration manager.

After restart sql server, I cannot connect to sql server using the new port. Connection through the default port 1433 works fine.

There is no firewall running. What am I missing?

------------------------------------------
There are 10 kinds of people in this world. One that understands binary and the other one that does not.

 

[mrdenny]

Can you telnet to the new port number? What does SQL Server say in the ERRORLOG after you restart the service?

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

My Blog

 

[mrdenny]

Also, try creating a new endpoint to listen on the new port number.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

My Blog

 

[williey]

Thanks guys! I figured it out. Under the Configuration Manager, I added to port number to IP1 only. I need to add it to IPALL too. That took care of it.

------------------------------------------
There are 10 kinds of people in this world. One that understands binary and the other one that does not.