Install ended prematurely

OttIT · October 29, 2014, 1:50pm

Installing 3.2.1009.132 - Typical - SQL server express localDB
on Win 7-32 bit with UAC disabled, previous security suite uninstalled and restarted computer, Windows firewall off

It gets past installing localDB in the beginning, on towards the end to

copying new files configuring ESM server settings
Installing database … this seems to take a while
and then it goes to Rolling back action-> ended prematurely

Does the installer create a log so I can see what the hang up is ?

I have also tried many things

restarting computer and retry installer
restart, uninstall localDB in add/remove programs (which seemed to have installed alright anyway), restart, retry installer
tried installing full SQL server and set it to use that, again that seemed to have worked fine - the DB with the name I chose did get created.

The only complication I can think of is that I already have SQL server compact edition installed on this workstation for use in another program.

Is it failing at Installing database - or what is the next step - is it failing there ?

mimo1112 · October 29, 2014, 2:54pm

Hi,

Please look for the log in %temp%\CESM_Setup\CESM Installer Log.txt
It should provide you the error regarding the localDB, and at which step is failing.

OttIT · November 1, 2014, 3:54pm

Okay, so here is the problem - how do we resolve?

Custom action 'InstallDatabase' : Database connection test failed: System.InvalidOperationException: The database with name 'C:\ProgramData\COMODO\ESM\CrmEntities.mdf' cannot be used because it is not a part of this product or it is not enough rights to access to the database. at CRM.DatabaseInstaller.Installer.TestDatabaseConnection(String windowsLogin) at WixServerSetupCA.CustomActionsImpl.TestDatabaseConnection(CustomActionSession session, String connStr) MSI (s) (F4!60) [09:39:17:957]: Closing MSIHANDLE (1335) of type 790531 for thread 3424 MSI (s) (F4!60) [09:39:17:957]: Creating MSIHANDLE (1336) of type 790531 for thread 3424 Custom action 'InstallDatabase' : Finished with the error: System.InvalidOperationException: The database with name 'C:\ProgramData\COMODO\ESM\CrmEntities.mdf' cannot be used because it is not a part of this product or it is not enough rights to access to the database. at CRM.DatabaseInstaller.Installer.TestDatabaseConnection(String windowsLogin) at WixServerSetupCA.CustomActionsImpl.TestDatabaseConnection(CustomActionSession session, String connStr) at WixServerSetupCA.CustomActionsImpl.TestDatabaseConnection(CustomActionSession session, String connStr, Int32 maxTries) at WixServerSetupCA.CustomActionsImpl.InstallDatabase(CustomActionSession session) at WixServerSetupCA.CustomActions.ExecuteCustomAction(Func`2 caFunction, Session session, Boolean onControlEvent) MSI (s) (F4!60) [09:39:17:957]: Closing MSIHANDLE (1336) of type 790531 for thread 3424 CustomAction InstallDatabase returned actual error code 1603 (note this may not be 100% accurate if translation happened inside sandbox) MSI (s) (F4:54) [09:39:22:278]: Closing MSIHANDLE (1316) of type 790536 for thread 4548 Action ended 9:39:22: InstallFinalize. Return value 3.

OttIT · November 1, 2014, 5:22pm

Deleted folder: C:\ProgramData\COMODO
Tried again ‘Run as Administrator’ and this is where it’s failing:

Custom action 'InstallDatabase' : Testing database connection ... MSI (s) (30!88) [13:18:30:090]: Closing MSIHANDLE (409) of type 790531 for thread 6792 MSI (s) (30!88) [13:18:30:106]: Creating MSIHANDLE (410) of type 790531 for thread 6792 Custom action 'InstallDatabase' : Checking whether database exists... MSI (s) (30!88) [13:18:30:106]: Closing MSIHANDLE (410) of type 790531 for thread 6792 MSI (s) (30!88) [13:18:31:463]: Creating MSIHANDLE (411) of type 790531 for thread 6792 Custom action 'InstallDatabase' : Checking whether 'NT AUTHORITY\SYSTEM' can create database ... MSI (s) (30!88) [13:18:31:463]: Closing MSIHANDLE (411) of type 790531 for thread 6792 MSI (s) (30!88) [13:18:31:603]: Creating MSIHANDLE (412) of type 790531 for thread 6792 Custom action 'InstallDatabase' : Database connection test succeeded. MSI (s) (30!88) [13:18:31:603]: Closing MSIHANDLE (412) of type 790531 for thread 6792 MSI (s) (30!88) [13:18:31:603]: Creating MSIHANDLE (413) of type 790531 for thread 6792 Custom action 'InstallDatabase' : Installing database 'C:\ProgramData\COMODO\ESM\CrmEntities.mdf'... MSI (s) (30!88) [13:18:31:603]: Closing MSIHANDLE (413) of type 790531 for thread 6792 MSI (s) (30!88) [13:18:31:603]: Creating MSIHANDLE (414) of type 790531 for thread 6792 Custom action 'InstallDatabase' : Checking whether database exists... MSI (s) (30!88) [13:18:31:603]: Closing MSIHANDLE (414) of type 790531 for thread 6792 MSI (s) (30!88) [13:18:31:603]: Creating MSIHANDLE (415) of type 790531 for thread 6792 Custom action 'InstallDatabase' : Creating database... MSI (s) (30!88) [13:18:31:603]: Closing MSIHANDLE (415) of type 790531 for thread 6792 MSI (s) (30!88) [13:18:38:093]: Creating MSIHANDLE (416) of type 790531 for thread 6792 Custom action 'InstallDatabase' : Creating database schema... MSI (s) (30!88) [13:18:38:093]: Closing MSIHANDLE (416) of type 790531 for thread 6792 MSI (s) (30!88) [13:18:38:405]: Creating MSIHANDLE (417) of type 790531 for thread 6792 [b]Custom action 'InstallDatabase' : Database command failed with error: Unable to open the physical file "C:\ProgramData\COMODO\ESM\CrmEntities_events.ndf". Operating system error 2: "2(The system cannot find the file specified.)". Cannot open database "C:\PROGRAMDATA\COMODO\ESM\CRMENTITIES.MDF" requested by the login. The login failed. Login failed for user 'NT AUTHORITY\SYSTEM'.[/b]

The folder only has CrmEntities_log.ldf and CrmEntities.mdf, there is no CrmEntities_events.ndf file installed - no line for _events further up like this one:
Installing database ‘C:\ProgramData\COMODO\ESM\CrmEntities.mdf’

I can’t believe this is being so difficult.

mimo1112 · November 3, 2014, 9:26am

Hi,
The logs say CESM cannot access the database. I may be NT AUTHORITY\SYSTEM is not listed as a SQL user or it does not have DbCreator rights.
Try these steps:

Install MIcrosoft SQL Server Management Studio 2012 and open Microsoft SQL Server Management Studio, connect to the local Db. It should be (localDb)\v11.0, using Windows Authentication.
Expand Security, Expand Logins.
If NT AUTHORITY\SYSTEM exists in that list, double click on it, click on Server Roles, and make sure you add a check mark for “dbcreator” and “sysadmin”.
If NT AUTHORITY\SYSTEM is not listed, right click Logins, choose New Login, Search for System. It will add it as NT AUTHORITY\SYSTEM
Click Ok
Try installing ESM again.

If it’s still failing after these steps please send an email to esmsupport@comodo.com and a remote session can be scheduled to help you with the installation.