9pm – Harman gets me on Lync. He’s running some SSIS Logins transfer wizard for one of the new TAKO SQL servers we’re preparing to migrate to tomorrow and he’s now lost SQL access!
Great! looks like the wizard has dropped the builtin\administrators and a bunch of other logins. what’s more he cant logon to the server to investigate. So, I help the poor guy out (after all he is working evenings at my request):
Its the old trick – start sql in single user mode, add yourself as sysadmin ……
Start the instance of SQL Server in single-user mode by using either the -m or -f options. Any member of the computer’s local Administrators group can then connect to the instance of SQL Server as a member of the sysadmin fixed server role.