Dear all expert,
I’ve already setup new environment for NAV 2009 SP1 in 2 PC, including:
1. Database Server (Name: SQLSERVER2008)
Configuration:
• Windows Server 2008 Std Edition 64 bit
• Domain Controller
• SQL Server 2008 Std Edition 64 bit with default instance (Service running on domain administrator account)
• Database Component for NAV
2. NAV Service Tier + Client (Name: DYNNAV-SERVER)
Configuration:
• Windows Server 2008 Std Edition 64 bit
• NAV Service Tier (Service running on Domain account with local administrator privileges)
• Classic Client
• Role Tailored Client
On DYNNAV-SERVER computer, with domain administrator privileges, I’ve successfully execute Classic Client and RTC Client. But, problem occurred when I execute RTC Client with domain user (without administrator privileges) saying “A server was not found at “net.[url=tcp://dynnav-server:7046/DynamicsNAV/Service]tcp://dynnav-server:7046/DynamicsNAV/Service[/url]”. Either the URL is incorrect or the server is currently not available”. I’ve also checked that the NAV service is still running. What I’ve done so far is on the following lists:
1. Granted the domain user for all possible NAV folders on NAV Service Tier machine (also on C:\Windows\Temp).
2. Execute below query for enable Change Listener:
ALTER USER [TEST\RTCUser] WITH DEFAULT_SCHEMA = [$ndo$navlistener];
GRANT SELECT ON [Object Tracking] TO [TEST\RTCUser];
// RTCUser is the name of my domain user
3. Create Service Principe Names
4. Delegate access to SQL Server Service (on SQLSERVER2008 machine)
5. Restart Server
But, no good result happened. The error is still the same. FYI, Classic client can be executed successfully from this domain user. I’ve tried to search any clue on this forum (and implement it as far as i can) but still cannot solve my problem. Please advice.
Regards,
Karl
0
Comments
Thanks for the reply, seem it doesn't work also. Just want to clarify things, for delegation and SPN, we've just setup one administrator user only (not for every domain user), is it right?
My Delegation is applied on Domain controller and SPN is applied on Domain Controller and NAV Servie Tier machine. Is it correct?
Please enlighten me.
Regards,
Karel
Apply SPNs and delegation for the user that runs the NavServer - it must be just domain user and to have access to NAV databese. Apply the MSSQLSvc spn for delegation.
Thanks for your explanation. Sorry that I've forget to mention that I'm using Virtual machine. It seems I have trouble with SID of the virtual machine and have dissfunctional network between my virtual machine. So, I'll try to reinstall all again from the beginning and will keep you updated about this.
Thanks.
Regards,