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
- 304 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 login error in conversion NAV2009SP1 to NAV2013 'R1'
greys
Member Posts: 29
Hi
I want to convert database CONVTO2013 to NAV2013R2 (via NAV2013 'R1'). I get a login error on the first step (NAV2009 -> NAV2013 R1)
What I did so far:
- I took a standard NAV2009 Cronus database and imported all our own objects.
- I created a SQL backup of it and restored in a virtual machine that only has NAV2013 (R1) installed. The machine is called NAV2013VIRTUAL
- I opened a nav2009 client and made sure the user NAV2013VIRTUAL\NAVCONVERTER was added as a windows user.
- I made sure NAV2013VIRTUAL\NAVCONVERTER has all the needed rights and roles in both NAV and SQL Server 2008 (dbo, sysadmin etc.)
- I made sure the Compatibility level of the database in Sql Server is correct (100).
- I opened the database in de NAV2013 Development Environment (build 36076).
- I confirm that I want to covert the database with OK.
- It starts redesigning and building keys.
- In the next step it says 'altering objects', all the way to 100%. Then it starts altering again, but when it gets to 5% I get the following message:
"The following SQL Server error or errors occured: 18456,"28000", Microsoft Sql Server Native Client 10.0 Login Failed for user NAV2013VIRTUAL\NAVCONVERTER. 4060, 42000. Cannot open database "CONVTO2013" requested by the login. The login failed.
So while it logs in perfectly at the start and the conversion starts, somewhere down the line it wants to log in again with the same user as it started with, but that is refused.... Has anyone encountered this problem yet?????
Best regards,
Greys
I want to convert database CONVTO2013 to NAV2013R2 (via NAV2013 'R1'). I get a login error on the first step (NAV2009 -> NAV2013 R1)
What I did so far:
- I took a standard NAV2009 Cronus database and imported all our own objects.
- I created a SQL backup of it and restored in a virtual machine that only has NAV2013 (R1) installed. The machine is called NAV2013VIRTUAL
- I opened a nav2009 client and made sure the user NAV2013VIRTUAL\NAVCONVERTER was added as a windows user.
- I made sure NAV2013VIRTUAL\NAVCONVERTER has all the needed rights and roles in both NAV and SQL Server 2008 (dbo, sysadmin etc.)
- I made sure the Compatibility level of the database in Sql Server is correct (100).
- I opened the database in de NAV2013 Development Environment (build 36076).
- I confirm that I want to covert the database with OK.
- It starts redesigning and building keys.
- In the next step it says 'altering objects', all the way to 100%. Then it starts altering again, but when it gets to 5% I get the following message:
"The following SQL Server error or errors occured: 18456,"28000", Microsoft Sql Server Native Client 10.0 Login Failed for user NAV2013VIRTUAL\NAVCONVERTER. 4060, 42000. Cannot open database "CONVTO2013" requested by the login. The login failed.
So while it logs in perfectly at the start and the conversion starts, somewhere down the line it wants to log in again with the same user as it started with, but that is refused.... Has anyone encountered this problem yet?????
Best regards,
Greys
0
Answers
The problem is caused by the fact that" Windows Access Control" and "Windows Login" tables do not exist in NAV 2013.
To resolve the problem export all records from following three tables
User
Windows Login
Windows Access Control
in a CSV file. (dataport)
After that delete all records from those three tables.
This will disable NAV 2009 authentication.
Make sure that user NAV2013VIRTUAL\NAVCONVERTER is a db_owner on the database.
(I know it is not necessary but it can removed later )
Upload a Developers licence that works for both NAV 2009 and NAV 2013.
Now complete the technical upgrade.
I hope this helps.
Best regards,
Greys