Skip to main content

Notifications

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) / 1 AOS Connection to Mu...
Microsoft Dynamics AX (Archived)

1 AOS Connection to Multiple DB

(0) ShareShare
ReportReport
Posted on by Community Member

Hi

Can i connect 1 AOS server to Multiple DB Server without changing the configuration? For example i have AXAPP and want to connect it to DB1 and DB2.

TIA

*This post is locked for comments

  • Suggested answer
    nmaenpaa Profile Picture
    nmaenpaa 101,156 on at
    RE: 1 AOS Connection to Multiple DB

    Marielle, yes, in AX server configuration utility you would put the SQL cluster listener address as the db server name.

    You should contact a database specialist for configuring SQL clusters. But it's definetely advisable to have a failover / alwaysOn solution in your AX production SQL.

    AOS clusters is a completely different thing and not related to SQL failover.

  • Community Member Profile Picture
    Community Member on at
    RE: 1 AOS Connection to Multiple DB

    Sorry, im still confuse. We connect the AX using the AX server Configuration right? This is were we input the db name.

    You mean AOS connects to 1 listener add with db cluster ( DB1 and Db2)?

  • Suggested answer
    nmaenpaa Profile Picture
    nmaenpaa 101,156 on at
    RE: 1 AOS Connection to Multiple DB

    This is something you configure in the database, not AOS. A SQL failover cluster should have one common listener address where the AOS connects. AOS should not have to worry about which node is active and which is not.

    Clients connect to AOS, not database. Only AOS is connected to the database.

  • Community Member Profile Picture
    Community Member on at
    RE: 1 AOS Connection to Multiple DB

    We would like to create failover. Once db1 is down or disconnected db2 should up.

    Do we to reconfig each client to connect to db2?

  • Suggested answer
    nmaenpaa Profile Picture
    nmaenpaa 101,156 on at
    RE: 1 AOS Connection to Multiple DB

    ..and by this I mean only one AX database. You can of course open ODBC connections in your code and connect to any database to perform queries.

  • Suggested answer
    nmaenpaa Profile Picture
    nmaenpaa 101,156 on at
    RE: 1 AOS Connection to Multiple DB

    No. The AOS can connect only to one database at a time.

    Why would you want to connect to multiple databases? How would you expect the application to work?

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

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,516 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,432 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans