Author Topic: Install ended prematurely  (Read 3568 times)

Offline OttIT

  • Newbie
  • *
  • Posts: 5
Install ended prematurely
« on: October 29, 2014, 08:50:56 AM »
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 ?

« Last Edit: October 29, 2014, 08:53:03 AM by OttIT »

Offline georgianas

  • CESMUser
  • Comodo Family Member
  • *
  • Posts: 68
Re: Install ended prematurely
« Reply #1 on: October 29, 2014, 09:54:43 AM »
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.

Offline OttIT

  • Newbie
  • *
  • Posts: 5
Re: Install ended prematurely
« Reply #2 on: November 01, 2014, 10:54:44 AM »
Okay, so here is the problem - how do we resolve?
Quote
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.

Offline OttIT

  • Newbie
  • *
  • Posts: 5
Re: Install ended prematurely
« Reply #3 on: November 01, 2014, 12:22:23 PM »
Deleted folder: C:\ProgramData\COMODO
Tried again 'Run as Administrator' and this is where it's failing:
Quote
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
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'.


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.
« Last Edit: November 01, 2014, 12:35:10 PM by OttIT »

Offline georgianas

  • CESMUser
  • Comodo Family Member
  • *
  • Posts: 68
Re: Install ended prematurely
« Reply #4 on: November 03, 2014, 04:26:09 AM »
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:
1. 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.
2. Expand Security, Expand Logins.
3. 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".
4. If NT AUTHORITY\SYSTEM is not listed, right click Logins, choose New Login, Search for System. It will add it as NT AUTHORITY\SYSTEM
5. Click Ok
6. Try installing ESM again.

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

 

Free Endpoint Protection
Seo4Smf 2.0 © SmfMod.Com Smf Destek