3

Is there a way to install SQL Server Express without administration right?

Is there a portable version?

(I need to test SQL Server on my computer before using the server but I don't have administration right. so I cannot install it. I search a way to bypassed my problem)

0

1 Answer 1

7

Unfortunately, no. You are installing a program and making service and registry changes, etc. You need to run setup as an account that has local administrative rights. No workaround to this that wouldn't involve some back door into administrative rights.

Best bet is to ask for someone to temporarily give you the rights or install it for you.

Source: The Microsoft SQL Server books online article for how to install SQL Server 2008 R2Express

2
  • 2
    In 2018, the recommended way to solve this would be to install inside a virtual machine. Commented Jun 15, 2018 at 22:11
  • 2
    If in 2018 they give you administrative rights over your VM or the ability to create your own VM. Actually in 2018, the way to do it would be to go into AWS or Azure and spin up your own VM and try it yourself and deallocate the VM the next day, and you'll spend the same price as a double mocha something no fat with whip at one of them coffee shops.
    – Mike Walsh
    Commented Jun 15, 2018 at 22:29

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.