Personalized Community is here!
Quickly customize your community to find the content you seek.
Have questions on moving to the cloud? Visit the Dynamics 365 Migration Community today! Microsoft’s extensive network of Dynamics AX and Dynamics CRM experts can help.
2022 Release Wave 1 PlanDynamics 365 release plan for the 2022 release wave 1 describes all new features releasing from April 2022 through September 2022.
2022 release wave 1 plan
The FastTrack program is designed to help you accelerate your Dynamics 365 deployment with confidence.
FastTrack Community | FastTrack Program | Finance and Operations TechTalks | Customer Engagement TechTalks | Upcoming TechTalks | All TechTalks
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.
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)
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 InstallDatabase set to: '1'
Property InstallDatabase set to: '0'
Property DbServerType set to: '0'
Property DbSqlServer set to: 'mxpmamxdbpro01'
Connected to SQL Server: 'mxpmamxdbpro01'
Property DbSqlDatabaseName set to: 'PMAM_LIVE'
Property DbSqlServer set to: 'MXPMAMXDBPRO01'
Connected to SQL Server: 'MXPMAMXDBPRO01'
=== Starting execution phase ===
=== Setting up Database PMAM_LIVE ===
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)
==== Setup encountered an unhandled exception and could not be completed. For details see the previous messages in the log. ===
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
You need to have permissions on SQL to create the database like Nitesh mentioned.
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.
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.
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
Business Applications communities