Jump to content
Tom Wellige

2.1 - Setup Database

Recommended Posts

It is recommended to use the MS SQL Server being already installed on the SwyxWare machine and being used by the SwyxWare.

 

If you want to use another MS SQL Server on another machine please refer to Use SQL Server on different machine. If you want to use another database server like MySQL or Oracle please refer to Use different database.

 

The default name of the database to be created is IpPbxExtensions. If you want to use another database name please refer to Use database with different name.

 

The following setup instruction assumes you install Persistent Variables into the MS SQL Server being installed on the SwyxWare machine and use the default database name. This is later on the most easiest way to use Persistent Variables.

 

Step 1

It is prohibited to use SwyxWare's IpPbx database for own needs. Therefore all extensions of the Call Routing Extensions project use a separated database called IpPbxExtensions.

To create this database you should use the SQL Server Management Studio. Follow this link to download the version matching to your MS SQL Server version.

 

Step 2

Open SQL Server Management Studio and connect to the local database server.

 

Step 3

Right click Databases in the tree view and select New Database...

 

Step 4

Enter the name IpPbxExtensions into the top field of the dialog on click on OK.

 

image.png

 

Step 5

Open the Security branch in the tree view, right click on Logins and select New Login...

 

Step 6

Enter or select the name of the user account the SwyxWare services (i.e. the SwyxServer) is running under. By default this is the local SwyxServiceAccount.

 

image.png

 

Step 7

Select User Mapping from the left list, check the IpPbxExtensions database from the upper list on the right side and check db_owner from the lower list on the right side.
 

image.png

 

Instead of db_owner you could also configure db_datareader and db_datawriter. This is more secure as it would prevent the user from being able to create or delete tables.

 

Step 8

Click on OK.

 

You have now successfully created the IpPbxExtensions database being used by the PersistenVariable GSE action. By creating a login for the SwyxServiceAccount you have granted access for all call routing scripts to this database.

 

 

Index

< Previous 1 - Preparations

>> Next 2.2 - Setup Database Table

 

 

Share this post


Link to post
Share on other sites

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use and have taken note of our Privacy Policy.
We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.