As most systems administrators know, you should log into your computer as a normal domain user who does not have elevated privileges in your Active Directory domain and only run administrative programs with elevated privileges when necessary. You could hold down shift, right click the shortcut, and select “Run as different user” to run a program as a user who has elevated privileges in your Active Directory domain, but there’s an easier, more efficient way to run programs that always require elevated privileges.
Either create a new shortcut or modify an existing shortcut to a program that you need to run with elevated privileges. In this example, I will be using a shortcut to an MMC console so that any snap-in I add to the MMC console will be run with elevated privileges.
Change the target to the following, modifying the username to a user in your domain with elevated privileges and the domain to match your domain name:
C:\Windows\System32\runas.exe /user:firstname.lastname@example.org /env "C:\Windows\System32\mmc.exe"
Change the target on the “SQL Server Management Studio” console to:
C:\Windows\System32\runas.exe /user:email@example.com /env "C:\Program Files (x86)\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE\Ssms.exe"
Creating administrative shortcuts to programs you frequently use that require elevated privileges is easier and more efficient than always having to do a “Run as different user” and it also helps to keep your network more secure by not being tempted to log into your computer as a user with elevated privileges in your Active Directory domain.