kimosavi
Active member
Hi. I have read this can be done, but I keep trying and no luck so far.
This is what I have done so far.
1. Surface Area : Allow remote connections
2. SQL Server: Properties, Connections, Allow Remote Connection to Server
3. SQL Network Config (Control Panel) : Protocols, TCP Enabled
4. SQL Network Config (Control Panel) : TCP, IP1, Enabled, IP Local Machine, Port 1433
5. SQL Network Config (Control Panel) : TCP, IPAll, Dynamic Ports [Blank]
6. Opened Ports 1433, 1434, 1480, 1954 in both TCP/UDP
7. Created a No-IP Account.
8. turned off ALL Firewalls.
I can ping my account without any issues from outside my network.
but cannot connect to the SQL DB.
Connection String with Management Studio is:
no-ip-account.org\SQLEXPRESS,1433 (No Connect)
192.168.1.100\SQLEXPRESS (connects)
192.168.1.100\SQLEXPRESS,1433 (No connects)
From Another PC on the network
192.168.1.100\SQLEXPRESS (connects)
192.168.1.100\SQLEXPRESS,1433 (No connects)
I think the problem is with the PORT and the PROVIDER.
I have Cablevision Optimum Online and maybe they are not letting me in through this port.
Thoughts?!? Ideas??
Thanks in advance!!
This is what I have done so far.
1. Surface Area : Allow remote connections
2. SQL Server: Properties, Connections, Allow Remote Connection to Server
3. SQL Network Config (Control Panel) : Protocols, TCP Enabled
4. SQL Network Config (Control Panel) : TCP, IP1, Enabled, IP Local Machine, Port 1433
5. SQL Network Config (Control Panel) : TCP, IPAll, Dynamic Ports [Blank]
6. Opened Ports 1433, 1434, 1480, 1954 in both TCP/UDP
7. Created a No-IP Account.
8. turned off ALL Firewalls.
I can ping my account without any issues from outside my network.
but cannot connect to the SQL DB.
Connection String with Management Studio is:
no-ip-account.org\SQLEXPRESS,1433 (No Connect)
192.168.1.100\SQLEXPRESS (connects)
192.168.1.100\SQLEXPRESS,1433 (No connects)
From Another PC on the network
192.168.1.100\SQLEXPRESS (connects)
192.168.1.100\SQLEXPRESS,1433 (No connects)
I think the problem is with the PORT and the PROVIDER.
I have Cablevision Optimum Online and maybe they are not letting me in through this port.
Thoughts?!? Ideas??
Thanks in advance!!