System database configuration in MSSQL 2008
In case you need to store great numbers of SMS text messages
it is possible that your system will be slowed down by this amount of stored
files. By default, Ozeki NG SMS Gateway stores messages in files. In this way,
it is highly recommended to use the System Database option in Ozeki NG SMS
Gateway. This option allows you to speed up message sending. On this webpage
you find a detailed configuration guide for using System Database in MSSQL
When you switch to System Database, you can receive an error message since the
system cannot find messages.
The reason for this: the system searches for messages still in the file but
system database stores them in a database. To avoid this error message please
read How to import messages to System Database
and How to switch from file to database
In the follows you can find detailed configuration steps on how
you can configure System Database option in Ozeki NG SMS Gateway software. In
this example, MSSQL 2008 is used. Please follow the steps below to make your
It is assumed that you have already downloaded,
configured Ozeki NG SMS Gateway and MSSQL 2008.
First of all, start SQL server Management Studio (Start menu \ All programs \
Microsoft SQL Server 2008 \ SQL Server Management Studio) (Figure 1).
Figure 1 - Start SQL server Management Studio
Login as administrator (admin user has been created during the
installation of MSSQL Server 2008) (Figure 2).
Figure 2 - Login
Expand Databases menu. Then right click on
Databases and click on New Database. In this way, you can create
the database that will include the system database of Ozeki NG SMS Gateway.
It is recommended to create a new database to avoid confusion (Figure 3).
Figure 3 - Create new database
On New Database form specify Database name(in this
example, we use ozeki_sys) and click on OK (Figure 4).
Figure 4 - Database name
Under Databases menu item you can see the created
database (Figure 5).
Figure 5 - Created database
Now expand Security menu item. Then right click on
Logins and select New login (Figure 6).
Figure 6 - New login
On the appeared form please specify the follows (Figure 7):
- Specify Login name: it is the user name (in this example: "ozeki")
- Enable SQL Server authentication checkbox and specify the Password.
- Disable User must change password at next login checkbox.
- Specify Default database (in this example: "ozeki_sys").
Figure 7 - Specify details
After you have specified the details on New login form, click
on User mapping still on the same form (Figure 8).
Figure 8 - User mapping
Enable the checkbox of the created database (in this example
it is "ozeki_sys") and click on ... button at the end of the row
Figure 9 - Enable the database
On the appeared Select Schema form click on Browse
to be able to select the schema you wish to use for the user (Figure 10).
Figure 10 - Browse
Select the schema you wish to use (in this case dbo
schema is needed) and click on OK (Figure 11).
Figure 11 - Select the schema
On Figure 12 you can see the selected schema is listed. Click
on OK again.
Figure 12 - Selected schema is listed
You also need to specify Database role membership for
the created database (Figure 13). You can do so by selecting the
at the bottom of New login form. Please select:
Public is selected by default. Please leave it selected.
Finally, click on OK to create the user.
Figure 13 - Database role membership
If you made settings correctly, you can see the created user
under Logins menu item (Figure 14). In this example
it is "ozeki".
Figure 14 - Created user
Now start Ozeki NG SMS Gateway and login with your username
and password (Figure 15).
Figure 15 - Log into Ozeki NG SMS Gateway
Go to Edit menu and select Server preferences
menu item (Figure 16).
Figure 16 - Server preferences
Select Databases tab and click on System database
settings tab (Figure 17). Here, enable Use a database server instead of
file system to store messages. Database connection type needs to be
Then specify the Database connection string as follows:
Provider=SQLOLEDB.1;Data Source=YourComputerName;Persist Security
Info=False;Integrated Security=SSPI;User ID=YourUserName;Password=YourUserPassword;Initial
Please customize the Database connection string according to the follows:
YourComputerName= the IP address or domain name of the computer on which
the database server has been installed. If the Ozeki NG SMS
Gateway and the database server are on the same computer, this value is (local).
YourUserName= username for the database.
YourUserPassword= password belongs to the username.
YourDatabaseName= the catalog or database that you have created for storing
the system database. (In this example, it is "ozeki_sys")
Finally, click on OK.
Figure 17 - System database settings
Now restart the Ozeki NG service by right clicking on the Ozeki
icon on the tray and select Restart service option (Figure 18).
Figure 18 - Restart service
After restart, go to View menu and select System DB
events menu item (Figure 19).
Figure 19 - System DB events
If the configuration was correct then you can see the following
server event: "Database connection successful" (Figure 20).
Figure 20 - Database connection successful
If you send a test message it needs to be appeared in the
Sent box in Ozeki NG SMS Gateway as Figure 21 demonstrates.
Figure 21 - Sent test message
As a consequence of the test message it can be seen that the
database tables containing the messages
have been created in the database successfully for the given user (Figure 22).
Figure 22 - Database tables have been created successfully