- Product Manual
- Introduction
- SMS technology
- Installation Guide
- User Guide
- Developers Guide
- Examples and Solutions
- Telephone networks
- SMS Pin game
- Database
- ASP user setup
- ASP Source
- E-mail to SMS alert
- 2 way SMS to Email gateway
- SMS Order System
- Asterisk PBX SMS
- SQL SMS Gateway
- Service Provider
- SMS PIN code query
- SMS Counter game
- SMS newsgroup
- Distributed SMS
- SMS Menu
- Google maps
- Forwarding
- Birthday greeting - SQL Express
- Birthday greeting - MySQL
- Birthday greeting - Oracle
- Instant brochure - MMS autoreply
- Alphabet letter game
- SMS sport betting service
- E-mail about outgoing SMS messages
- SMS Information Menu
- Email to SMS feature
- Reminder example
- Bulk SMS Client
- Bulk SMS to a given phone number range
- Filtering phone numbers
- Ozeki Phone Sytem PBX SMS
- Autoreply voucher example
- Appendix
- SMS FAQ
- Feature list
- Commercial Information
- Search
How to create an SQL Express database
In this guide we explain how you can create a database. We use the Microsoft SQL Express database server that can be downloaded from the Microsoft website.
Step 1. - Download and install Microsoft SQL Express.
You can download the Microsoft SQL Express Database Server from the following location:
Download details: Microsoft SQL Server 2005 Express Edition
Step 2 - Create your database in Microsoft SQL Express
You can create a database and the appropriate database tables by opening a windows command prompt (Start->Run->cmd.exe), and starting the SQL Command interpreter by typing:
cd C:\ sqlcmd -S .\SQLExpress |
Once the SQL command interpreter is running, you should enter the following commands
create database ozeki GO use ozeki GO sp_addLogin 'ozekiuser', 'ozekipass' GO sp_addsrvrolemember 'ozekiuser', 'sysadmin' GO |
Step 3 - Make Microsoft SQL Express ready to accept your username and password
Unless you have mixed mode authentication configured in SQL express, you will not be able to connect to your database from Ozeki NG because Ozeki NG runs as a system service in the background. To enable mixed - mode authentication, you should open the registry editor (Start->run->regedit.exe) and in the Registry you should change the LoginMode value from 1 to "2", here:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.1\MSSQLServer LoginMode =2 |
After this change you might have to restart the SQL Express to make sure the changes take effect.
More information
- How to connect SMS Gateway to the telephone network for voice calls
- Ozeki Phone Sytem PBX SMS
- Asterisk PBX SMS
- Prerequisites for Asterisk SMS
- Create Database for SMS sending
- SMS Pin game
- How to create an SQL Express database for SMS Pin game
- ASP User Script setup for SMS Pin game
- ASP Script for creating pin game
- Appendix
- Feature list of Ozeki NG SMS Gateway
- FAQ of the Ozeki NG SMS Gateway