Hello experts. I'm tasked with upgrading several 2008 instances. But some of them I cannot access. The sa password is not known and my account doesn't exist in the instance. I AM in the local admin Windows group.
The techniques I have found require stopping the instance and running it in single-user mode. But I can't risk an outage in these production instances.
Does anyone know of a better method that will allow the instance to be up?
Thanks for any tips.
Do you know if they are using Windows Auth with AD Groups. Maybe you can get yourself into one of those AD groups that will allow you access to the servers. There is no hack like you are looking for, that would be a huge security issue if there was.
But local admins are not automatically granted access to SQL Server. The question is whether or not there is an AD group setup for SQL Server sysadmins that was added to SQL Server on those instances? Maybe a group defined for the DBA team?
It doesn't matter whether or not the group is in local admins - what matters is what groups were added to SQL Server and what permissions they were granted. Is it possible that there is another group that you are not a member of now - that was added to this instance with sysadmin rights?
A last resort would be to identify who managed the system before - reactivate (if not active now) - their domain account and login to the server with that account. Then you could use SSMS to access SQL Server and grant your account the necessary privileges.