Howdy, Stranger!
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
- 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
- 305 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 993 SQL General
- 384 SQL Performance
- 34 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
- 260 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
SQL Error 15401
Ms10Key
Member Posts: 13
Good morning,
We installed NAV 2009 SP1 (Classic Client and RTC) on a SQL 2008 Server. I was able to create a partner database login via SQL and 2 Windows Logins (1 Partner (Admin) and 1 User). Both Windows logins were able to access the NAV database via the Classic Client and RTC. The problem arose when we tried to create a 3rd Windows Login via SQL. We selected the User Windows Login ID from the Active Directory list and after selecting the same items as we selected for the 1st 2 logins, selected OK and received the error SQL Error 15401: User not found as referenced in this article [http://support.microsoft.com/default.aspx?scid=kb;en-us;324321]. Makes no sense why we were able to create 2 logins and not another. We have googled the error and reviewed the before referenced support article but have had no luck in resolving this issue. Ideas? Thank you for your help!
We installed NAV 2009 SP1 (Classic Client and RTC) on a SQL 2008 Server. I was able to create a partner database login via SQL and 2 Windows Logins (1 Partner (Admin) and 1 User). Both Windows logins were able to access the NAV database via the Classic Client and RTC. The problem arose when we tried to create a 3rd Windows Login via SQL. We selected the User Windows Login ID from the Active Directory list and after selecting the same items as we selected for the 1st 2 logins, selected OK and received the error SQL Error 15401: User not found as referenced in this article [http://support.microsoft.com/default.aspx?scid=kb;en-us;324321]. Makes no sense why we were able to create 2 logins and not another. We have googled the error and reviewed the before referenced support article but have had no luck in resolving this issue. Ideas? Thank you for your help!
0
Comments
Thank!