Does SQL Server 2008 require a TCP Endpoint to listen on a specific IP Address and specific port?


in sql server 2008, have create tcp endpoint if want sql server listen specific ip address , specific port? in sql server configuration manager, tcp/ip protocol enabled , dynamic tcp ports , tcp port fields each ipx has been cleared except 1 ip address. (as directed in http://msdn.microsoft.com/en-us/library/ms177440(printer).aspx) on 1 ipx tcp port has been set 2505 , on ipall tcp port has been set 2505. if “listen all” property set “no”, remote client connections cannot connect server. if “listen all” property set “yes”, remote client connections can connect server. sql server listening on ports or having tcp port set on 1 ipx , ipall stop sql server listening on ports? concern external firewall (not windows firewall) requires specific ip address , port number. article (http://msdn.microsoft.com/en-us/library/ms191220.aspx) seems indicate tcp endpoint needed override default tcp endpoint. installation sql server 2008 (64-bit) developer edition cu3 on windows server 2008 standard sp1.

 

in sql server 2005, “listen all” property set “no” , 1 ipx had tcp port set specific number. , seemed work remote client connections.

thanks in advance help.

<correction>

tcp port := 1433


SQL Server  >  SQL Server Data Access



Comments

Popular posts from this blog

Conditional formatting a graph vertical axis in SSRS 2012 charts

Register with Power BI failed

SQL server replication error Cannot find the dbo or user defined function........