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 Problem After db restore in SQL Option
m_quial
Member Posts: 16
To All,
Im not sure if you have experienced this;
(System Environment)
Windows XP SP2 (English)
SQL Server 2000 (Developer Edition) with SP4
SQL Server Option for MBS Navision 4.0 Build 20942
I have a working TESTDB1 Navision SQL database.
This database has both database and windows login users.
Using Navision backup function I created a fullbackup.
Then I created a new SQL database TESTDB2 from Navision.
Go through the usual process and restore the fullbackup that I created a while ago. The restore process was succesful and also the security synchronization.
However, when I tried to login to TESTDB1, I received a message that "The combination of user id and password is invalid".
Now I cannot log in to TESTDB1 anymore.
Is there any issues which is similar to this.
Thanks
Marlon
Im not sure if you have experienced this;
(System Environment)
Windows XP SP2 (English)
SQL Server 2000 (Developer Edition) with SP4
SQL Server Option for MBS Navision 4.0 Build 20942
I have a working TESTDB1 Navision SQL database.
This database has both database and windows login users.
Using Navision backup function I created a fullbackup.
Then I created a new SQL database TESTDB2 from Navision.
Go through the usual process and restore the fullbackup that I created a while ago. The restore process was succesful and also the security synchronization.
However, when I tried to login to TESTDB1, I received a message that "The combination of user id and password is invalid".
Now I cannot log in to TESTDB1 anymore.
Is there any issues which is similar to this.
Thanks
Marlon
0
Comments
RIS Plus, LLC
MVP - Business Apps
I think we have a little misunderstanding here.
What I meant was I cannot access anymore to my original database after I restore a full backup to a new database.
Regards,
Marlon
RIS Plus, LLC
MVP - Business Apps
1. Are you talking about SQL-BAckup or Navision Backup?
2. Do you have a full sql backup from the original database before your tries with the new one?
If so, you can restore this into the original. then everything should be as before.
But don't forget to make an actual sql backup before you try anything.....
Michael Schumacher
oh, what day is it? Backup day. OK, let's dump all data to /dev/nul ;-)