Error during Activation of SQL Integration

When you try to activate SQL Integration for Enchanced Reporting in the Mailscape Adminstration Console, you might encounter and error accessing SQL Server. 
To sucessfully configure SQL Integration, execute the following steps:
  1. Create a new user account for ENow SQL Service auf dem ENow Web Server ein neues Dienstkonto ein.
    • Create a local user account on the ENow Web Server, if SQL Server Express is installed locally
    • Create a domain user account, if SQL Server is installed remotely
  2. Create a new SQL Login for the user account using the SQL Server Management Console and assign the following SQL role
    • sysadmin
  3. Start the ENow Administration Console  "as Administratorator"
  4. Activate SQL Integration for extended Reporting
    • Use the new created user account for accessing SQL Server
    • The Windows Service "ENow SQL Service" will be configured to use the provided user account automatically



Read more about our Consulting Services:
Articles and Information provided in the Granikos Knowledge Base is posted as a service offering only and provided AS-IS. Granikos GmbH & Co. KG makes no warranty, implied or otherwise, regarding the performance or reliability of the information provided. The reader has to make a decision on how the information is being used.