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
- 264 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 992 SQL General
- 385 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
3 Computer install issue
eagle_eye
Member Posts: 130
I have the NAV Server on Server1
I have the Database on Server 2
And have installed the clients on both Server for testing
When Connecting to the Classic SQL client - no problem
When connect to the RTC I get the following error:
The Microsoft Dynamics NAV Server cannot connect the Change Listener to the SQL Server due to the following error: Login failed for user
'DOMAIN\Server1$.
Can anyone provide me with any help in resolving this??
On the userconfig I have specified the Nav Server (Server1) as the Server
The SQL database is not installed on a named instance
The server config specifies the SQL Server computer name(Server2) as the database server name
Any ideas what I can do?
I have the Database on Server 2
And have installed the clients on both Server for testing
When Connecting to the Classic SQL client - no problem
When connect to the RTC I get the following error:
The Microsoft Dynamics NAV Server cannot connect the Change Listener to the SQL Server due to the following error: Login failed for user
'DOMAIN\Server1$.
Can anyone provide me with any help in resolving this??
On the userconfig I have specified the Nav Server (Server1) as the Server
The SQL database is not installed on a named instance
The server config specifies the SQL Server computer name(Server2) as the database server name
Any ideas what I can do?
0
Comments
Configuring Microsoft SQL Server
Installation Walkthroughs
In a 3 computer setup also read this.
Note: The setspn command for SQL Server is wrong in the docs, use "MSSQLSvc" without the computer part. And always add two service principal names: one with a fqdn, one with a computer name only.
If you have issues after this, search in this forum. I have seen your and some similar delegation related errors here before.
There is a hotfix available which deals with delegation scenarios. I didn't remind yet, so maybe someone can help me out here
Carsten
==> How To Ask Questions The Smart Way
This post is my own opinion and does not necessarily reflect the opinion or view of my employer.