How to configure sqlexpress named instance to a static port otherthan 1433

[anusham]

Hi DBAs,

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
USE master
GO
CREATE ENDPOINT [CustomConnection]
STATE = STARTED
AS TCP
(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
Server.
im using sqlserver 2005.

Thanks in Advance,
Anusha.M

[Erland Sommarskog]

anusham (u62733@uwe) writes:
> I have a requirement that i need to set sqlserver sqlexpress instance to
> run only on a specified port .

Open SQL Server Configuration Manager, and find the node SQL Server Network
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, esq...@sommarskog.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/prodinfo/previousversions/books.mspx