Skip to main content
Server Fault

Return to Question

Fixed grammar
Source Link
edit approved Jan 9, 2013 at 3:36
ctype.h
edit approved Jan 9, 2013 at 3:36
ctype.h
  • 205
  • 1
  • 3
  • 11

iI am currently facing the problem that someone working here changed the password of the "sa"sa user of the Microsoft SQL Server 2005. The SQL-Server is running on a VM, and the applicatonapplication we run wontwon't let me change the password it uses to login. Also, the one who set everything up doesntdoesn'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 cantcan't revert back to it.

Can iI use this this Snapshotsnapshot, and copy just the users from the old snapshot to the new one? I looked arroundaround in the SQL Server Manager, but there doesntdoesn't seem to be a users table.

Thanks in advance, brot

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 applicaton we run wont let me change the password it uses to login. Also, the one who set everything up doesnt 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 cant 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 arround in the SQL Server Manager, but there doesnt seem to be a users table.

Thanks in advance, brot

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

Source Link
brot
brot
  • 111
  • 5

Copy the Users from one MS-SQL server to another

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 applicaton we run wont let me change the password it uses to login. Also, the one who set everything up doesnt 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 cant 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 arround in the SQL Server Manager, but there doesnt seem to be a users table.

Thanks in advance, brot