SQL Server 2014 Management Studio Run as Administrator

• David Bird

  SSCarpal Tunnel

  Points: 4669

  More actions

  February 25, 2015 at 7:16 am

  #314966

  I installed SQL Server 2014 Standard edition with all the options on a Windows 2012 R2 server from a Command Prompt (Admin). I am part of the Local Admin group on the server. Whenever I try to start SQL Server 2014 Management Studio nothing happens unless I right click on it and select Run as Administrator.

  How do I setup SQL Server 2014 Management Studio to run just by clicking on its Icon?

  David Bird

• salnasi

  SSC Enthusiast

  Points: 109

  More actions

  February 27, 2015 at 10:17 am

  #1780689

  Try setting your User Account Control Settings to Never Notify.

• JeepHound

  SSCrazy

  Points: 2963

  More actions

  February 27, 2015 at 2:21 pm

  #1780795

  Right click the SSMS icon - properties - under compatability check the "Run this program as an administrator" box