July 23, 2013 at 8:24 am
I literrally just took over a project from a contract that when he left he changed the sa password and the auth process for the SQL server. No one knows the sa password and its now only setup for SQL Auth instead of mixed mode. Is there a way to log into the SQL server adn fix everything? We have several sharepoint databases and other databases on this server that we need to get to and we're unable to do so.
[this is 1 of many things the contractor did on his last day that i'm trying to fix and get working again. 🙁 ]
July 23, 2013 at 1:56 pm
SQL_NuB (7/23/2013)
I literrally just took over a project from a contract that when he left he changed the sa password and the auth process for the SQL server. No one knows the sa password and its now only setup for SQL Auth instead of mixed mode. Is there a way to log into the SQL server adn fix everything? We have several sharepoint databases and other databases on this server that we need to get to and we're unable to do so.[this is 1 of many things the contractor did on his last day that i'm trying to fix and get working again. 🙁 ]
1. Sue his ***.
2. It's not only SQL Server Authentication. It's either Windows Authentication only or Mixed authentication (SQL Server AND Windows).
3. Try the steps described in this article: Connect to SQL Server When System Administrators Are Locked Out
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
July 23, 2013 at 9:27 pm
Before you try the above which does involve restarting the server and can be painful in a new environment when you aren't sure what applications are connecting and what credentials they are using...
Depending on the version you may be able to sneak in by making yourself a member of the local administrators group of the windows server. In earlier versions BUILTIN\Administrators was a default sysadmin, and may have been left that way. Even in later versions SQL versions are often upgraded without changing this.
Good Luck.
EDIT: Okay I'm in the SQL 2012 section so probably not by default, but the server may have been upgraded in place or the rights may have been transferred from a previous version.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply