Forgot the SA password in Sql Server 2005

In general if you forgot SA password or if the SA account is disabled these are the options to login into SQL Server 2005 and reset or enable SA. If Builtin\Administrator is present in SQL Server, you can login with an ID which is member of Administrators group and reset the SA password. Or else if you have some other ID which is having sysadmin privilege in SQL level, you can login with that and reset SA. But in case if you have the following scenario where, You have disabled SA (or) forgotten SA password You followed the best security practice and removed Builtin\administrator from SQL Server So you cannot login with a sysadmin ID into SQL Server, and you start thinking about uninstalling SQL Server 2005. No need to perform any uninstall and reinstall in such scenarios in SQL Server 2005 as you have this option where the Members of Windows Administrative groups have sysadmin privilege in SQL Server if you start SQL Server 2005 in Single user mode. Read more here: Forgot the SA password in Sql Server 2005 Backup copy here: Forgot the SA password in Sql Server 2005

• About post