access to SQL server

[Former Member]

Hi,

We have to access to SQL server 2012 but unfortunately we can't access with any of the users/passwords we have.

Do you know if it's possible to reset the SA password without having to access to the DB? Or some emergency steps we can follow in case we don't have any ohter users?

Thanks a lot, Sapera

[yakcinar · Accepted solution]

Hello Sapera,

You can try these.

Connect to SQL Server When System Administrators Are Locked Out

4 Ways to Reset SA Password in Sql Server - wikiHow

Regards,

Yuksel AKCINAR

[Former Member]

please check using which user it was installed. you can connect using that user.

if it installed with administrator you can connect with windows authentication.

[former_member184473]

Hello Sapera,

Do you know the password of OS users <sid>adm or builtin administrator?
Those users are part of group Administrators and can connect to the database instance.

Regards,

Eduardo Rezende

SAP Support