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

Pettalics
Member Posts: 2
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
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
0
Answers
-
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-account0
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 617 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 320 Dynamics CRM
- 111 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 990 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 35 Design Patterns (General & Best Practices)
- 1 Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1.1K General Chat
- 1.6K Website
- 83 Testing
- 1.2K Download section
- 23 How Tos section
- 252 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions