[solved] How to set different SQL SERVER instance on Dynamics Nav 2018 client

dissco6dissco6 Member Posts: 14
edited 2024-01-19 in NAV Three Tier

I had to create an additional instance of SQL SERVER.

I can set that instance in development by defining Database Server to SRVNAV\MSSQLSERVER01 and Server Instance as link/dynamicsnav110. And it seems to set fine in dev environment.


BUT when I try to open some page, i get data from old instance, and I not sure how should I access the Instance of sql server that I need.


Client is Dynamics NAV 2018

Sorry if my question is dumb or smth, but I'm fairly new here, so how could I solve this problem?

Ty for all answers


  • vaprogvaprog Member Posts: 1,113
    You need to configure your middle tier service to use the database on the new instance.
  • dissco6dissco6 Member Posts: 14
    @vaprog Could you please elaborate more on that?
  • guydeschepper@hotmail.com[email protected] Member Posts: 16
    Hi @dissco6 ,

    with client, you only choose to connect to a service instance (=middle tier service). It is the service instance where you define to which database on which sql server/instance you will be connecting
    example: "business central administration"
    I have multiple instances, all connecting to different databases and or servers
  • dissco6dissco6 Member Posts: 14
    Just had to delete some cache files :)
Sign In or Register to comment.