Solved

MSDE Install: Specify PORT number?

Posted on 2004-08-23
6
420 Views
Last Modified: 2007-12-19
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
Comment
Question by:born4code
6 Comments
 
LVL 10

Expert Comment

by:Jay Toops
ID: 11872833
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
 
LVL 2

Author Comment

by:born4code
ID: 11874322
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
 
LVL 2

Author Comment

by:born4code
ID: 11875030
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
 
LVL 34

Expert Comment

by:arbert
ID: 11876122
Please close the question...
0
 
LVL 1

Accepted Solution

by:
Computer101 earned 0 total points
ID: 12186099
PAQed - no points refunded (of 500)

Computer101
E-E Admin
0

Featured Post

NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.

816 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now