6fd6 SMS Gateway - ASP.NET and MS SQL Server, Create database and user

Search the manual:

Overview

OZEKI NG SMS Gateway - Product Guide

Contents | Search

Home > Product Manual > Developers Guide > SQL SMS API > ASP.NET and MS SQL Server > Create database and user

ASP.NET and MS SQL Server

Allow authentication

Create database and user

Start Ozeki NG GUI

Create a database user in NG

wwwroot

Data field change

Cheking the sending

Ozeki database table layout

Examples and Solutions

Appendix

FAQ

Feature list

Commercial Information

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

Create the database with tables and the user in MS SQL Server

In SQL Server Management Studio Express, click the New Query icon.

Into the new SQL panel, enter this:

create database ozekisms;

Then click the Execute icon. If everything is all right, the "Command(s) completed successfully" message will be displayed.

We have to create the tables. Delete text "create database ozekisms;" and enter the following:

use ozekisms;

create table ozekimessagein (
id int identity(1,1),
sender varchar(30),
receiver varchar(30),
msg varchar(1024),
senttime varchar(100),
receivedtime varchar(100),
operator varchar(100),
msgtype varchar(160));

create table ozekimessageout (
id int identity(1,1),
sender varchar(30),
receiver varchar(30),
msg varchar(1024),
senttime varchar(100),
receivedtime varchar(100),
status varchar(20),
operator varchar(100),
msgtype varchar(160));

Then, click the Execute icon. If everything is all right, the "Command(s) completed successfully" message will be displayed.

Finally, create the user (named sqluser with the abc123 password) that will have permission to log in and access the tables above. The text is this (do not forget to delete the previous text):

use ozekisms;
create login sqluser with password='abc123';
use ozekisms;
create user sqluser for login sqluser;
use ozekisms;
grant select,insert,update,delete on ozekimessagein to sqluser;
grant select,insert,update,delete on ozekimessageout to sqluser;

Then click the Execute icon. If everything is all right, the "Command(s) completed successfully" message will be displayed.

Related information

Message statuses in database
Database table layout

Next page: Start Ozeki NG GUI

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