Community
Showing results for 
Search instead for 
Do you mean 
Reply

ACT! 2011 SQL Errors

New Member
Posts: 3
Country: USA

ACT! 2011 SQL Errors

Hello,

 

I recently installed ACT! 2011 Pro on a user’s machine. We'll call this person User2. We have one other person who is using ACT! 2011 Pro as well (User1). We have a server that hosts a database for User1. User2 is able to connect to this database to view the data that User1 has entered. However, User2 is unable to create a local database on his machine. When attempting to do so, I am receiving the error "Unable to create the database. There is an error connecting to the Microsoft SQL Server." User1 does not have this problem when trying to create a local database. User2 is on a Dell Latitude D830 running Windows Vista Ultimate.

 

I took a look at the SQL (ACT7) service, and it was stopped. When I tried to restart the service, I received the error:

 

“The SQL server (ACT7) service on local computer started and then stopped. Some services stop automatically if they are not in use by other services or programs.”

 

In the event viewer, I get:

 

 

Log Name:      Application

Source:        MSSQL$ACT7

Date:          2/18/2011 9:47:59 AM

Event ID:      17207

Task Category: Server

Level:         Error

Keywords:      Classic

User:          N/A

Computer:      timbd830.wwcc.com

Description:

FileMgr:Smiley FrustratedtartLogFiles: Operating system error 2(The system cannot find the file specified.) occurred while creating or opening file 'e:\sql10_main_t.obj.x86fre\sql\mkmastr\databases\objfre\i386\MSDBLog.ldf'. Diagnose and correct the operating system error, and retry the operation.

Event Xml:

<Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">

  <System>

    <Provider />

    <EventID Qualifiers="49152">17207</EventID>

    <Level>2</Level>

    <Task>2</Task>

    <Keywords>0x80000000000000</Keywords>

    <TimeCreated SystemTime="2011-02-18T15:47:59.000Z" />

    <EventRecordID>121355</EventRecordID>

    <Channel>Application</Channel>

    <Computer>timbd830.wwcc.com</Computer>

    <Security />

  </System>

  <EventData>

    <Data>FileMgr:Smiley FrustratedtartLogFiles</Data>

    <Data>2(The system cannot find the file specified.)</Data>

    <Data>e:\sql10_main_t.obj.x86fre\sql\mkmastr\databases\objfre\i386\MSDBLog.ldf</Data>

    <Binary>37430000100000000E000000540049004D00420044003800330030005C0041004300540037000000070000006D00610073007400650072000000</Binary>

  </EventData>

</Event>

 

I also noticed in the event viewer:

 

“.NET Runtime Optimization Service (clr_optimization_v2.0.50727_32) - Failed to compile: C1.Common, Version=1.0.20042.118, Culture=neutral, PublicKeyToken=e272bb32d11b1948 . Error code = 0x80070002“

 

I have been reading on the forums here that there are issues with .NET 4.0. I can confirm that this is not installed on the machine, and was not at the time of the Sage installation. 

 

When I ran actdiag.exe, I received the error:

 

“Could not connect to the SQL server instance, click yes to continue anyway, no to restart actdiag, cancel to close”

 

After selecting yes, it shows that it is not connected.

 

I have uninstalled ACT and have tried re-installing, but had no luck. I am hoping that I have provided enough information, and that someone may have a clue as to how I can get this working. Any suggestions would be greatly appreciated. Thanks!

Platinum Elite Contributor
Posts: 14,384
Country: Australia

Re: ACT! 2011 SQL Errors

Well, it's definitely an issue with SQL not being properly installed.

 

If you're willing - uninstall again, then just install SQL and create the ACT7 instance manually as per this ACT! Knowledge Base article -

http://kb.sagesoftwareonline.com/cgi-bin/sagesoftwareonline.cfg/php/enduser/std_adp.php?p_faqid=2699...

 

You'll usually get better errors that way, with ACT! out of the equation

New Member
Posts: 3
Country: USA

Re: ACT! 2011 SQL Errors

I attempted to re-install SQL Server, and it stopped at “SqlEngineDBStartConfigAction_install_configrc_Cpu32”. The error message that popped up was “The following error has occurred: Wait on the Database Engine recovery handle failed. Check the SQL Server error log for potential causes.”

 

In Event Viewer:

 

Log Name:      Application

Source:        MSSQL$ACT7

Date:          2/18/2011 12:02:53 PM

Event ID:      15209

Task Category: Server

Level:         Error

Keywords:      Classic

User:          N/A

Computer:      timbd830.wwcc.com

Description:

An error occurred during encryption.

Event Xml:

<Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">

  <System>

    <Provider Name="MSSQL$ACT7" />

    <EventID Qualifiers="49152">15209</EventID>

    <Level>2</Level>

    <Task>2</Task>

    <Keywords>0x80000000000000</Keywords>

    <TimeCreated SystemTime="2011-02-18T18:02:53.000Z" />

    <EventRecordID>121642</EventRecordID>

    <Channel>Application</Channel>

    <Computer>timbd830.wwcc.com</Computer>

    <Security />

  </System>

  <EventData>

    <Binary>693B0000100000000E000000540049004D00420044003800330030005C0041004300540037000000070000006D00610073007400650072000000</Binary>

  </EventData>

</Event>

 

If I click ok on the error message that is presented “The following error has occurred: Wait on the Database Engine recovery handle failed. Check the SQL Server error log for potential causes”, the installation continues, but shows the Database Engine Services Failed, and then the SQL installation appears to crash with a “SQL Server 2008 R2 Setup has stopped working.” I am able tp click next in the SQL installation window, and it shows that the installation completed with errors and also shows that the "Wait on the Database Engine recovery handle failed." 

Platinum Elite Contributor
Posts: 14,384
Country: Australia

Re: ACT! 2011 SQL Errors

Is the drive/folder compressed or encrypted?
You might need to uninstall the ACT7 instance before trying the install.

If that fails and no compression/encryption, can you post the SQL log (should be linked from the error)
New Member
Posts: 3
Country: USA

Re: ACT! 2011 SQL Errors

There is no compression or encryitpion. After removing ACT! and SQL. I attempted to re-install SQL I received the same error in the same spot again. Additional infomration from the error:

 

TITLE: Microsoft SQL Server 2008 R2 Setup

------------------------------

 

The following error has occurred:

 

Wait on the Database Engine recovery handle failed. Check the SQL Server error log for potential causes.

 

For help, click: http://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft+SQL+Server&Evtsrc=setup.rll&EvtID=500...

 

------------------------------

BUTTONS:

 

OK

 

 

Also:

 

LinkID  20476

Product Name Microsoft SQL Server

Message Source          setup.rll

Message ID     50000

Product Version          10.50.1600.1

EvtType           0xE53883A0%400xBE03358B%401306%4024

 

Here is the SQL log:

 

Overall summary:

  Final result:                  SQL Server installation failed. To continue, investigate the reason for the failure, correct the problem, uninstall SQL Server, and then rerun SQL Server Setup.

  Exit code (Decimal):           -2061893608

  Exit facility code:            1306

  Exit error code:               24

  Exit message:                  SQL Server installation failed. To continue, investigate the reason for the failure, correct the problem, uninstall SQL Server, and then rerun SQL Server Setup.

  Start time:                    2011-02-18 15:36:32

  End time:                      2011-02-18 15:50:37

  Requested action:              Install

  Log with failure:              C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20110218_153405\Detail.txt

  Exception help link:           http%3a%2f%2fgo.microsoft.com%2ffwlink%3fLinkId%3d20476%26ProdName%3dMicrosoft%2bSQL%2bServer%26EvtSrc%3dsetup.rll%26EvtID%3d50000%26ProdVer%3d10.50.1600.1%26EvtType%3d0xE53883A0%400xBE03358B%401306%4024

 

Machine Properties:

  Machine name:                  TIMBD830

  Machine processor count:       2

  OS version:                    Windows Vista

  OS service pack:               Service Pack 1

  OS region:                     United States

  OS language:                   English (United States)

  OS architecture:               x86

  Process architecture:          32 Bit

  OS clustered:                  No

 

Product features discovered:

  Product              Instance             Instance ID                    Feature                                  Language             Edition              Version         Clustered

 

Package properties:

  Description:                   SQL Server Database Services 2008 R2

  ProductName:                   SQL Server 2008 R2

  Type:                          RTM

  Version:                       10

  SPLevel:                       0

  Installation location:         E:\Dependencies\SQL Express 2008 R2\x32\x86\setup\

  Installation edition:          EXPRESS

 

User Input Settings:

  ACTION:                        Install

  ADDCURRENTUSERASSQLADMIN:      True

  AGTSVCACCOUNT:                 NT AUTHORITY\NETWORK SERVICE

  AGTSVCPASSWORD:                *****

  AGTSVCSTARTUPTYPE:             Disabled

  ASBACKUPDIR:                   Backup

  ASCOLLATION:                   Latin1_General_CI_AS

  ASCONFIGDIR:                   Config

  ASDATADIR:                     Data

  ASDOMAINGROUP:                 <empty>

  ASLOGDIR:                      Log

  ASPROVIDERMSOLAP:              1

  ASSVCACCOUNT:                  <empty>

  ASSVCPASSWORD:                 *****

  ASSVCSTARTUPTYPE:              Automatic

  ASSYSADMINACCOUNTS:            <empty>

  ASTEMPDIR:                     Temp

  BROWSERSVCSTARTUPTYPE:         Automatic

  CONFIGURATIONFILE:            

  CUSOURCE:                     

  ENABLERANU:                    True

  ENU:                           True

  ERRORREPORTING:                False

  FARMACCOUNT:                   <empty>

  FARMADMINPORT:                 0

  FARMPASSWORD:                  *****

  FEATURES:                      SQLENGINE

  FILESTREAMLEVEL:               0

  FILESTREAMSHARENAME:           <empty>

  FTSVCACCOUNT:                  <empty>

  FTSVCPASSWORD:                 *****

  HELP:                          False

  IACCEPTSQLSERVERLICENSETERMS:  False

  INDICATEPROGRESS:              False

  INSTALLSHAREDDIR:              C:\Program Files\Microsoft SQL Server\

  INSTALLSHAREDWOWDIR:           C:\Program Files\Microsoft SQL Server\

  INSTALLSQLDATADIR:             <empty>

  INSTANCEDIR:                   C:\Program Files\Microsoft SQL Server\

  INSTANCEID:                    ACT7

  INSTANCENAME:                  ACT7

  ISSVCACCOUNT:                  NT AUTHORITY\NetworkService

  ISSVCPASSWORD:                 *****

  ISSVCSTARTUPTYPE:              Automatic

  NPENABLED:                     0

  PASSPHRASE:                    *****

  PCUSOURCE:                    

  PID:                           *****

  QUIET:                         False

  QUIETSIMPLE:                   False

  ROLE:                          AllFeatures_WithDefaults

  RSINSTALLMODE:                 FilesOnlyMode

  RSSVCACCOUNT:                  NT AUTHORITY\NETWORK SERVICE

  RSSVCPASSWORD:                 *****

  RSSVCSTARTUPTYPE:              Automatic

  SAPWD:                         *****

  SECURITYMODE:                  SQL

  SQLBACKUPDIR:                  <empty>

  SQLCOLLATION:                  Latin1_General_CI_AS

  SQLSVCACCOUNT:                 NT AUTHORITY\SYSTEM

  SQLSVCPASSWORD:                *****

  SQLSVCSTARTUPTYPE:             Automatic

  SQLSYSADMINACCOUNTS:           WWCC\timb

  SQLTEMPDBDIR:                  <empty>

  SQLTEMPDBLOGDIR:               <empty>

  SQLUSERDBDIR:                  <empty>

  SQLUSERDBLOGDIR:               <empty>

  SQMREPORTING:                  False

  TCPENABLED:                    0

  UIMODE:                        AutoAdvance

  X86:                           False

 

  Configuration file:            C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20110218_153405\ConfigurationFile.ini

 

Detailed results:

  Feature:                       Database Engine Services

  Status:                        Failed: see logs for details

  MSI status:                    Passed

  Configuration status:          Failed: see details below

  Configuration error code:      0xBE03358B@1306@24

  Configuration error description: Wait on the Database Engine recovery handle failed. Check the SQL Server error log for potential causes.

  Configuration log:             C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20110218_153405\Detail.txt

 

Rules with failures:

 

Global rules:

 

Scenario specific rules:

 

Rules report file:               C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20110218_153405\SystemConfigurationCheck_Report.htm

Bronze Super Contributor
Posts: 1,679
Country: Australia

Re: ACT! 2011 SQL Errors

Hi,

 

The error you're getting "SqlEngineDBStartConfigAction_install_configrc_Cpu​32" is one I've seen when the SQL installer seems to believe you already have an ACT7 instance on this machine, hence it can't install a second instance.

 

<insert disclaimer here that you're doing this at your own risk, your milage may vary, but this has worked for me>

 

The way to fix that is to remove references to the ACT7 instance in the windows registry. Sage KB 26766 is one I've found to help with that. Once you've done that I'd search the registry for any occurance of MSSQL$ACT7 and delete them.

 

Ben.

New Member
Posts: 1
Country: India

Re: ACT! 2011 SQL Errors

I also faced the same error while installing sal server 2012 .The solution given here worked fo me - http://www.superpctricks.com/2014/02/sql-install-error-database-engine-recovery-handle-failed.html