Home / server / Questions / 629802
Accepted
Kieran Walsh
Asked: 2014-09-20 02:28:57 +0800 CST

Find out who installed SQL server - they forgot to add other logons

  • 772

We have a site where one of our team of techies installed SQL Server 2012. They forgot to add our administrators group as sysadmins so only they can access SQL - everyone else gets "Access Denied"

How can we find out who installed SQL, or who is a SQL Administrator so we can ask them to correct their fault?

I have domain admin rights to the server.

sql-server

1 Answers

  1. Best Answer

    Since you have admin rights to the server you can use the same procedure used to recover access when system administrators are locked out.

    MSDN: Connect to SQL Server When System Administrators Are Locked Out

    • 1