Sql 2005 ?

[Yellowstang]

How can you tell what port SQL 2005 is set to run on? I know the default is 1433, but what if someone changed it, how can you tell.

Also, on like SQL 2000 if you ran a named instance, the port was not 1433, is that still true for 2005?

TIA

[AbecX]

netstat -an | more

[AbecX]

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=135329&SiteID=1

[Yellowstang]

[QUOTE=AbecX]http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=135329&SiteID=1[/QUOTE]


Thanks!