MSDE Service Accounts

Hi Guys,
Is there a way to specify the accounts under which the MSSQL and Agent
services will run during installation? I did not see an option in the switch
commands in the setup.exe.
Also, changing those accounts without EM seems to be pretty involved. Is
there any other way to change those accounts? I need to be able to change
these accounts for replication.
Thanks,
Maer
Hi,
How to change the startup account:-
1. Control Panel - Admin tools -- Services
2. Double click above the MSSQL Server service
3. In the Log on tab, change the OS user name and enter the password, Click
ok and restart the service.
Note:
Do the same for SQL Agent service.
Thanks
Hari
MCDBA
"Maer" <maer@.auditleverage.com> wrote in message
news:eYIePa$dEHA.3792@.TK2MSFTNGP09.phx.gbl...
> Hi Guys,
> Is there a way to specify the accounts under which the MSSQL and Agent
> services will run during installation? I did not see an option in the
switch
> commands in the setup.exe.
> Also, changing those accounts without EM seems to be pretty involved.
Is
> there any other way to change those accounts? I need to be able to change
> these accounts for replication.
> Thanks,
> Maer
>
|||you need to use an iss file. Check out
Setup Initialization File Details and Advanced Installation Options for more
info on how to do this.
Hilary Cotter
Looking for a book on SQL Server replication?
http://www.nwsu.com/0974973602.html
"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:uw%230XxFeEHA.2812@.tk2msftngp13.phx.gbl...
> Hi,
> How to change the startup account:-
> 1. Control Panel - Admin tools -- Services
> 2. Double click above the MSSQL Server service
> 3. In the Log on tab, change the OS user name and enter the password,
Click[vbcol=seagreen]
> ok and restart the service.
> Note:
> Do the same for SQL Agent service.
> Thanks
> Hari
> MCDBA
>
> "Maer" <maer@.auditleverage.com> wrote in message
> news:eYIePa$dEHA.3792@.TK2MSFTNGP09.phx.gbl...
Agent[vbcol=seagreen]
> switch
involved.[vbcol=seagreen]
> Is
change
>
|||Thank you. But isn't this just part of the changes? Don't I also have to
set the right permissions in certain folders and registry keys for the
account I am changing the service to?
I was wondering if there was a utility that would do all that
automatically.
Thanks again,
Maer
"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:uw%230XxFeEHA.2812@.tk2msftngp13.phx.gbl...
> Hi,
> How to change the startup account:-
> 1. Control Panel - Admin tools -- Services
> 2. Double click above the MSSQL Server service
> 3. In the Log on tab, change the OS user name and enter the password,
Click[vbcol=seagreen]
> ok and restart the service.
> Note:
> Do the same for SQL Agent service.
> Thanks
> Hari
> MCDBA
>
> "Maer" <maer@.auditleverage.com> wrote in message
> news:eYIePa$dEHA.3792@.TK2MSFTNGP09.phx.gbl...
Agent[vbcol=seagreen]
> switch
involved.[vbcol=seagreen]
> Is
change
>
sql