<< Click to Display Table of Contents >> Navigation:  Advanced > Configure a connection to a MSSQL Database

Configure a connection to an MSSQL database installed by the "JAM Software MSSQL Express Installer":

Follow these steps:

1.Open SmartSerialMail and click File->Data->Manage Database.

2.In the new window, select „MSSQL Database“ as the database type.

3.SmartSerialMail will automatically detect the local instance of MSSQL Server and will set the default settings for the connection.
If you kept the default database settings, you will not need to change the configuration.

4.If you want to use the data from the previously connected database, please select the option "copy the current database to the new database".

5.Click on "OK" to apply the settings.

The default values of the "JAM Software MSSQL Express Installer" database are:

 • Name of the MSSQL instance: "SSM_INSTANCE"

 • Name of the database: "SSM_DB"

 • MSSQL username: "ssm_user"

 • Passwort "ssm_user": "smartSerial4Mail_835"

 • Passwort for "SA"  user: "ssm4smart_54"

 

Hint: For productive use you should change the password for the "SA"-User and the MSSQL user "ssm_user".

We recommend using the "MSSQL Database Management Studio" for such changes. You can download the software here:

Microsoft SQL Management Studio

 

Configure a connection to a your own MSSQL database:

1.Open SmartSerialMail and click File->Data->Manage Database.

2.Select „MSSQL Database“ as the database type.

3.Please select the desired authentication mode and enter the required settings.
Please select the database server and the desired database.

4.If you want to use the data from the previously connected database, please select the option "copy the current database to the new database".

5.Click "Ok" to apply the settings.

 

Saving your data:

Follow these steps:

1. Start SmartSerialMail and navigate to File->Data->Backup database. A new dialog appears.

2. Select the storage location you want to save the backup file to and click "Save".

Please note that creating a backup of a MSSQL database is only possible if SmartSerialMail and the MSSQL server are installed and executed on the same PC.

 

Restoring your data:

Follow these steps:

1. Start SmartSerialMail and navigate to File->Data->Restore database. A new dialog appears.

2. Select the backup file you want to use to restore your data and click "Open".

Please note that restoring a backup of a MSSQL database is only possible if SmartSerialMail and the MSSQL server are installed and executed on the same PC.