Groups | Blog | Home
all groups > sql server (alternate) > january 2004 >

sql server (alternate) : Finding the port the MSDE is running on --


James Starritt
1/7/2004 10:59:24 AM

Without the Client Network Utility that is available in the full blown MS
SQL Server is there a way to find out what port the MSDE is running on?

Short and sweet, thats all I need

TIA


Jerry Boone
1/7/2004 5:39:55 PM
1433 is the default

otherwise you might be able to look in the registry (this is from sql server
installation, not msde - so it's a crap shot, but with good odds...)

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\MSSQLServer\SuperSocketNe
tLib\Tcp]
"TcpHideFlag"=dword:00000000
"TcpPort"="1433"
"TcpDynamicPorts"=""


--
Jerry Boone
Analytical Technologies, Inc.
http://www.antech.biz
Secure Hosting and Development Solutions for ASP, ASP.NET, SQL Server, and
Access



[quoted text, click to view]

AddThis Social Bookmark Button