Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Win XP SP2
Message
From
22/09/2004 17:47:08
 
 
To
22/09/2004 09:36:20
General information
Forum:
Microsoft SQL Server
Category:
Installation
Title:
Miscellaneous
Thread ID:
00944951
Message ID:
00945217
Views:
19
I'm currently investigating the possibility that setting the following registry values may open the ports:

first query Software\Microsoft\MSSQLServer\MSSQLServer\SuperSocketNetLib\Tcp
value TcpPort for the actual TCP port
If named instance, query
Software\Microsoft\Microsoft SQL Server\(InstanceName)\MSSQLServer\SuperSocketNetLib\Tcp
value TcpPort for the actual TCP port

Then create the key values below, substituting the actual TCP port number for 1433 in all the names and data below
* HKEY_LOCAL_MACHINE\SYSTEM\ControlSet001\Services\SharedAccess\ Parameters\FirewallPolicy\DomainProfile\GloballyOpenPorts\List
* Name : 1434:UDP
* Type : REG_SZ
* Data : 1434:UDP:*:Enabled:PPS EE UDP
* HKEY_LOCAL_MACHINE\SYSTEM\ControlSet001\Services\SharedAccess\ Parameters\FirewallPolicy\DomainProfile\GloballyOpenPorts\List
* Name : 1433:TCP
* Type : REG_SZ
* Data : 1433:TCP:*:Enabled:PPS EE TCP
* HKEY_LOCAL_MACHINE\SYSTEM\ControlSet002\Services\SharedAccess\ Parameters\FirewallPolicy\DomainProfile\GloballyOpenPorts\List
* Name : 1434:UDP
* Type : REG_SZ
* Data : 1434:UDP:*:Enabled:PPS EE UDP
* HKEY_LOCAL_MACHINE\SYSTEM\ControlSet002\Services\SharedAccess\ Parameters\FirewallPolicy\DomainProfile\GloballyOpenPorts\List
* Name : 1433:TCP
* Type : REG_SZ
* Data : 1433:TCP:*:Enabled:PPS EE TCP
* HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\SharedAccess\ Parameters\FirewallPolicy\DomainProfile\GloballyOpenPorts\List
* Name : 1434:UDP
* Type : REG_SZ
* Data : 1434:UDP:*:Enabled:PPS EE UDP
* HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\SharedAccess\ Parameters\FirewallPolicy\DomainProfile\GloballyOpenPorts\List
* Name : 1433:TCP
* Type : REG_SZ
* Data : 1433:TCP:*:Enabled:PPS EE TCP

I'll report results in a day or two.
Randy Hersom
President, Habilitation Software Inc.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform