Multiple Database Delegation.
jagtap.ganesh
Member Posts: 11
Hi,
One of our client has 2 databases for 2 different operating companies.
Here we have the architecture of 3 tiers on 3 machines.
setup scenario is:
clustered SQL Db : Both databases will be on the same clustered enivironment.
NAV server machine 1: NAV server for 1st DB
NAV server machine 2: NAV server for 2nd DB
here all of these services will be running with same domain USER ID.
The thing is, when we did installation of first, there were no issues in setting up the delegations to user running the services.
now for installing another database, we have a issue in setting up the delegation.
for clustered environment, there will be 4SPNs required.
DynamicsNAV/<machine-name>:7046
DynamicsNAV/<Fully Qualified Domain Name machine-name>:7046
MSSQLSvc/<machine-name>:1433
MSSQLSvc/< Fully Qualified Domain Name machine-name>:1433
not in out case,
there should be total 8 SPNs
but as SQL system is same
there will be total 6 SPNs.
1.Will this work?
2.Same user running all services, so setting up these SPNs for user delegation.
this is not working.
3.can i have the same Service name as Dynamics NAV and same port noumber 7046 for both the NAV servers?
if anybody has done something like this,
please suggest a proper way to do it... #-o
Thanks,
Ganesh.
One of our client has 2 databases for 2 different operating companies.
Here we have the architecture of 3 tiers on 3 machines.
setup scenario is:
clustered SQL Db : Both databases will be on the same clustered enivironment.
NAV server machine 1: NAV server for 1st DB
NAV server machine 2: NAV server for 2nd DB
here all of these services will be running with same domain USER ID.
The thing is, when we did installation of first, there were no issues in setting up the delegations to user running the services.
now for installing another database, we have a issue in setting up the delegation.
for clustered environment, there will be 4SPNs required.
DynamicsNAV/<machine-name>:7046
DynamicsNAV/<Fully Qualified Domain Name machine-name>:7046
MSSQLSvc/<machine-name>:1433
MSSQLSvc/< Fully Qualified Domain Name machine-name>:1433
not in out case,
there should be total 8 SPNs
but as SQL system is same
there will be total 6 SPNs.
1.Will this work?
2.Same user running all services, so setting up these SPNs for user delegation.
this is not working.
3.can i have the same Service name as Dynamics NAV and same port noumber 7046 for both the NAV servers?
if anybody has done something like this,
please suggest a proper way to do it... #-o
Thanks,
Ganesh.
Ganesh Jagtap | Senior Technical Consultant
PO Box 36500 | Dubai | UAE
Mobile:+97150 150 5389
PO Box 36500 | Dubai | UAE
Mobile:+97150 150 5389
0
Comments
-
"a proper way to do it" hmmm
F*** knows.
The security setup for the RTC is far too complex for normal people, I think the kerberos delegation concept was included for organisations that include a salaried "security control officer" who isn't aka "night watchman".
So in this case I would suggest you pay for a Microsoft support call and get them to fix the mess.
Maybe next release they'll dump it ... I can live in hope.
Robert de Bath
TVision Technology Ltd0 -
Its Done! :thumbsup:
No need for MS support
Ganesh.Ganesh Jagtap | Senior Technical Consultant
PO Box 36500 | Dubai | UAE
Mobile:+97150 150 53890
Categories
- All Categories
- 75 General
- 75 Announcements
- 66.7K Microsoft Dynamics NAV
- 18.8K 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
- 610 NAV Courses, Exams & Certification
- 1.9K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 251 Dynamics CRM
- 103 Dynamics GP
- 6 Dynamics SL
- 1.5K Other
- 991 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 28 Design Patterns (General & Best Practices)
- Architectural Patterns
- 9 Design Patterns
- 4 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1K General Chat
- 1.6K Website
- 77 Testing
- 1.2K Download section
- 23 How Tos section
- 249 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions