Solved

MSDE Install: Specify PORT number?

Posted on 2004-08-23
6
402 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
Comment Utility
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
Comment Utility
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
Comment Utility
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
Comment Utility
Please close the question...
0
 
LVL 1

Accepted Solution

by:
Computer101 earned 0 total points
Comment Utility
PAQed - no points refunded (of 500)

Computer101
E-E Admin
0

Featured Post

Maximize Your Threat Intelligence Reporting

Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

Join & Write a Comment

Introduction In my previous article (http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SSIS/A_9150-Loading-XML-Using-SSIS.html) I showed you how the XML Source component can be used to load XML files into a SQL Server database, us…
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties

762 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

11 Experts available now in Live!

Get 1:1 Help Now