Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-11-12 : 08:27:08
|
| Kristian writes "I want to install a named instance of MSDE. How to understand which port number it will use when there are other installed instances?Thank you in advance!" |
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2003-11-12 : 14:03:13
|
| By default if you connect to port 1434 SQL Server dynamically determines the port of the instance you are connecting to.-Chadhttp://www.clrsoft.comSoftware built for the Common Language Runtime. |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-11-12 : 14:08:47
|
| You get to pick which port number you want it to use if you don't want it to use the defaults. If you later can't remember what you selected, port information is stored here in the registry:HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\MSSQLServer\SuperSocketNetLib\TcpYou can also easily view it using Server Network Utility tool.Tara |
|
|
|
krisbg
Starting Member
5 Posts |
Posted - 2003-11-14 : 10:48:38
|
| Hi, everybody!Thank you for the replies!chadmat, I knew that it dynamically determines the port number, but maybe I didn't understand it correctly and this is connected to the other post I posted on this forum - it is because I thought that the port nuber is needed in the connection string, but it went that it is not neccessary? And now maybe you mean that when I connect to a server it automatically detects the port number of an instance, so I do not have to worry for the port number in advance? Something similar I read in MSDN, but didn't understand it completely...tduggan, thank you for your reply too! But maybe you have installed only default instance of SQL Server, so thats why in the mentioned registry key you have the port number. I have installed named instances and in that registry key is written zero... |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-11-14 : 12:12:10
|
| I have named instances as well. But yes the port information for the named instances is stored in another location in the registry.HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\<instance name>\MSSQLServer\SuperSocketNetLib\TcpJust change <instance name> to whatever you called the instance.Tara |
|
|
|
krisbg
Starting Member
5 Posts |
Posted - 2003-11-17 : 04:12:25
|
| tduggan, HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\<instance name>\MSSQLServer\SuperSocketNetLib\Tcp is the exact place where I have searched for the tcp port number, but there both values: TcpDynamicPorts and TcpPort are zeroes... |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-11-17 : 12:10:47
|
| Maybe TcpPort 0 means dynamic. Not sure. You could change the value then restart the service so that you know which port you are using. Of course this would affect your client machiens. They would need aliases created for the new port number.Tara |
|
|
|
|
|
|
|
|
How to get the port number for a named instance?