Configuring a second domain service account for NAVServer

Tbu

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

thegunzo

Just grant access to the existing schema to the second account.