Configuring a second domain service account for NAVServer

Tbu
Member Posts: 2
NAV 2009 R2 , MS SQL Server 2008
==================================
Hi All,
for some reason we should establish a second domain account for further Nav middle tier servers to connect to the same SQL database. The problem occuring here for the second account is to set the rights to use the $ndo$navlistener schema. For the first account Microsoft recommends in the documentation:
http://msdn.microsoft.com/en-us/library/dd568739.aspx
to execute some SQL code snippets in the SQL Server management studio. This worked fine for the first account. My problem is that if I execute the recommended statement:
"CREATE SCHEMA [$ndo$navlistener] AUTHORIZATION [ReplaceWithNAVServerAccount];
GO"
for the second account (There will be arising the error, that the schema already exits - it doesn't matter) .
Then the second account works fine but the previously configuered first account lost the rights to use the $ndo$navlistener schema completely and doesn't work any more.
Is there any solution how to handle the rights regarding the $ndo$navlistener schema for a second and any further NavServer service account ? All other Kerberos stuff like SPN's, delegation etc. worked fine.
Solutions will be highly appreciated.
Th. Burchard
==================================
Hi All,
for some reason we should establish a second domain account for further Nav middle tier servers to connect to the same SQL database. The problem occuring here for the second account is to set the rights to use the $ndo$navlistener schema. For the first account Microsoft recommends in the documentation:
http://msdn.microsoft.com/en-us/library/dd568739.aspx
to execute some SQL code snippets in the SQL Server management studio. This worked fine for the first account. My problem is that if I execute the recommended statement:
"CREATE SCHEMA [$ndo$navlistener] AUTHORIZATION [ReplaceWithNAVServerAccount];
GO"
for the second account (There will be arising the error, that the schema already exits - it doesn't matter) .
Then the second account works fine but the previously configuered first account lost the rights to use the $ndo$navlistener schema completely and doesn't work any more.
Is there any solution how to handle the rights regarding the $ndo$navlistener schema for a second and any further NavServer service account ? All other Kerberos stuff like SPN's, delegation etc. worked fine.
Solutions will be highly appreciated.
Th. Burchard
0
Comments
-
Just grant access to the existing schema to the second account.________________________________
Gunnar Gestsson
Microsoft Certified IT Professional
Dynamics NAV MVP
http://www.dynamics.is
http://Objects4NAV.com0
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