How to configure sqlexpress named instance to a static port otherthan 1433 - 07-31-2010 , 08:41 AM
I have a requirement that i need to set sqlserver sqlexpress instance to run
only on a specified port .
this i need to do through code one way is using sql query and the other is
from command prompt.
i used the following code
CREATE ENDPOINT [CustomConnection]
STATE = STARTED
(LISTENER_PORT = 1500, LISTENER_IP =ALL)
FOR TSQL() ;
but its raising an error.........
Msg 7878, Level 16, State 1, Line 1
This "CREATE ENDPOINT" statement is not supported on this edition of SQL
im using sqlserver 2005.
Thanks in Advance,
Re: How to configure sqlexpress named instance to a static port otherthan 1433 - 07-31-2010 , 03:14 PM
anusham (u62733@uwe) writes:
Configuration, and the the node Protocols for SQLEXPRESS (or what the name
of your instance is.)
Double-click TCP/IP. Select the tab IP Addresses. When I look at it on my
machine I sese IP1 to IP6 that all have 0 in TCP Dynamic Ports, and blank in
TCP Port. Then at the bottom there is IP All, with 2094 in TCP Dynamic Port
and blank in TCP Port.
If I wanted to run SQL Server on a fixed port, I should delete 2094 and type
4711 (or what port number I want) in TCP Ports. I would to restart to SQL
Server for thr change to take effect.
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se
Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinf...ons/books.mspx