Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.6K 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
- 297 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
nav 5 server move issue please help
priory
Member Posts: 4
Today I moved my nav 5 database from sql 2005 32bit on 2008 server to sql 2005 sp3 on 2008 r2
Im having an issue where i get "the combination of user id and password entered is invalid please try again"
I have added the 64bit stored procedures and have tried many times to re sync my accounts but i can only get in as "sa"
windows authentication will not work.
I moved my database to the new server and attached it, and then added the domain users manually to the master database with the same settings as my old server.
I have deleted all users in nav and synced and they do disappear from the sql security logins but no matter what i try i cannot log in as my users.
Does anyone have a possible solution or place i need to look next
Thanks for your time
priory
Im having an issue where i get "the combination of user id and password entered is invalid please try again"
I have added the 64bit stored procedures and have tried many times to re sync my accounts but i can only get in as "sa"
windows authentication will not work.
I moved my database to the new server and attached it, and then added the domain users manually to the master database with the same settings as my old server.
I have deleted all users in nav and synced and they do disappear from the sql security logins but no matter what i try i cannot log in as my users.
Does anyone have a possible solution or place i need to look next
Thanks for your time
priory
0
Comments
1. Delete the NAV database on the new server. be sure you have saved a copy.
2. Delete the SQL Server Logins that you created on the new server.
3. Transfer logins from old to new server. See this for the process: http://support.microsoft.com/kb/918992/
4. Put the NAV DB back on the new server.
5. Login to NAV and sync security.
I have tried the ms article but i still don't get any users in my new sql server.
i still get the password message on nav.
Is there anything else i may of missed
I only have 40 users, and currently they all have super access.
so I
logged into my new database server as sa,
went into tools "object designer"
opened Windows login & windows access control tables
deleted all users
Then returned to Tools , security, windows logins and re created my users and
set the roles back to super (for now)
then synced all users.
And im happily up and running again.
:thumbsup: