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

dissco6

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.



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

vaprog

You need to configure your middle tier service to use the database on the new instance.

dissco6

@vaprog Could you please elaborate more on that?

guydeschepper@hotmail.com

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

dissco6

Just had to delete some cache files