Does any one know how to reset sa Account?

I'm a programm designer, when using SQL Express Server,
one of my codesigner accidently changed the name of sysadmin account "sa" into somthing else, even disabled the login of this account.

since that's the only one account we can login, the database is now closed to any further operation above basic level.

looking for any possiable means to regain the control of database.

like how to reset "sa" account or reset the "master" database.

we sure make a "security database now" *_*

find a way to reset database using database under "Template Data" folder. this is however not suggested, while lost all the data.

I am still looking for a way to re establish the "sa" account

|||

The database should still support Windows Authentication. Login locally as an Administrator and connect to the database using Windows Authentication. Then reset the sa password.

If you properly secured the database BUILTIN\Administrators has been removed from server admins and this will not work. Additionally, you should not be logging in as sa to begin with. Create other accounts with the appropriate permissions and use them.

|||

well thanks for your advice, it works this time.

however I tried this way before, it did not work, because even permissions for windows authentication to create higher level security account were suspended. with BUILTIN\Administrators still in exist. but it works now.

thanks again.