You’re offline. This is a read only version of the page.
20
Hello experts,
Have few queries regarding NAV 2009 SQL Server compatibility.
I have 2 SQL Server instances in my local.
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.
Please suggest me a way to access the 2nd SQL Server from NAV 2009.
Thanks in advance.
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.
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
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
Hope this can give you some hints.
Thanks.
ZHU
#1
André Arnaud de Cal...
291,969
Super User 2025 Season 1
#2
Martin Dráb
230,842
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
