MSSQL 2012/2014 configuration
You can make SMS Gateway faster by storing your messages in your MSSQL database instead of storing them in files on your computer. As a default Ozeki SMS Gateway saves SMS messages in files, but you can change this option by connecting Ozeki 10 to your MSSQL database. Speed up message sending by following this small tutorial.
Keep in mind!!!
If you receive an error message telling that your SMS messages cannot be found, there is no problem. Probaby the messages are still in the files, although the system searches them in the database. If you are uncertain how to import messages from your files, you can look back and see how to switch from file to database. It is a short site to scroll through. The diagrams will help you understand. You can check out this detailed explanation as well.
Before continueing please make sure that Ozeki SMS Gateway and MSSQL 2012/2014 is already installed on your company's server. Start SQL server Management Studio and login with administrator privilages (Figure 1). It is important to remember the administrator password provided at the MSSQL installation process.
Step 1: Create MSSQL database
Open the Database menu, click the right mouse button and select 'New Database...'. It is recommended to create an individual database for Ozeki SMS Gateway (Figure 2). This will avoid confusions.
It is time to provide a name to your database and click 'Ok' (Figure 3). You will connect this database to Ozeki 10, so it will store incoming and outgoing messages in your database instead of storing them in files.
Look at Figure 4.
Under 'Databases' menu you can see all of the created databases.
Step 2: Create MSSQL database user
Now expand 'Security' and make a right click on 'Logins' and select 'New login...' (Figure 5).
When creating a login, please specify the following parameters (Figure 6):
Stay in the window after adding the user parameters. Now it is time to configure 'User mapping' (Figure 7).
Enable the created database by ticking the checkbox then click '...' on the end of the row (Figure 8).
A new window will appear. Select 'Schema' and click on 'Browse' (Figure 9)
Please select the [dbo] schema, which is needed in this case and click 'OK' (Figure 10).
You will find yourself on the previous window with the [dbo] schema added. Click 'OK' (Figure 11).
Please look at the 'Database role membership' checkboxes (Figure 12) and select the following roles:
After making the correct setting you will see the created user under the 'Logins' menu item (Figure 13). In this example the created user is called 'ozeki', although you can create any other user with it's own SQL authentication password (Figure 6).
Step 3: Add MSSQL system database to Ozeki 10
Start Ozeki 10 and login with your username and password (Figure 14).
Select 'Edit' from the top menu and click 'Server preferences' as seen on Figure 15.
Select 'Databases' tabpage and under it please select 'System database settings' tabpage (Figure 16). Check the tick left to 'Use a database server instead of file system to store messages ' and choose 'OleDb' database connection type.
Now it is time to specify the connection string:
Please modify the following parameters:
Now you can click 'View' on the top menu and select 'System DB events' menu item (Figure 17).
Search the following event in the event list:
Now it is time to insert an outgoing message into the database. You will find the message in the 'Sent' message box (Figure 19).
You can find the test message in the database table of the given user (Figure 20).