Re: Changing Start-up and Agent Accounts

From: Jasper Smith (jasper_smith9_at_hotmail.com)
Date: 03/08/04 

Date: Mon, 8 Mar 2004 19:16:30 -0000

You should make the change using Enterprise Manager, this will ensure the
correct rights and NTFS/registry permissions are granted to the domain
account you use. 

-- 
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Peter" <anonymous@discussions.microsoft.com> wrote in message
news:62bb01c4052d$192dddc0$a601280a@phx.gbl...
> Thanks Hari,
>
> However will I kill the database if I change it through
> EA ?.
>
> Thanks
> Peter
>
>
> >-----Original Message-----
> >Hi,
> >
> >Create a new domain account and give necessory previlages
> to the SQL server
> >machine. After that you can use that
> >account as the Service start up account for SQL server as
> well as SQL agent
> >service,
> >
> >Have a look into the below link
> >
> >http://support.microsoft.com/default.aspx?scid=kb;en-
> us;Q283811
> >
> >Thanks
> >Hari
> >MCDBA
> >
> >"Peter" <anonymous@discussions.microsoft.com> wrote in
> message
> >news:8f8001c40521$fe622100$a401280a@phx.gbl...
> >> Dear All,
> >> When our server was set up, it was set up with local
> >> rather than domain accounts.
> >>
> >> There has been a recent requirement to send emails from
> >> our server, which need Domain, rather than local
> accounts.
> >>
> >> Question.
> >> Can I repoint the SQL Server "Start and run SQL in the
> >> following Account", and "SQL Server Agent Startup
> Account"
> >> to two new domain accounts with administration rights on
> >> our server. Will this work or will it kill SQL ?
> >>
> >> Thanks
> >> Peter
> >>
> >>
> >
> >
> >.
> >

Relevant Pages

  • Re: Error 15401 using sp_grantlogin (not addressed by current KB articles)
    ... Restarting Windows 2000 resolved the problem for this particular account, ... confused when it sees a duplicate SID. ... > One way to get SQL Server to agree with the renamed NT ... > Preview (to ensure the script was created), ...
    (microsoft.public.sqlserver.security)
  • Re: SharePoint V3 Install Error
    ... But it our case it had to do with Group Policies that forbid the account of ... WSS FAQ:www.wssv3faq.com/wss.collutions.com ... Event Source: WindowsSharePointServices3Search ... whatever you are installing WSS as sufficient rights to the SQL Server ...
    (microsoft.public.sharepoint.windowsservices)
  • RE: Problems with WebParts
    ... to a database called aspnetdb. ... > The connection string specifies a local SQL Server Express instance using a ... > server account must have read and write access to the applications directory. ... > This is necessary because the web server account will automatically create ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Cannot connect to Query Analyzer
    ... For Query Analyzer, I tried replacing the file as you suggested but had the ... same results (Enterprise Manager starts up fine, ... I created an account on my laptop and changed SQL ... Try replacing the MMC app for SQL Server from the original ...
    (microsoft.public.sqlserver.connect)
  • Problems with WebParts
    ... The connection string specifies a local SQL Server Express instance using a ... database location within the applications App_Data directory. ... server account must have read and write access to the applications directory. ... logged-in user needs the dbcreator privilege in the appropriate SQL Server ...
    (microsoft.public.dotnet.framework.aspnet)