Using Microsoft SQL Server

Symprex Email Signature Manager, v5.0.1

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.

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 Windows Authentication, give each user of the product SELECT, INSERT, UPDATE and DELETE rights on all tables in the database.

When using SQL Server Authentication, give each SQL logon SELECT, INSERT, UPDATE and DELETE rights on all tables in the database

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.