connecting to a SQL DB via Internet

kimosavi

Active member
Joined
Apr 9, 2009
Messages
34
Location
Chicago, IL
Programming Experience
3-5
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!!
 
Back
Top