Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.5K Microsoft Dynamics NAV
- 18.5K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 115 Navision DOS
- 854 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 615 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 267 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 992 SQL General
- 384 SQL Performance
- 33 SQL Tips & Tricks
- 34 Design Patterns (General & Best Practices)
- Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.7K General
- 1.1K General Chat
- 1.6K Website
- 79 Testing
- 1.2K Download section
- 23 How Tos section
- 259 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Options
Three tier installation using service account
sendoh
Member Posts: 207
Hi Expert,
I have a situation below(as this just for POC).
AD - 192.168.0.1 - Domain controller(Windows Server 2008 R2)
DB - 192.168.0.2 - Database server(MSSQL 2008R2 in Windows Server 2008 R2)
NST - 192.168.0.3 - Nav Service Tier(NAV2009R2 in Windows Server 2008 R2).
I already set up the object listener as my ReplacewithServerName = NAVPOC\NST$
and based on the walkthorugh I don't need to set SPN as I used Service Account in my NST and in SQL.
when I connect using NST computer(using domain account as NAVPOC\Admin, I can connect to the database and succesfully run the RTC, but when I tried to connect using remote user(using same account NAVPOC\Admin) by setting up "UserName" in Credential configfile. it gives an error
Microsoft Dynamics NAV
The login failed when connecting to SQL Server 192.168.0.2
OK
Please help, what I missed?
Thanks.
I have a situation below(as this just for POC).
AD - 192.168.0.1 - Domain controller(Windows Server 2008 R2)
DB - 192.168.0.2 - Database server(MSSQL 2008R2 in Windows Server 2008 R2)
NST - 192.168.0.3 - Nav Service Tier(NAV2009R2 in Windows Server 2008 R2).
I already set up the object listener as my ReplacewithServerName = NAVPOC\NST$
and based on the walkthorugh I don't need to set SPN as I used Service Account in my NST and in SQL.
when I connect using NST computer(using domain account as NAVPOC\Admin, I can connect to the database and succesfully run the RTC, but when I tried to connect using remote user(using same account NAVPOC\Admin) by setting up "UserName" in Credential configfile. it gives an error
Microsoft Dynamics NAV
The login failed when connecting to SQL Server 192.168.0.2
OK
Please help, what I missed?
Thanks.
Sendoh
be smart before being a clever.
be smart before being a clever.
0
Comments
I am no expert but I was wondering because of your post ..
Please have a look on the installation guide again.
Walkthrough
In my opinion you can not connect from a client without SPN in your current configuration. There is no permission for the service account that he is allowed to impersonate from your middle tier.
Please correct me if I am wrong.
greetings mik
With kind regards
mik
be smart before being a clever.
MVP - Dynamics NAV
My BLOG
NAVERTICA a.s.
be smart before being a clever.