Login failed for user 'sa'.

From: Gordzilla (gordzilla2000_at_hotmail.com)
Date: 08/21/04 

Date: Sat, 21 Aug 2004 00:12:23 -0400

SQL was running along fine. Changed the service account from local system
to a Domain user account using Enterprise Manager.
Everything worked fine and all databases are accessible. However, my event
log is filling up with the following every 6 seconds:

Event Type: Information
Event Source: MSSQLSERVER
Event Category: (4)
Event ID: 17055
Date: 8/20/2004
Time: 10:47:47 PM
User: N/A
Computer: XXXX
Description:
18456 :
Login failed for user 'sa'.

Any ideas?
SBS2000 box running all service packs including SQL SP3

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)
  • Re: Change the domain setting for the MS SQL 2000 Server
    ... The reason why I did not post that solution is that SQL ... service account using ... I can set the service setting to use ... >> or to use a domain user account. ...
    (microsoft.public.sqlserver.server)
  • Re: WSS3 SQL2005 - move databases
    ... server, it's not immediately obvious where we change this setting inside WSS ... Definately backup your databases and make sure you have the latest ... Also make sure the service account has full access "db owner" to the ... SQL Databases, and SQL Services. ...
    (microsoft.public.sharepoint.windowsservices)
  • 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: 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)