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
- 270 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
- 259 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Options
Login failed when connecting to SQL with database login
fgudelj
Member Posts: 29
Hi,
I've a problem and need your help.
I've install the SQL2008 R2 and the NAV2009 (both classic sql and RTC). Cronus database is working fine: it connects and opens even the RTC without problems.
Now, we've done NAV 4.0 SP3 upgrade which already had database in SQL. When I tryed to open the database in classic NAV this is what happened:
- with Database Authentication: "The login failed when connecting to SQL Server NAMEINSTANCE"
- with Windows Authentication: everything was ok.
Please, could you help me with this problem?
I've also tried to restore databse with SQL user, setup new users and roles, deleted and recreated old roles and nothing worked.
For some sceptics I've synced logins everytime I made login modifications and reenetered NAV classic client.
Wait for your help...
Filip
I've a problem and need your help.
I've install the SQL2008 R2 and the NAV2009 (both classic sql and RTC). Cronus database is working fine: it connects and opens even the RTC without problems.
Now, we've done NAV 4.0 SP3 upgrade which already had database in SQL. When I tryed to open the database in classic NAV this is what happened:
- with Database Authentication: "The login failed when connecting to SQL Server NAMEINSTANCE"
- with Windows Authentication: everything was ok.
Please, could you help me with this problem?
I've also tried to restore databse with SQL user, setup new users and roles, deleted and recreated old roles and nothing worked.
For some sceptics I've synced logins everytime I made login modifications and reenetered NAV classic client.
Wait for your help...
Filip
Filip Gudelj | Dynamics NAV Consultant | http://bsinsight.wordpress.com/
0
Comments
I compared my developer licence (has this codeunit), and end-user licence (doesn't have this codeunit).
I'm a little confused because this codeunit should be available in end-user licence because it is root NAV 2009 functionality, or it shouldn't be available....?
Can you login in SSMS using the Database Login credentials?
No: Is the SQL Server in Mixed Mode? (and has been restarted after it was changed?)
Yes: Have you tried Syncronizing Security when logged in with a Windows user?
Peter
And I've also tried closing and opening NAV client after each syncronization, and also no success..
Try these:
-enable the SQL server browser service.
-instead of the name of the server, try to use its IP address + port on which this named server is listening (something like:10.1.1.15:1427)
No PM,please use the forum. || May the <SOLVED>-attribute be in your title!
But I've solved issue by removing logins (manualy) from SQL, creating them with assigned User mapping and after that syncronizing NAV users.