Re: Change the domain setting for the MS SQL 2000 Server

From: Dan Guzman (guzmanda_at_nospam-online.sbcglobal.net)
Date: 08/27/04 

Date: Fri, 27 Aug 2004 08:16:35 -0500

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...
> 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
>

Relevant Pages

  • Re: 2005 Enterprise sp 2 install fails - 11009
    ... Q...Was your SQL Server service account a domain administrator account? ...
    (microsoft.public.sqlserver.setup)
  • Re: SQL windows account
    ... > Can the account to run SQL server belong to USER group or ... >>SQL Service account absoloutely does NOT have ... >>Jasper Smith (SQL Server MVP) ... >>> I happened to be a box and DB admin and i have a local ...
    (microsoft.public.sqlserver.security)
  • Re: Backup Issue! Interesting or weird - you decide!
    ... The service account is the account that the SQL Server service runs under. ... Dump is only available on version after SQL 6.5 for compatibility, ...
    (microsoft.public.sqlserver.programming)
  • Re: Backup Issue! Interesting or weird - you decide!
    ... The service account is the account that the SQL Server service runs under. ... Dump is only available on version after SQL 6.5 for compatibility, ...
    (microsoft.public.sqlserver.programming)
  • Re: Error 0x80070534 when changing service account
    ... When you removed the prefix, ... The account has granted Logon as Service right in the domain and in Domain ... The only difference I see is that the SQL Server where the account is ... service account using the Configuration Manager. ...
    (microsoft.public.sqlserver.security)