[solved] Migrate to SQL Server: Logins
ta5
Member Posts: 1,164
What steps are recommended concerning Logins when migrating to sql server?
E.g. DB-Logins must be created on sql-server, etc. If so, DB-Logins have a new password after migration!? What about windows logins?
Thanks in advance.
Thomas
E.g. DB-Logins must be created on sql-server, etc. If so, DB-Logins have a new password after migration!? What about windows logins?
Thanks in advance.
Thomas
0
Comments
-
Yes db logins will have new pw. Navision does not store windows logins pw so they will stay the same on SQL. You just have to add the windows users to SQL.0
-
If you don’t add the logins before the backup, the synchronization will fail, and you have to manually synchronize the logins0
-
If I got it right:
DB-Logins: Add them on the sql server and inform users on new password
Windows-Logins: No actions to be taken.
Is this the way to go?
Thanks0 -
yes

The Windows Logins must in the same domain0 -
thanks for the info, greatly appreciated!0
Categories
- All Categories
- 75 General
- 75 Announcements
- 66.7K Microsoft Dynamics NAV
- 18.8K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 610 NAV Courses, Exams & Certification
- 1.9K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 251 Dynamics CRM
- 103 Dynamics GP
- 6 Dynamics SL
- 1.5K Other
- 991 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 28 Design Patterns (General & Best Practices)
- Architectural Patterns
- 9 Design Patterns
- 4 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1K General Chat
- 1.6K Website
- 77 Testing
- 1.2K Download section
- 23 How Tos section
- 249 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
