Ozeki NG SMS Gateway logo OZEKI NG SMS Gateway
"The World's most reliable SMS gateway software!"

OZEKI NG SMS Gateway - Product Guide

SQL Browser Contents | SearchMSSQL Server 2008 Connection

Home > Product Manual > Installation Guide > Users and applications > SMS from or to database > MSSQL > SQL Server 2005 remote connection > Firewalls

 


Contact Us!
If you wish to get further information, do not hesitate to contact us!

E-mail: info@ozekisms.com

If you have a technical question, please submit a support request on-line.

A Note on Firewalls and SQL Server

Chris D. sends us this tip regarding the effect of firewalls on the connection. We have not tested this yet - but thought we would pass on the advice. Thanks Chris!

After trying everything listed on this page, with no luck and spending a day searching newsgroups, I finally, nailed the problem down to a hardware firewall at the ISP. If your server is hosted with an ISP, as mine was, doing the above may not be enough, depending on how the server itself is setup.

Resolution

Go to command prompt and type netstat -a

Within the results you need to see if the box is listening on the ports you think.

In my case, the hardware firewall was preventing me from being able to connect.

The solution was to stop using dynamics ports and open up a static port.

To do this open up the SQL configuration manager. Click on protocols. Double Click on TCP/IP Click on IP Addresses tab As mentioned in the above document, 0 means dynamic ports.

I found that by setting the static port, this solved my problem. Put an empty string in the TCP Dynamic ports box Set the port you want to connect on in the TCP port box. Do this for the net connections you have.

Connect to the SQL using:

IPADDRESS,PORT

Works great now.

Obviously, you should check out that doing do will not open you up to security risks with your ISP, however, this was the solution that ended an 8 hour hairpulling session and I thought I would pass it on, just in case I could one day help someone else.

More information





Next page: MSSQL Server 2008 Connection
Legal | Privacy | Terms of use | 2480
54.85.57.0 | 92.118.27.157 | Login