Port 1433 Blocked (1 Viewer)

[ronilse]

Hi,
This issue it's fixed, but you need to do a fresh install without MSSQL installed, DeployTool will then set that port to fixed 1433 instead of SQL selecting another value.
If you know how to edit in regedit:
Before you change this stop SQL Server in Win services

Open regedit

on Vista x86 navigate to(what it is for XP i don't know)
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.1\MSSQLServer\SuperSocketNetLib\Tcp\IPAll

& for Vista X64
HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\Microsoft SQL Server\MSSQL.1\MSSQLServer\SuperSocketNetLib\Tcp\IPAll

You need to change the "TcpDynamicPorts" to 1433

& then start SQL Server, you might have to reboot to get it all working

Regards
Roy

 

[NevOZ]

If you don't like hacking the registry, then do this :

1. Click Start -> Program Files -> MS SQL Server 2005 -> Config Tools -> SQL Server Configuration Manager.

2. Expand SQL Server 2005 Network Config.

3. Select "Protocols for SQLEXPRESS"

4. Right click "TCP/IP" and select Properties.

5. Click on the "IP Addresses" tab.

6. Make all 3 fields that say "TCP Dynamic Ports" blank.

7. Set all 3 "TCP Port" fields to "1433".

8. Click OK.

9. Right click "TCP/IP" and select "Enable".

10. Select "SQL Server 2005 Services".

11. Right click "SQL Server (SQLEXPRESS)" and select "Restart"

That should fix it.

Nev

 

[Requiem]

Hi,
This issue it's fixed, but you need to do a fresh install without MSSQL installed, DeployTool will then set that port to fixed 1433 instead of SQL selecting another value.

Sorry for being a thread necrophile, I just setup MePo 1.2.3 in a Client/Server constellation and experienced this same error; I've hat MS SQL Express 2012 installed before. Isn't there a way to set these values correctly without having to uninstall MSSQL before thru the deploy tool?