Hi, my SQL install has a user called 'sitecore' with password '123'.
When I import a database (another MDF) from another machine that also had the user 'sitecore' but with a different password of 'oldpass' I cannot login.
On the imported machine trying both sitecore/123 or sitecore/oldpass does not work.
One solution I found was deleting the 'sitecore' user from the imported database and creating it again, but I don't want to do that. Is there a way to match these usernames up so I can login?