Change from LocalSystem to Account

From: Wm. Scott Miller (millersc_at_mailspamkiller.wvnet.edu)
Date: 06/17/03 

Date: Tue, 17 Jun 2003 12:46:44 -0400

Our SQL server was installed by someone else and they decided to install it
to use the system account. I'd like to make it use a user account with less
priviledges than system. Is there a walkthrough on how to go from system to
a user account and all the rights that the user acount must have to actually
still work properly? This is on our production server so down time must be
kept to a minimum.

Thanks,
Scott 

-- 
Remove the words spam and killer from the e-mail to reply.

Relevant Pages

  • Re: sa password was inadvertently changed. With a kicker...
    ... Use some other account that the client has (any domain admin should have ... Did around there install package, and see if the sql script that changed ... Put the database files back where they should ... > I have a SQL Server 7 Standard edition server running in a ...
    (microsoft.public.sqlserver.security)
  • Re: SQL Sever 2008 RC0 fail to install almost all services
    ... Now I removed the account from local Administrators group. ... The SQL Server Log File reports an error 15209, ... Note that I use a specific account named SQLServerServices to install ... This is an informational message only. ...
    (microsoft.public.sqlserver.setup)
  • Re: Compromise?
    ... >made the patches available and advised customers to ... >install it. ... >>Server was installed and if your SQL Server is running ... >>administrator account, you just gave anybody who has a ...
    (microsoft.public.sqlserver.security)
  • Re: Get "credentials not valid" message installing SQL2008 Failver
    ... The user account (domain account) has to be pre-created. ... The network name gets created during the install process. ... Microsoft SQL Server MVP ...
    (microsoft.public.sqlserver.setup)
  • Re: SQL Server 2008 set up
    ... work on this Account so I would like to use that. ... "SQL Server System Administrators" list during SQL Server 2008 Setup. ... The install completed successfully. ... Microsoft Online Community Support ...
    (microsoft.public.sqlserver.setup)