Installing Dynamics AX 2009 with Sql Server 2012

(0) Share

Report

Posted on by Community Member

Hello,

After istalling AX 2009 on a machine with Sql Server 2012, I can't start the AOS service. The cause of the error can be found in the Events log:

Object Server 01: SQL diagnostics: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified. Connect information was: Userid = [], Database = [MicrosoftDynamicsAx], Server = [VMDEV65GRR], DSN = [], Other = []

Then I installed the SP1, the hotfix RU8, and restored the database ContosoBaseDemoDataAx2009.bak that I found in the Customer Source site. But it's still impossible to start the AOS, for the same error.

I read that this can depend on the Sql server Odbc drivers: I have following Odbc drivers: Sql Server, Sql Server Native Client 10.0 and Sql Server Native Client 11.0.

I would be grateful if anybody had this same problem and could share some knowledge with me.

Best regards,

Tino

*This post is locked for comments

I have the same question (0)

All responses (13)

Answers (1)

Sort by

Denis Macchinetti 16,444 on at

Like (0)

Report
Copy link

Link copied!

Hi Tino

About RU8, you have installed both Kernel and Application updates?

On Event Viewer, you can find more informations?

Was this reply helpful? Yes No
Martin Dráb 239,519 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Did it worked before the DB restore? If you didn't test it, try to install a new database.

Also try to install the compatibility hotfix - I installed it immediately, so I don't know what happens without it.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Thank you, I didn't install the hotfix because I already visited the page that you mention, where I found this link:

mbs2.microsoft.com/.../AssociateAccount.aspx

but here they talk about reporting services. Anyway I will try to install it now.

Could you please tell me if you usually install the SP1 before this hotfix?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Sorry the link is this one:

mbs2.microsoft.com/.../KBDisplay.aspx

but I don't think it is my case because I didn't install AS nor RS.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Hi Denis,

Yes I installed everything in RU8, and in the event viewer there is only the error that I mentioned before.

Thank you,

Tino

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Hi Martin, to answer your question, no it didn't work before the db restore. I have just installed the compatibility hotfix but the error is the same.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

The solution is in one of the comments in the page reported by Martin:

blogs.technet.com/.../announcing-compatibility-certification-of-sql-server-2012-and-sql-server-2012-sp1-with-dynamics-ax-2009-sp1.aspx

The comment says that "AX 2009 SP1 is currently not supported on Windows 2012 Server". My OS is WS 2012.

Than you all for your help.

Was this reply helpful? Yes No
Martin Dráb 239,519 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

It works for me without any problem.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Do you have SQL Server 2012 SP1?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

No I just ask because the only thing that I miss is SP1 in SQL server, I'll make the test with this too.

Was this reply helpful? Yes No