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

OZEKI NG SMS Gateway - Product Guide

Enable TCP IP Contents | SearchSQL Browser

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

 


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.

Enabling the TCP/IP protocol in the SQL Server Configuration Utility to Configure SQL Server Express 2005 for Remote Access

On the IP Addresses tab you will probably see several sections - one for each network connection. In the example below there is only one network card (listed in the first section) and a local loopback connection indicated by the standard address of 127.0.0.1 For remote access to the SQL Server Express 2005 instance the loopback connection is of no interest.

The first section is where the configuration has to be correct. Active option should say Yes as should the Enabled option. The IP address will probably be filled in for you (by Windows) and will be different on your machine.

If you wish to enable dynamic ports for your SQL Server Express 2005 instance then the TCP Dynamic Ports option should be 0. To disable this option and use a fixed port change this field to a blank value and fill in the port on the TCP Port option. Disabling dynamic ports is non standard for named instances and should really only be done if you know exactly what you are doing and why you want to do it.

Note: Dynamic ports means that the SQL Server Express 2005 instance gets assigned a random port every time it is started up. In order to connect, the remote client needs to know this port. It asks the Server Browser for the port number (the Server Browser has a well known and unchanging port configuration so it can always be found). The upshot is that if dynamic ports are used then the Server Browser must be started.

More information





Next page: SQL Browser
Legal | Privacy | Terms of use | 2478
54.85.57.0 | 92.118.27.157 | Login