Manage Email Signatures centrally from your Desktop - For All Users

Jesper Frier

How does eMailSignature work? Learn more ..

Create SQL 2005/2008 settings DB executing a single SQL Statement

Double-click video for full view

Execute this SQL Statement (SQL Server 2005/2008 and SQL Express)
In the Query Editor window, copy and execute the code (Press F5 to execute the statement).
Before executing the statement you might want to change user names and passwords:
- The eMailSignature_Superuser is a user who have the administrative privileges to all features in the console, e.g. change signatures, campaigns, disclaimers etc.
  If you want to change this name and password, then search for 'eMailSignature_Superuser' and 'changemenow'.
- The eMailSignature_Standarduser is a normal Outlook user with no administrative privileges and should be used during users logon.
  If you want to change this name and password, then search for 'eMailSignature_Standarduser' and 'changemealso'.
If you don't have SQL Server Management Studio installed, then open a command prompt window. In the Command Prompt window, type:
Connect eMailSignature to the database using eMailSignature_Superuser privileges. Click 'Change Database' in the Setup tab:

Code:

Provider=sqloledb;Data Source=[EMAILSIGNATURE2];Initial Catalog=eMailSignature;User Id=eMailSignature_Superuser;Password=changemenow;
Copy Sign.exe to NETLOGON and execute below code manually using eMailSignature_Standarduser privileges.
When users are OK in Status Monitor (Diagnostics tab) you are ready to deploy email signatures from your database:

Code:

"\\[emailsignature2]\NETLOGON\sign.exe" Provider=sqloledb;Data Source=[EMAILSIGNATURE2];Initial Catalog=eMailSignature;User Id=eMailSignature_Standarduser;Password=changemealso;
When finished testing, execute above code during users logon.