Connecting middle tier to SQL using a service/single account?

Pettalics

Hi All

I've seen this done and I really should have paid more attention at the time but didn't think I'd ever need it again.

Basically they setup NAV to authenticate to SQL using a single service account rather than the usual multiple users. I assume the users connect to the middle tier and then the requests to SQL happen through the service or single account. Can anyone point me to more information on how to achieve this?

Many thanks

P

Pettalics

Found it... ignore the message but it here if anyone else is looking: https://docs.microsoft.com/en-us/dynamics-nav/provisioning-the-microsoft-dynamics-nav-server-account