Re: SQL server disable in active directory

From: AnthonyThomas (Anthony.Thomas_at_CommerceBank.com)
Date: 11/30/04 

Date: Tue, 30 Nov 2004 08:09:24 -0600

Did you switch the SQL Server service accounts from Local System to Local or Domain User accounts or was there a switch in the service account names?

AD registration requires SPNs for the Computer and for the Service Accounts, per listening IP.

Sincerely,


Anthony Thomas


--
 
  "SirWolF" <SirWolF@discussions.microsoft.com> wrote in message news:9B3026B3-0F29-46D5-9BB2-4D3B49FF5BB8@microsoft.com...
  Out of nowhere, the sql server has been disable in active directory. Nobody
  touched it. Im running SQL 2000 enterprise on a 2003 server. The domain
  controler are on 2003 standard. Is there any reason that a SQL server can be
  disable by itself like that ?

Relevant Pages

  • Re: SQL 2000 Problems on One Node Only
    ... Since both the Cluster and SQL Server service accounts are Local ... how is SQL Server set up to allow Local Administrators to log into SQL ...
    (microsoft.public.sqlserver.clustering)
  • Re: 18456 Login failed for user NT AUTHORITYSYSTEM
    ... No, not using fulltext Searching. ... problem and had ruled it out but had not though about tracing the account. ... > system and is unable to connect to SQL server. ... > SQLSERVERAGENT - but I'm sure it's not running under local system.) ...
    (microsoft.public.sqlserver.server)
  • Re: How to change service accounts on a cluster
    ... SQL Server Configuration Manager I always get the same error: ... to use SQL Configuration Manager to change the service accounts. ... click "OK" it says - specified network password is incorrect. ...
    (microsoft.public.sqlserver.clustering)
  • Re: Debugging Windows Service
    ... I am writing a Windows Service that works with SQL Server. ... I want to be able to debug it, ... it looks as if Local System does not have access to SQL Server, ...
    (microsoft.public.dotnet.general)
  • SQL Server Setup could not validate the service accounts
    ... Microsoft SQL Server 2005 Setup ... SQL Server Setup could not validate the service accounts. ... or the specified username or password is incorrect. ... service, specify a valid username, password, and domain, or specify a ...
    (microsoft.public.sqlserver.setup)