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

anusham (u62733@uwe) writes:
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, 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