I am currently facing the problem that someone working here changed the password of the
sa user of the Microsoft SQL Server 2005. The SQL-Server is running on a VM, and the application we run won't let me change the password it uses to login. Also, the one who set everything up doesn't work here.
We have only one snapshot of the VM, and that was after everything has been set up, which is some months old, so we can't revert back to it.
Can I use this this snapshot, and copy just the users from the old snapshot to the new one? I looked around in the SQL Server Manager, but there doesn't seem to be a users table.
Thanks in advance, brot