Click here to Skip to main content
15,917,060 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
We are facing a challenge in login to Sql Management studio, as a System-Owner has left the organisation and we are unable to login to SQL using Windows authentication, along with we do not have any login credentials to login in the SQL server in Mix-Mode and create the NEW SQL user. It will be a great help if we can do workaround for this issue..

Checked all where to find the solution to this issue.. Please help

Thanks is advance..

What I have tried:

Tried all the possible ways, either tried to get the Master DB mdf/ldf attachement, but not possible..
Posted
Updated 31-Aug-18 5:12am
Comments
berrymaria 31-Aug-18 5:51am    
Maybe you can ask the System-Owner what's the credentials then..
Goutam Babu 31-Aug-18 5:57am    
Any other possible ways to create new user or need to Uninstall then install again.. Please suggest.
Herman<T>.Instance 31-Aug-18 7:30am    
Sue the system owner for neglect!

Several solutions posted in this StackOverflow thread:
sql - Recover sa password - Stack Overflow[^]

The usual approach is to restart SQL Server in single user mode, connect as a member of the local Administrators group, and change the security as required:
Disaster Recovery: What to do when the SA account password is lost in SQL Server 2005 – Raul Garcia's blog[^]
 
Share this answer
 
The entire point of having secure logins is that you can't get around them. This is a feature.

We had an issue where we managed to lock the sa account. We had to log in as the server admin and use windows authentication. Maybe that could work?
 
Share this answer
 
Comments
KumarRishab 31-Aug-18 7:34am    
But in the problem statement, he has already mentioned "Windows Authentication - already not working as owner left the organisation. that means SQL server is installed in the desktop machine and SQL needs to reinstalled by taking the backups..
Richard Deeming 31-Aug-18 11:13am    
A local administrator on the server can get around them by restarting SQL in single-user mode. :)

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900