81af SMS Gateway - SQL Server 2005 remote connection, Enable TCP IP 2

                

Search the manual:

Overview Quick start Download Manual How to buy FAQ Contact Us
OZEKI NG SMS Gateway - Product Guide

Enable TCP IP Contents | SearchSQL Browser

Home > Product Manual > Installation Guide > Users and applications > Database user > MSSQL > SQL Server 2005 remote connection > Enable TCP IP 2

SMS Gateway SMS Gateway Home

  Product Manual
  Introduction
  SMS technology
  Installation Guide
  Prerequisites
  Download Information
  Installation Steps
  Service Provider Connections
  Users and applications
  Standard user
  SMPP user
  Database user
  MSSQL
  SQL Express
  Connection problem
  Create user
  SQL Server 2005 remote connection
  Enable TCP IP
  Enable TCP IP 2
  SQL Browser
  Firewalls
  MSSQL Server 2008 Connection
  International characters
  MySQL
  Oracle
  Sybase SQL Anywhere
  PostgreSQL
  Pervasive SQL
  Date Format Strings
  Scheduled SMS
  SQL templates
  Informix
  Access
  Video
  Connection string builder
  Keywords
  Batch processing
  SQL statements
  Polling technology
  Dynamic Keywords
  Dynamic SMPP parameters
  AutoreplyDatabase user
  Autoreply user
  AutoReplyEasy user
  File user
  E-mail user
  HTTP Client user
  Colour SMS user
  Appstarter user
  SMS Voting
  Outlook Mobile Service
  FTP user
  PDF user
  WCF Client User
  Forwarder user
  Linux
  User Guide
  Developers Guide
  Examples and Solutions
  Appendix
  FAQ
  Feature list
  Commercial Information
  Search
 

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.


Callcenter developers
If you are working on telephone solutions, please check out the Ozeki VoIP SIP SDK.
It can be used to create:

Webphone solutions:
- Adobe Flash video phone
- Silverlight video phone
- Web to web calls
- Web to VoIP calls

Custom SIP clients:
- Silverlight SIP VoIP client
- Flash SIP VoIP client
- C# .net SIP VoIP client
- ASP .net SIP VoIP client
- Web based SIP VoIP client

Custom VoIP solutions:
- VoIP SIP softphones
- VoIP call center clients
- VoIP IVR systems
- VoIP predictive dialer systems
- VoIP auto dialer systems
- VoIP call assistant
- VoIP call recording systems
- VoIP intercom solutions

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.





Next page: SQL Browser

Copyright © 2000 - 2013 Ozeki Informatics Ltd.
All rights reserved

Software PBX for Windows | VoIP SDK   |   Legal information   |   Privacy policy   |   Terms of use
Please, address your inquiries to info@ozekisms.com


0