Re: 'sa' user error

From: Toby Herring (therring*@*sark.com)
Date: 09/20/02 

From: "Toby Herring" <therring*@*sark.com>
Date: Fri, 20 Sep 2002 11:15:15 -0400

Sounds to me like you have an intranet server somewhere that has office
extensions installed, and is using that SQL server.

I'm not overly familiar with the Office extensions, but whoever manages the
intranet/web server should have an idea about where to change the connection
information that they're using to connect to the SQL Server.

You might also want to berate them about the fact that they shouldn't be
using the 'sa' account to access a database, anyway. 

--
Toby Herring
Software Architects, Inc.
MCDBA, MCSD
"Daryl" <dyauney@diversified-direct.com> wrote in message
news:3a1801c260ac$4c1d5f70$36ef2ecf@tkmsftngxa12...
> The source within the Event Viewer says "Office Web
> Server".  I am assuming that this would be refering to SQL
> Server, but I do not know enough about it to be sure.
>
> Thanks
> >-----Original Message-----
> >An application name might point in the right direction.
> >
> >Sounds to me like you have an application/service running
> on the machine
> >that is attempting to use the 'sa' account.  Someone
> probably changed the
> >'sa' password and didn't tell the application about it.
> >
> >--
> >Toby Herring
> >Software Architects, Inc.
> >MCDBA, MCSD
> >
> >
> >"Daryl" <dyauney@diversified-direct.com> wrote in message
> >news:2b4a01c25fe6$f5aba9a0$2ae2c90a@phx.gbl...
> >> Ever 5 minutes the Event Viewer is showing 2 entries of
> >> login failures for the user 'sa'.
> >>
> >> Error reads as follows:
> >> "ADO Error 80040E4D: Login failed for user 'sa'.."
> >>
> >> Any help is appreciated.
> >
> >
> >
> >.
> >

Relevant Pages

  • Re: Compromise?
    ... Yes, if you don't provide a password on your SA account, anybody able to run ... and connect now has complete control over your SQL Server. ... Server has. ...
    (microsoft.public.sqlserver.security)
  • Re: Windows Auth to SQL Server from ATL Web Service not working...
    ... account I'm logged on as. ... SQL on a different box from my web service in an Atl Server web ... impersonation token is not passed on to the SQL Server. ... Event Category: Account Logon ...
    (microsoft.public.vc.atl)
  • Re: Discussing 3 different strategies for deleting from multiple tables
    ... I will be using SQL Server but I am riding on top of a third party ... FYI, Account contains around 20K ... >>> This results in one parameterized query followed by two more trips to ...
    (microsoft.public.data.ado)
  • RE: connection problems in secondary site and SQL server
    ... Do you have a Windows 2003 server anywhere in your environment? ... i can't add this account to this group. ... SMS Management Point encountered an error when connecting to its Database ... SMS on SQL Server My_Primary_SMS_Server. ...
    (microsoft.public.sms.admin)
  • RE: MP Install issue
    ... Will setting the SPN on the domain account fix the communication issue ... >> MPDB ERROR - CONNECTION PARAMETERS ... >> with a trusted SQL Server connection. ...
    (microsoft.public.sms.setup)