Devolutions ForumDevolutions Forum

MS SQL Express from 2017 to 2022

MS SQL Express from 2017 to 2022

avatar
andreas06

HI Devolutions Team,

we are currently doing a migration from MS SQL Express 2017 to 2022. RDM is 2023.2.27.0

We have backed up the DB and restored it to the new server. This worked without any errors.

However, when connecting to the DB, the password is rejected.

Is the procedure wrong?

Best, Andy

All Comments (1)

avatar
Stéfane Lavergne

SQL Server Backup/Restore does not backup/restore the logins (in master DB) only the users (RDM DB).

There are many ways to fix this, Google will give you a few options. In your case the easiest is using RDM, login with your sa account (dbo equivalent) and for each user press the Fix SQL Login button (hammer).

Best regards,

Stéfane Lavergne