Change the domain setting for the MS SQL 2000 Server

Hallo,
During the installation I have to choose the proper service accounts. On a
form that appears, I can set the service setting to use local system account
or to use a domain user account.
I would like to use the domain user account to allow other apllication to
query the SQL server. But latter on I would like to change the domain.
Where to change the domain setting before put the the SQL srver machine in
another domain?
Thanks in advance
JamesTo add to Peter's response, you can also change the service account using
Enterprise Manager. This will assign the account the advanced user rights
needed.
Hope this helps.
Dan Guzman
SQL Server MVP
"James" <James@.discussions.microsoft.com> wrote in message
news:610285C2-4ABB-47B2-B554-9B5D6799B7A9@.microsoft.com...
> Hallo,
> During the installation I have to choose the proper service accounts. On a
> form that appears, I can set the service setting to use local system
account
> or to use a domain user account.
> I would like to use the domain user account to allow other apllication to
> query the SQL server. But latter on I would like to change the domain.
> Where to change the domain setting before put the the SQL srver machine in
> another domain?
> Thanks in advance
> James
>|||Thanks Dan,
The reason why I did not post that solution is that SQL
then needs to be stopped and started in order for SQL to
use the new userid.
Peter
Status quo, you know, that is Latin for "the mess we're
in."
Ronald Reagan

>--Original Message--
>To add to Peter's response, you can also change the
service account using
>Enterprise Manager. This will assign the account the
advanced user rights
>needed.
>--
>Hope this helps.
>Dan Guzman
>SQL Server MVP
>"James" <James@.discussions.microsoft.com> wrote in message
>news:610285C2-4ABB-47B2-B554-9B5D6799B7A9@.microsoft.com...
service accounts. On a[vbcol=seagreen]
local system[vbcol=seagreen]
>account
other apllication to[vbcol=seagreen]
change the domain.[vbcol=seagreen]
SQL srver machine in[vbcol=seagreen]
>
>.
>|||I believe the service also needs to be restarted when the account is changed
with SCM. The applet will let you change the account without restarting but
will not actually take affect until you do so.
Hope this helps.
Dan Guzman
SQL Server MVP
"Peter The Spate" <anonymous@.discussions.microsoft.com> wrote in message
news:15e801c48c3c$352db1d0$a301280a@.phx.gbl...[vbcol=seagreen]
> Thanks Dan,
> The reason why I did not post that solution is that SQL
> then needs to be stopped and started in order for SQL to
> use the new userid.
> Peter
> Status quo, you know, that is Latin for "the mess we're
> in."
> Ronald Reagan
>
> service account using
> advanced user rights
> service accounts. On a
> local system
> other apllication to
> change the domain.
> SQL srver machine in