September 26, 2017 at 5:07 am
Hello,
I have installed an application that comes with SQL Server. The application connects to DB with no problems but i can login in the database using sa, or administrator user used to install the application/SQL.
Does anyone know a way to recover/change the password of the SA user?
Regards,
Arestas
September 26, 2017 at 5:31 am
Does anyone have a sysadmin account that still works? If so get them to change the password for you.
Otherwise if you have lost all sysadmin access, you will need to start the instance in single user mode (-m switch) which grants bultin\administrators sysadmin rights, then you can create a new sysadmin account and change the sa psssword.
https://docs.microsoft.com/en-us/sql/database-engine/configure-windows/connect-to-sql-server-when-system-administrators-are-locked-out
October 7, 2017 at 2:31 am
This was removed by the editor as SPAM
October 9, 2017 at 11:08 pm
Start the instance of SQL Server in single-user mode by using either the -m or -f options. Any member of the computer's local Administrators group can then connect to the instance of SQL Server as a member of the sysadmin fixed server role.
Please refer Microsoft link.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply