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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / SQL Installation Guide
Microsoft Dynamics AX (Archived)

SQL Installation Guide

(0) ShareShare
ReportReport
Posted on by imecoax 680

Hi people,

We are now at the stage of installing the AX 2012R2 software and SQL is obviously part of this. Does anyone have a step-by-step guide (for AX) as how to do this. This is the test environment but I would like to follow best practices down to every detail.

Thanks everyone!

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    PA-22040759-0 Profile Picture
    PA-22040759-0 6,194 on at

    There is some information on how to setup SQL Server in the AX installation guide: www.microsoft.com/.../details.aspx.

  • Verified answer
    Dick Wenning Profile Picture
    Dick Wenning 8,705 Moderator on at

    don't forget these

    blogs.msdn.com/.../axperf

  • Suggested answer
    Community Member Profile Picture
    Community Member on at

    I don't really have a guide but I've done the SQL upgrade already as part of our upgrade project.   Basically, the SQL upgrade can be easy or hard depending on how you do it.  What I did:

    *Look for SQL 2012 upgrade assistant and run it.  It will tell you some of the changes you need to make.  Warning - it may not give you a complete list.

    1.  Back up the databases and move backup to a safe location

    2.  Shut down SQL service

    3.  Control panel/programs --- uninstall all of SQL

    4.  Reboot

    5.  Install SQL 2012 as a new installation.  Prep here is crucial.  Make sure you have all accounts with correct roles before you start.  Normal SQL installation roles apply.

    6.  Import your backup from step 1.

    7.  Check to see that all tables came across.  Check to see all users exist with correct roles and permissions.  Hopefully you already have who has what permissions documented.

    8.  Reboot

    9.  Connect AX.

    Be very careful what else you upgrade.  I went and grabbed MS updates too and found out the hard way that AX 2012 does not work within .NET 4.5 depending on what addition you are on.

    *Note, your results may vary.  See also AX installation guide to find more info on setup.  If your upgrade lasts more than four hours, see you doctor.  No warranty implied.

  • imecoax Profile Picture
    imecoax 680 on at

    Hello Again,

    Thanks for all the great responses!

    I was just wondering about which specific options I should use during the install for AX (like which components)?

    Also, is everyone using the new managed accounts features in Windows 7 / 2008 / 20012?

    Thanks

  • imecoax Profile Picture
    imecoax 680 on at

    Sorry my apologies, I mean which components should be installed for the SQL part of the installation.

    There are so many there and I am a little confused which options to add.

    Should I be using service managed accounts?

    Thanks again!

  • imecoax Profile Picture
    imecoax 680 on at

    Perfect..! Thanks to everyone!

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the March Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Joris dG Profile Picture

Joris dG 5

#2
Alexey Lekanov Profile Picture

Alexey Lekanov 2

#2
Henrik Nordlöf Profile Picture

Henrik Nordlöf 2 User Group Leader

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans