Home
RECOMMENDED FOR YOU:
SMS Gateway software
Ozeki brings you outstanding
SMS Gateway technology. Use our SMS Server products on Windows,Linux, or Android

C# SMS API
Developers can use our C# SMS API to send SMS from C#.Net. The C# SMS API comes with full source code

PHP SMS API
The ozeki PHP SMS gateway software can be used to send SMS from PHP and to receive SMS usig PHP on your website

SMPP SMS Gateway
SMS service providers use our SMPP gateway solution, that offers a high performance SMPP server and SMPP client gateway with amazing routing capabilities
Ozeki NG SMS Gateway

Creating a Database user in Ozeki NG - SMS Gateway for the MS SQL Server

This guide explains, how you can create a database user in Ozeki NG - SMS Gateway to your MS SQL database server. This user will be used to SELECT your outgoing messages from the outgoing database table, and to INSERT your incoming SMS messages into the incoming database table.

To start installing and configuring an database user in the Home page move your mouse over the Users and applications menu, and click the Add user menu item as you can see on the Figure 1.

adding a new user in ozeki ng
Figure 1 - Adding a new user in Ozeki NG

An interface will open consisting of two panels. The left side panel contains the already installed users and applications. The right side panel contains the users and applications you can install with a brief description next to them. Search the Database user and click the blue 'install' button next to it (Figure 2).

new databse user in ozeki ng
Figure 2 - New databse user in Ozeki NG

Clicking the Install link will bring up the Database user installation panel. Here, you need to enter a unique username in the User name field (Figure 3). Enter a name in the User name text box and click OK.

new sample sql user in ozeki ng
Figure 3 - New sample SQL user in Ozeki NG

In the Database user configuration page Database connection tab Select OleDb in the Connection string type dropdown menu. After it in the Connection string edit box, enter the following connection string and finally, click OK as Figure 4 shows.

Provider=sqloledb;Server=(local)\SQLExpress;Database=ozekisms;User Id=sqluser;Password=abc123;

click the ok button in ozeki ng
Figure 4 - Click the OK button in Ozeki NG

More information