SQL 2012 - Database Move to new server - Unknown SQL User password
Posted on 2016-09-18
Ive been asked to move a DB to a new server.
Current and new SQL servers are running Server2012R2, both members of the domain, and both have identical versions SQL versions 11.0.5613.
The DB has 2 x local SQL users - And you guessed it, no one knows the passwords for these accounts.
Is there any way of showing these passwords, or exporting\importing the SQL users from one SQL Server to another?.