Re: SQL Audit Failure after reinstall

Tech-Archive recommends: Fix windows errors by optimizing your registry

On Jun 8, 7:42 am, BeigeB...@xxxxxxxxx wrote:
On Jun 7, 11:56 am, Max <mdio...@xxxxxxxxx> wrote:





Hi,

I am setting up a new Server 2003 x64 box with SQL 2005 installed and
MOSS 2007 on a Server 2003 Std box.

I messed up on the configuration of MOSS (app pool permissions) the
first time through and had to reinstall. The reinstall went smoothly
and everything is working like a champ. Except I'm getting SQL audit
failures every 2 minutes filling my event logs on my x64 box. Right
now, I'm assuming they're comming from the old install.

Does anyone know what might be going on...or at least how to increase
the detail of the SQL auditing so I can determine what DB it's trying
to gain access to, etc. to help me determine what's going on?

------------------------------------------------
SQL Event Log Error

Date 6/7/2007 11:50:50 AM
Log SQL Server (Current - 6/7/2007 11:50:00 AM)

Source Logon

Message
Login failed for user 'ADVANTECHCNY\SHAREPOINT$'. [CLIENT:
192.168.254.11]

Date 6/7/2007 11:50:50 AM
Log SQL Server (Current - 6/7/2007 11:50:00 AM)

Source Logon

Message
Error: 18456, Severity: 14, State: 16.
---------------------------------------

I've checked the App Pools after the reinstall and none of them use
the Network Service account except for the Default App Pool and Office
Server App Pool.

Any help is greatly appreciated. Thanks.

Check the SharePoint Trace logs at C:\Program Files\Common Files
\Microsoft Shared\Web Server Extensions\12\LOGS\ (or similar). It's
probably the account used by Search...- Hide quoted text -

- Show quoted text -

Thanks for your reply. I can't believe I forgot about the MOSS
logs...see how often I need to play with this? :~) Turns out it was
the Microsoft Single Sign On service that was crushing the logs. Got
it all taken care of now.

Thanks for your help.

.

Relevant Pages

  • Re: Cannot open the /connectcomputer site
    ... "reinstall IIS". ... uninstall and reinstall IIS on SBS 2003. ... what errors are in the event logs on the server? ...
    (microsoft.public.windows.server.sbs)
  • Re: Reinstall DNS on an AD DC?
    ... event logs (DNS, SYSTEM and APP) for anything that might be helpful. ... For the zones that are hosted on this server, ensure that they are not set ... Check the event logs in general for anything that might indicate a problem ... > anyone guide me on how to reinstall the DNS server on this machine? ...
    (microsoft.public.windows.server.dns)
  • Re: Blown it up, Reinstalled IIS - buzzards are circling my body!
    ... Server about six months ago. ... CEICW will fail on the ... and ISA 04 books also (read and perused - not completely understood ... Unload IIS and reinstall IIS. ...
    (microsoft.public.windows.server.sbs)
  • RE: SBS 2003 Fax Service - Cant "Pause Printing" and ...
    ... How about Exchange Server? ... and all outbound fax will go out thru one fax modem. ... I suggest you reinstall the Fax component to see if it help. ... Services'' to uninstall it. ...
    (microsoft.public.windows.server.sbs)
  • Re: Help - Stalled Swing Migration
    ... I have cleared out the event logs and rebooted. ... Check the database connection and make sure the database is running. ... The DHCP Server has detected that it is running on a DC and has no credentials ... configuration settings you have specified when running the CEICW. ...
    (microsoft.public.windows.server.sbs)