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?
Best Answer
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.