I'm running Microsoft SQL Server 2014 on Windows Server 2012. I would like to grant all local administrators (the box is not on a domain) sysadmin rights to SQL Server, but am having difficulty.

I can create a login and assign BUILTIN\Administrators, but it does not actually allow administrator users to connect. It only works if I assign specific users as ServerName\UserName.

  • Perhaps it's UAC. Can the users connect locally if they use "Run as Administrator"? – Dan Guzman Jul 30 '16 at 20:13
  • Look at these answers here and see if this will help you any: serverfault.com/questions/338222/… – Pimp Juice IT Jul 30 '16 at 23:00
  • I agree with @DanGuzman as the local admins connecting will need the authorization token which requires choosing run as admin even if you have "turned uac off" as that only disabled the prompt and doesn't actually turn it off. – Sean Gallardy Jul 30 '16 at 23:54
  • Is it in a clustered or stand-alone environment? It does matter. – CoveGeek Aug 1 '16 at 16:55
  • You guys are great. Ran as administrator and it worked. Thanks! – atjoedonahue Aug 1 '16 at 19:14

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.