This topic explains how to use Microsoft SQL Server for the Symprex Email Signature Manager database.
Please follow these steps:
|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.
|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.|