Knowledgebase 9.0.2 Installer Fails to Create the ECRM Databases on Microsoft SQL Server 2008.
THIS ARTICLE APPLIES TO:
Knowledgebase version 9.0.2, when installing onto Microsoft SQL Server 2008
ISSUE DESCRIPTION:
The Knowledgebase v9.0.2 installer completes but the ECRM databases are not created. Instead, the tables and contents of these databases are created under the Master database.
ROOT CAUSE:
During installation of Microsoft SQL Server 2008, the NETWORK SERVICE account was selected to run the SQL Server and SQL Agent services.
SOLUTION OR WORK AROUND:
In order for the Knowledgebase v9.0.2 installer to properly install the DB components, the Microsoft SQL Server 2008 services (SQL Server and SQL Agent) must be running under the Local System account.
To check this:
To check this:
- Using an administrator account from within the database server, click Start>Run
- Type services.msc
- In the Services window, locate the MSSQLSERVER items (SQL Server, SQL Server Agent, etc).
- Ensure that each of the MSSQLSERVER services are configured to Log On As Local System. If any are using Network Service, change it to use Local System by right clicking the service, then clicking Properties, then clicking the Log On tab and selecting Local System account.
- After clicking OK, stop and restart the edited service to apply the new identity.
AFFECTED SYSTEMS & USERS:
System Administrators who are attempting to install Knowledgebase v9.0.2 onto Microsoft SQL Server 2008.
ADDITIONAL INFORMATION:
ESCALATION PROCEDURE:
If you have additional questions, please contact our Support team at +1 877-373-7848 (option 2) or via email at cimsupport@moxiesoft.com.