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

dissco6
dissco6 Member Posts: 14
edited 2024-01-19 in NAV Three Tier
Hello,

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.

kmvj2444a6iq.png

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.

34vfy2k30t5r.png

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

Answers

  • vaprog
    vaprog Member Posts: 1,161
    You need to configure your middle tier service to use the database on the new instance.
  • dissco6
    dissco6 Member Posts: 14
    @vaprog Could you please elaborate more on that?
  • guydeschepper@hotmail.com
    guydeschepper@hotmail.com Member Posts: 17
    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
    k45w3cel7cny.png
  • dissco6
    dissco6 Member Posts: 14
    Just had to delete some cache files :)

Categories