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

From: Peter The Spate (anonymous_at_discussions.microsoft.com)
Date: 08/27/04 

Date: Fri, 27 Aug 2004 06:46:09 -0700

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

  • sql service password in cluster changed by wrong method
    ... Then she changed it back to the domain user account using ... the Services applet. ... to be done within the SQL Enterprise Manager. ... Service Account through the SQL EM, tried to change the password and we get ...
    (microsoft.public.sqlserver.clustering)
  • Login failed for user sa.
    ... Changed the service account from local system ... to a Domain user account using Enterprise Manager. ... Everything worked fine and all databases are accessible. ... SBS2000 box running all service packs including SQL SP3 ...
    (microsoft.public.sqlserver.security)
  • RE: Domain or Local User Account for Laptop SQL 2008 Services
    ... I think I'd like to use a Domain User Account for the SQL 2008 services, but if I do this, will SQL Server function properly when I'm not connected to my network? ... SQL Server will try to connect to your domain controller for establishing authentication at startup if you configured your SQL Server service to a domain user account. ... Microsoft Online Community Support ...
    (microsoft.public.sqlserver.setup)
  • Re: Windows service
    ... One DB is SQL 2005 express and the other is SQL 2005. ... My question is I have created a domain user account and I am ... Yes, this should work, and in fact it is the recommended way to configure security for such a setup. ... You want to post some information about this is a recommended security feature. ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: SPN creation
    ... will i need to create an spn for the live sql server service account in order ... front end website to get Kerb delegation to the backend if your AD is 2003 ... form port-specific SPNs for HTTP, ...
    (microsoft.public.windows.server.active_directory)