Re: User rights when installing MSDE 2000A

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Andrea Montanari (andrea.sqlDMO_at_virgilio.it)
Date: 07/26/04 

Date: Mon, 26 Jul 2004 16:48:34 +0200

hi Carolina,
"Carolina" <anonymous@discussions.microsoft.com> ha scritto nel messaggio
news:3ed201c472f8$7aa36140$a601280a@phx.gbl...
> Hello,
>
> Is it possible to install MSDE 2000A with local admin
> rights and then run it with poweruser rights? Or do I
> have to have local admin rights when I run it as well?
> Now I have tried to install it with an account that have
> local admin rights and after that I tried to run it with
> another account that has poweruser rights on the same
> computer.

I always install MSDE using admin privileges, but what's important is to set
the SQL Server service's account to a Windows acclunt with enought
privileges for it's needs..
usually the setup set it to LocalSystem, which has admin privileges
by the way, it does not matter the account you are logged in, as MSDE runs
in it's separate permission account.. 

-- 
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtm        http://italy.mvps.org
DbaMgr2k ver 0.8.0  -  DbaMgr ver 0.54.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
--------- remove DMO to reply

Relevant Pages

  • RE: Correct setup of XP-Pro computer on Win2K Domain
    ... Setting up a local account on the xp machine does not result in local admin ... rights for that user, you need to put them in the local admin group. ... > inconsistent problems with security when I setup a new XP-Pro workstation. ...
    (microsoft.public.windowsxp.setup_deployment)
  • Re: Automatically making AD users local administrators on computers in SBS 2003
    ... best" when assigning user rights. ... provide the client this account and password. ... can use this special local administrator account. ... > This will automatically give each user that logs in local Admin rights. ...
    (microsoft.public.windows.server.sbs)
  • Re: Exmerge on DC?
    ... I have a service account with rights to the ... the account is an Exchange full admin and I've given the ... Use a member machine and make yourself local admin. ...
    (microsoft.public.exchange.admin)
  • RE: ADMT error when migrating computers
    ... The problem can occur if the account being used did not have administrator ... -- Created a new account on the 2003 side and gave the account local admin, ... domain admin and enterprise admin rights. ... machine we are migrating. ...
    (microsoft.public.windows.server.migration)
  • Re: Prevent changes to Administrator password
    ... What I am trying to do is give Taz1972 some options to minimize the risk or make it harder for a lower-level DA to reset the password for the EA account. ... * This posting is provided "AS IS" with no warranties and confers no rights! ... > By adding the Deny Write Permissions ACE, ... > permission to modify the ACL on AdminSDHolder. ...
    (microsoft.public.windows.server.active_directory)