Using Microsoft SQL Server

Email Signature Manager fully supports using Microsoft SQL Server.

The following versions are supported:

•SQL Server 2008

•SQL Server 2008 R2

•SQL Server 2012

•SQL Server 2014

•SQL Server 2016

•SQL Server 2017

SQL Server must be used as the database for Email Signature Manager in any of the following scenarios:

•You wish to manage the database from more than one computer.

•You wish to use the Email Signature Manager Transport Agent.

Migrating to SQL Server

To migrate from using the Built-in Database to SQL Server, please use the following steps:

1.If you do not have a SQL Server available within your organization, please read the topic on how to install and configure SQL Server Express.
 

2.Create the Email Signature Manager database on the appropriate instance of SQL Server.
 

3.Using Services Control Manager, stop the Email Signature Manager Service.

4.Start the main Email Signature Manager application.
 

5.Connect to the Email Signature Manager database created in step 2 using the Settings Database dialog. You must connect to the database using SQL Server Authentication.
 

6.Open the Import Database dialog. Ensure the Type is selected as Access and then click the ellipses ("...") button next to the Database text box. Select the Built-in Database. The default location is C:\ProgramData\Symprex\Symprex.EmailSignatureManager.Database.mdb.
 

7.Click the OK button and confirm that you wish to import the database. The data from the Built-in Database is now imported to the SQL Server database.
 

8.Using Services Control Manager, restart the Email Signature Manager Service.

9.If you wish to install Email Signature Manager on additional computers to manage the database, please read the section on Manager Only mode.