Re: Changing Start-up and Agent Accounts
From: Peter (anonymous_at_discussions.microsoft.com)
Date: 03/09/04
- Next message: Gary: "Sql Performance with Bindview Audit Tools."
- Previous message: oj: "Re: BULK INSERT (X)"
- In reply to: Jasper Smith: "Re: Changing Start-up and Agent Accounts"
- Next in thread: Gayathri Rau: "RE: Changing Start-up and Agent Accounts"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 9 Mar 2004 00:59:42 -0800
Thanks Jasper
>-----Original Message-----
>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
>> >>
>> >>
>> >
>> >
>> >.
>> >
>
>
>.
>
- Next message: Gary: "Sql Performance with Bindview Audit Tools."
- Previous message: oj: "Re: BULK INSERT (X)"
- In reply to: Jasper Smith: "Re: Changing Start-up and Agent Accounts"
- Next in thread: Gayathri Rau: "RE: Changing Start-up and Agent Accounts"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
