CASorter
asked on
Is there a way to add an administrator level user via a dos command prompt?
i have a client whose system was apperently hacked. one of the things that was done was that the sa user in msde had their password changed. now our odbc connections that relied on sql authentication will not work. is there a way to add or change a administrator password and then delete and readd the sa without having the current sa password.
tia.
tia.
By default, if you log on to the server as a local or domain administrator, you can then log into the SQL Server in 'trusted' mode, and it will let you in.
ASKER
i dont have a sql enterprise interface... just msde
so how do i connect and know i connect via a command prompt?
once i "get in" can i create a new admin level user, delete the original sa and either create a new sa with a new password or just use the new admin user?
would a restore of a backup clear out users?
so how do i connect and know i connect via a command prompt?
once i "get in" can i create a new admin level user, delete the original sa and either create a new sa with a new password or just use the new admin user?
would a restore of a backup clear out users?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
But the database is hacked. Even when you can recover your sa-user will you ever be sure there are no other 'hidden' modifications that could be awkward: account numbers, prices, addresses,....
Backups can serve for that purpose.