Run SQL Server Setup with 'As Admin' option

Question

Hi,

For a user with local admin rights, is there any difference to run SQL setup As Admin vs runnig the setup without this option? I read somewhere in the past that we should never run the setup with 'As Admin' option, I am installing SQL with 'As Admin' option and never face any issue, do you know a case when this could generate an issue or this is just a myth ?

Best regards

Answer 1

The "run as admin" option ensures that the account you are logged in as has administrative rights which some installations require, even though you may be a local admin on the server at the same time. I have done many installations of sql server where I was only a local admin on the server and not used the "run as admin" option with no issues. Having said that, running the install with the "run as admin" option (even though not explicitly required) ensures that the install is being with the highest authority which can never be a bad thing.

Answer 2

 Hi S Rym,

>> do you know a case when this could generate an issue or this is just a myth ?

Administrator account is highly privileged, I installed SQL server setup file with the administrator option many times without no issue. Don’t worry about it. 

Best regards,
Cathy 

---

MSDN Community Support
Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to  MSDN Support, feel free to contact [e-mail]