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
- 267 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 992 SQL General
- 384 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
Error on connecting with RTC
adyturn
Member Posts: 11
Hi.
hope someone can assist with this,
i have just installed NAV 2009 R2 in a 3 tier.
i have sql 2008 R2, installed on one machine (DbServer).
i have the NAV service installed on another Server 2008 R2 machine (AppServer).
both the nav server and sql server are running with the same domain account.
i can connect via the RTC on AppServer.
i cannot connect from any other machine trying to go via the AppServer.
the message i get is as follows, "The login failed when connecting to SQL Server DbServer"
i hope someone can assist.
hope someone can assist with this,
i have just installed NAV 2009 R2 in a 3 tier.
i have sql 2008 R2, installed on one machine (DbServer).
i have the NAV service installed on another Server 2008 R2 machine (AppServer).
both the nav server and sql server are running with the same domain account.
i can connect via the RTC on AppServer.
i cannot connect from any other machine trying to go via the AppServer.
the message i get is as follows, "The login failed when connecting to SQL Server DbServer"
i hope someone can assist.
0
Comments
2) Check the event log on client and on the middle tier for more info
3) See the documentation for how to install the NAV 2009 to 3 separate computers...
MVP - Dynamics NAV
My BLOG
NAVERTICA a.s.
i have set the spn's for both the navserver and sqlserver.
there does not appear to be any related messages in the event log.
have read the docs, and followed all the steps, this is why i am now asking here, as i have done everything the docs said and still no luck.
removed the duplicate, and it works.
MVP - Dynamics NAV
My BLOG
NAVERTICA a.s.