AOS Server Installation Ax 2009 error

Finance and Operations/AX Developer Forum
1

Hi,

I am trying to install Ax 2009 AOS Server on one my machines. I am getting the following error . Can you please let me know what could cause this error ?

I have SQL Server 2008 R2 installed and was able to connect through Management Studio

roperty DbServerType set to: ‘0’
Property DbSqlServer set to: ‘(local)\sqlExpress’
Connected to SQL Server: ‘(local)\sqlExpress’
Property DbSqlDatabaseName set to: ‘DynamicsAx1’

=== Starting execution phase ===
=== Setting up Database DynamicsAx1 ===
Database: 2
Connected to SQL Server: ‘(local)\sqlExpress’
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 lo

2

hi,

Can u please eloborate the issue… Exactly at which point, you are getting this error. What are the things u have previously installed? What is the operating system?

What is your system configuration and the space you are having?

Thanks and Regards,
Kevin

3

HI,

I have installed Sql Server 2008 R2 named instance on one of my XP machines. When i try to install the database through the AX installation , i am getting the error that i mentioned.

4

Hi,

Are u installing Stand Alone Ax? or Client Ax?

If client, then you no need to add database component while installing Ax…

Are u installing Ax in which where you have installed SQL server 2008?

Whether your system is in Domain? Coz u have mentioned that you are installing in your xp machines…

Have u checked whether you have given the AOS nmae correctly?