Symprex Email Signature Manager, v5.5.1

Using Microsoft SQL Server

This topic explains how to use Microsoft SQL Server for the Symprex Email Signature Manager database.

 

Please follow these steps:

 

1.Download the script to create the Email Signature Manager database on your SQL Server from the Symprex website:
 
http://www.symprex.com/support/files/symprex/msm/signdbssql.zip
 
This zip file contains one file, signdbs.sql, which should be extracted to a known location.
 
2.Using SQL Server Management Studio, create a new database on your SQL Server for Email Signature Manager according to your organization's policy. The database can be given any name.
 
3.Remaining in SQL Server Management Studio, open the signdbs.sql script and change the [USE] statement on the first line to point to the database created in step 2.
 
4.Execute the script modified in step 3, which will create the database structure.
 
5.Configure permissions on the tables in the database created in step 2. Email Signature Manager supports using both Windows Authentication and SQL Server Authentication:
 
When using SQL Server Authentication, add each SQL logon to the db_datareader and db_datawriter roles for the database.
 
When using Windows Authentication, add each user of the product to the db_datareader and db_datawriter roles for the database.
 
Note: It is recommended that SQL Server Authentication is chosen, as it keeps assigning permissions as simple as possible by creating a single, dedicated logon for just the Email Signature Manager database. This logon can then be re-used amongst all of the components of the product that require database access.
 
Note: The db_datareader role gives a logon/user SELECT permissions on all tables/views in the database, and the db_datawriter role gives a logon/user INSERT, UPDATE and DELETE permissions. Please review this MSDN article for more information.
 
6.Configure Email Signature Manager to connect to the database using the Settings Database dialog.
 
7.If you have templates and settings in an existing database, this data can be imported to the SQL Server database using the Import Database dialog.
 
8.Configure sign.exe to connect to your SQL Server database by supplying the appropriate command line arguments or by placing a sign.ini configuration file in the same directory as sign.exe (or the MSI package); see saving the connection settings.

 


Copyright © 2014 Symprex Limited. All Rights Reserved.