Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 451
  • Last Modified:

MSDE Install: Specify PORT number?

For MSDE Installation, I have not found any place in the setup ini nor anywhere that I can set the PORT number at installation time.  It appears that the port number is somehow selected dynamically by the MSDE setup.

Is there any way to indicate the port number at MSDE setup time?

If not... is there a way to "change" the port number at a later time without Enterprise Manager... like through the registry or something???

Thanks.
0
born4code
Asked:
born4code
1 Solution
 
Jay ToopsCommented:
This is how to change the listen port

Start the SQL Server Network Utility in SQL Server 2000. Select TCP, click Properties, and then enter a new port; for example: 1433 is displayed .. now change it to a higher number ...

Stop and then restart the SQL Server server.

Jay
0
 
born4codeAuthor Commented:
Jay...

Uhh... yeah, that's apparent... but what I'm looking to do is to specify this at installation time.

I do not want to leave port selection via the network utility up to my end user.  I need to automate this.  Perhaps something in the registry... I can set from a backdoor?  Perhaps something undocumented in the ini file?  

Anyone?

0
 
born4codeAuthor Commented:
Nevermind.
Here is the link if anyone wants it.

http://support.microsoft.com/default.aspx?kbid=823938

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MYINSTANCE\MSSQLServer\SuperSocketNetLib\Tcp

TcpDynamicPorts
TcpPort
0
 
arbertCommented:
Please close the question...
0
 
Computer101Commented:
PAQed - no points refunded (of 500)

Computer101
E-E Admin
0

Featured Post

Restore individual SQL databases with ease

Veeam Explorer for Microsoft SQL Server delivers an easy-to-use, wizard-driven interface for restoring your databases from a backup. No expert SQL background required. Web interface provides a complete view of all available SQL databases to simplify the recovery of lost database

Tackle projects and never again get stuck behind a technical roadblock.
Join Now