Deploy MS SQL database

Deploy MS SQL database

You need to have an MS SQL server 2008 or later in your infrastructure. SQL server should be available from client's desktops on port 1433.  

  1. Extract package downloaded from https://sendtrusted.com/download 
  2. Create New database on your Microfost SQL Server e.g. SendTrusted_DB
  3. Run Deploy_SQL_Tables.sql from package
  4. Fill email column in AuthorizedRecipients table with your trusted recipients or/and email domains

5. Create dbuser to use it for database <--> Outlook plugin synchronization. Minimu requirements for te user:

  • Select permissions to AuthorizedRecipients table
  • Inser/Select permissions to SyncLog table

 DB userpermissions1 doc

DB userpermissions2 doc