Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / NAV 2009 - SQL Server ...
Small and medium business | Business Central, N...
Suggested answer

NAV 2009 - SQL Server Accessibility

(1) ShareShare
ReportReport
Posted on by Thanigaivelan S 20

Hello experts,

Have few queries regarding NAV 2009 SQL Server compatibility.

I have 2 SQL Server instances in my local.

pastedimage1683737358462v1.png

When I installed NAV 2009 R2 - by default, the demo DB gets restored in 1st server.

But I have another DB restored in 2nd Server. I need to access that SQL Server in NAV 2009 development environment. The 2nd Server is not shown up in NAV 2009 development environment.

Attaching the NAV Dev Env. screenshot for reference.

pastedimage1683737665862v2.png

Please suggest me a way to access the 2nd SQL Server from NAV 2009.

Thanks in advance.

  • Ron.McV Profile Picture
    Ron.McV 98 on at
    RE: NAV 2009 - SQL Server Accessibility

    As mentioned the other replies, officially SQL support for NAV 2009 was through SQL Server 2014.  However I might not be fully convinced about that as I have heard some that do.  I would double check in the NAV Administrative tool and confirm the instance and that the port.

    I would confirm these three (3) things:

    1. Verify that the correct instance name and port have been specified in the NAV Development Environment settings for the second instance.

    2. Verify that the account being used to connect to the NAV database has the necessary permissions to access the database.

    3. Check to make sure that the appropriate ports are open on the firewall and that there are no network issues preventing communication between the NAV Development Environment and the SQL Server 2022 instance.

    ==================

    *******: Compatibility issues: While it is possible to use NAV 2009 with SQL Server 2022, it is an unsupported configuration, and there may be compatibility issues that prevent the NAV Development Environment from connecting to the database.

  • Ron.McV Profile Picture
    Ron.McV 98 on at
    RE: NAV 2009 - SQL Server Accessibility

    I would check with your  SQL Server Configuration Manager  and ensure that Name pipes is enabled on the SQL Server Instance.  Of course assuming that this SQL instance reachable? (e.g., you can ping the server etc.).  

    Additionally with regards to that instance either in services or SQL Server Configuration Manager ensure that SQL Server Browser service for that instance is running.  

    so again check that the Second instance is configured in the SQL Server Configuration Manager the same way that the 1st instance is that is reachable.

    This points to an assumption that at the network layer everything is good.  

    ps. I hope this helpful

  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 73,696 Super User 2024 Season 2 on at
    RE: NAV 2009 - SQL Server Accessibility

    It seems that you want to use the NAV2009 development environment to connect to the SQL Server 2022 database. . . .

    Sorry I haven't tested it, but NAV2009 has been out of support for over three years. If you try to connect, you can restore the server to the 9.0 instance above.

    https://learn.microsoft.com/en-us/lifecycle/products/dynamics-nav-2009-r2

    pastedimage1683766738686v1.png

    Hope this can give you some hints.

    Thanks.

    ZHU

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans