web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics AX (Archived)

AX 2009 Installation Issue - Unexpected exception occurred during Setup

(0) ShareShare
ReportReport
Posted on by 696

Hi PPL,

It's been a while since I last installed AX 2009, I'm getting:

I'm just installing ONLY one component DataBase (custom installation)

SQL Box is Win Server 2012, SQL Server 2008 R2

AX Box is Win Server 2008 R2 Std

I've already applied "KB957312 -Fix for Reporting Extensions on Sql Server 2008" to the installation media. Both boxes have all OpSys patches applied.

Since it's a customer environment I have no access to domain admin credentials :( I suspect a permissions issue.

Knd Rgds

Full Log Contents:

>>

=== Setup logging started: 2014-09-24 20:38:00 ===

Running file: "C:\Users\AXSERV~1\AppData\Local\Temp\2\AxSetup\AxSetup.exe" RelatedFilesDir="C:\$ Dyn AX_XXXXXX\AX 2009 [5.0.593.0 July 2008] UNZIPPED"

AxSetup version number: 5.0.593.0

Microsoft Windows NT 6.1.7601 Service Pack 1 (64 bit)

MXPMAMXAX001

CORPORATIVO\AXservice

Interactive: True

RelatedFilesDir=C:\$ Dyn AX_XXXXXX\AX 2009 [5.0.593.0 July 2008] UNZIPPED

Property RelatedFilesDir set to: 'C:\$ Dyn AX_XXXXXX\AX 2009 [5.0.593.0 July 2008] UNZIPPED\'

Property SetupLanguage set to: 'EN'

=== Loading parameters from the command line or a parameter file ===

Initializing log file: C:\ProgramData\Microsoft\Dynamics AX\Dynamics AX Setup Logs\2014-09-24 20-38-00\DynamicsSetupLog.txt

=== Starting evaluation of existing installation state ===

MSI file: Components64.msi Installed: False

MSI file: ClientHelp.msi Installed: False

 

=== Checking parameters ===

Property InstallPath set to: 'C:\Program Files\Microsoft Dynamics AX\50'

Property InstallPath32Bit set to: 'C:\Program Files (x86)\Microsoft Dynamics AX\50'

=== Starting UI phase ===

Property AcceptLicenseTerms set to: '1'

Property BypassWarnings set to: '0'

Property RunMode set to: 'Custom'

Property BypassWarnings set to: '0'

Property InstallDatabase set to: '1'

Property InstallDatabase set to: '0'

Property InstallDatabase set to: '1'

Property DbServerType set to: '0'

Property DbSqlServer set to: 'mxpmamxdbpro01'

Connected to SQL Server: 'mxpmamxdbpro01'

Property DbSqlDatabaseName set to: 'PMAM_LIVE'

Property BypassWarnings set to: '0'

Property BypassWarnings set to: '0'

Property RunMode set to: 'Custom'

Property BypassWarnings set to: '0'

Property DbServerType set to: '0'

Property DbSqlServer set to: 'MXPMAMXDBPRO01'

Connected to SQL Server: 'MXPMAMXDBPRO01'

Property DbSqlDatabaseName set to: 'PMAM_LIVE'

Connected to SQL Server: 'MXPMAMXDBPRO01'

Property DbSqlDatabaseName set to: 'PMAM_LIVE'

=== Starting execution phase ===

=== Setting up Database PMAM_LIVE ===

Database: 2

Connected to SQL Server: 'MXPMAMXDBPRO01'

Exception: System.InvalidOperationException

Message: ExecuteNonQuery requires an open and available Connection. The connection's current state is closed.

FullText: System.InvalidOperationException: ExecuteNonQuery requires an open and available Connection. The connection's current state is closed.

at System.Data.SqlClient.SqlConnection.GetOpenConnection(String method)

at System.Data.SqlClient.SqlConnection.ValidateConnectionForExecute(String method, SqlCommand command)

at System.Data.SqlClient.SqlCommand.ValidateCommand(String method, Boolean async)

at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)

at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()

at Microsoft.Dynamics.Setup.InstallSqlServer.Create()

at Microsoft.Dynamics.Setup.MainForm.DatabaseInstall()

at Microsoft.Dynamics.Setup.MainForm.s250Timer_Tick()

==== Setup encountered an unhandled exception and could not be completed. For details see the previous messages in the log. ===

<<

*This post is locked for comments

I have the same question (0)
  • Verified answer
    Community Member Profile Picture
    on at

    Yes it seems to be issue due to appropriate SQL Server permission

    I suggest you should review Dynamics AX 2009 System Requirement Guide

    and Dynamics AX 2009 Installation and Configuration Guide

    for more details about permission required for installation

    Please verify and update us with your findings

  • André Arnaud de Calavon Profile Picture
    301,095 Super User 2025 Season 2 on at

    Hi Arturo,

    You need to have permissions on SQL to create the database like Nitesh mentioned.

    Microsoft.Dynamics.Setup.MainForm.s250Timer_Tick()
    

    I have also seen this same failure when it took too long to create the database (timeout issue). Net to permissions you can also check if the model database in the SQL server is setup with a large size. Creating the AX database will follow the settings on this model database.

  • Suggested answer
    Denis Macchinetti Profile Picture
    16,444 on at

    Hi Arturo

    Take a look at blogs.msdn.com/.../import-organization-problems-executenonquery-requires-an-open-and-available-connection-the-connection-s-current-state-is-closed.aspx

    Here you can find a similar issue regarding CRM.

    Seems that the issue is caused by a wrong version of the Microsoft.Net Framework version.

  • Arturo Medina Profile Picture
    696 on at

    Many thanks for your answers, this is really a generous community.

    Installation Guide, Page 22 says:

    In all cases, you must be a member of the Administrators group on the local computer where you are installing a component

    See You on The Net

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#1
Priya_K Profile Picture

Priya_K 4

#3
MyDynamicsNAV Profile Picture

MyDynamicsNAV 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans