LogIn Problem After db restore in SQL Option

m_quial

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

DenSter

Each database user needs to be a database user on SQL Server. Check to see if this is the case and create them if they're not there.

m_quial

Hi DenSter,

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

DenSter

Did you change the password of that user?

Michael_Schumacher

m_quial wrote:

I cannot access anymore to my original database after I restore a full backup to a new database.

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.....