Share via

Login /reset the SQL server/Database credentials

Nalini Bhavaraju 110 Reputation points
2026-01-20T13:48:41.18+00:00

Hi Team,

We have a SQL Server on Prem that collects the Machine data (Industrial/Manufacturing) on a daily basis. Unfortunately, we lost the credentials to login to the SQL server.

We only have the IP address, SQL server Name and Database Name.

We are not 100% sure on how the setup is done earlier Windows/SQL authentication.

How can we create a new id/password or reset the credentials or is there any other way we can get into the server/database to retrieve and send data to Azure Cloud.

As this is a production critical database/server, We are looking for some solution that does not effect the server/database.

Please help.

Thanks,

Nalini.

SQL Server | Other
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Jure Kranjc 5 Reputation points
    2026-01-20T19:21:25.9366667+00:00

    If you have access to the host machine, you can put the instance into single user mode and log in as "sa", but that would "effect the server/database".

    If you can't take it offline, my recommendation is to go to the app server and check the setting.json or app configuration files / settings if there is a login specified.

    If app is running under AD account or as a service, you can also open services and get the login name from there.

    If you have the password for the login, then its all good, otherwise you will have to commit to a short downtime to recover the "sa" account.

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.