Resolve EngageOne Content Author Installation: Could not find stored procedure 'sp_GetDBVersion'
Software Affected: EngageOne Content Author
Issue
The Admin Web Client fails to start.
Cause
The Event Viewer shows the following error: Message: Could not find stored procedure 'sp_GetDBVersion'
Resolution
UPDATED: October 16, 2017The Admin Tool is connected to the wrong database. The CCMContentAuthor and ResourceServer should be two separate databases.
CCM Congiguration Tool:
1.Web Client - The database name should be CCMContentAuthor and the instance name is the name of the SQL Server instance.
2.Administration Client - The Admin Client should also have the same database name as the Web Client, which is CCMContentAuthor.
3.Resource Server - The Resource Server should have a different database name, in this case, it is ResourceServer.
CCM Congiguration Tool:
1.Web Client - The database name should be CCMContentAuthor and the instance name is the name of the SQL Server instance.
2.Administration Client - The Admin Client should also have the same database name as the Web Client, which is CCMContentAuthor.
3.Resource Server - The Resource Server should have a different database name, in this case, it is ResourceServer.
