I want to know if sql server (express) need to have always admin right on a computer.

I ask my company to have a version on my pc, but I need a tech to install it because I dont have admin right.

I'm afraid that I will not be able to use it after the installation.

I will need of course to manage it

and connect local

and connect remote lan

did you think my right will cause problem

(I know taht I can talk to a mysql db on my computer by lan)

I found this http://www.symantec.com/connect/articles/install-and-configure-sql-server-2008-express and its said that I will need to enable TCP/IP, is it that I can do it? did I need it on lan?

1 Answer 1


The account which runs the SQL Server instance doesn't need admin rights on the computer and neither does the account which will manage the SQL Server instance. If you plan on creating databases within the instance you'll need to make sure that you have sysadmin rights within the instance but this isn't related to the OS rights at all. The person doing the install will need to make sure that they give you the rights within the database instance that you need before they leave.

The person doing the install that has admin rights will need to enable TCP/IP on the instance as that does require admin rights to do.

  • what do you mean by database instance, just like adding an db administrator user with all right?
    – forX
    Oct 26, 2011 at 16:47
  • When you install SQL Server you install an instance of the database engine. Within the instance you create databases. Within the databases you create tables which hold data. To do everything possible you need to be an admin within the database instance.
    – mrdenny
    Oct 26, 2011 at 17:18
  • yeah, but there probably user like root with all privileges (full admin)? If I get that, I will not need any more os admin right?
    – forX
    Oct 26, 2011 at 17:51
  • Yes there is the "sa" account which has full rights. It doesn't matter if you use the "sa" account or if your Windows account has full rights into the SQL Server. In either case you don't need more rights in Windows.
    – mrdenny
    Oct 26, 2011 at 18:26
  • So .... when my tech will come, He will install sql server, add a sa user and give the user/pass. After he need to enable TCP/IP and I will be good to use my db the way I want. thats right? new question: did I need to check witch port tcp use?
    – forX
    Oct 26, 2011 at 19:37

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.