James Avery
Just another GEEK expressing his thoughts
RSS
  • Home
  • Resume
  • Blog
    • Microsoft Azure
      • Microsoft Intune
    • Access and Information Protection (AIP)
    • SC Configuration Manager 2012
      • Configuration Manager 2007
    • Windows Server-2012
    • Desktop Virtualization
    • Remote Desktop Services
  • e-Books
  • Contact

SQL Server reporting Failure Audit in Application Log 

javery February 20, 2013 Configuration Manager 2007

While I was out doing an installation at a customer I noticed I started having problems with the SQL server’s Windows Application Log. Below you will find the error and the solution on how to resolve this. This took me 3 days and a call to Microsoft to resolve this problem since I couldn’t really find any information online discussing on how to resolve this issue. I feel it’s not a common problem, but no less another problem I had to work through.

 
 

ERROR from the Windows Application log on the SQL server:

Event Type:        Failure Audit

Event Source:        MSSQLSERVER

Event Category:        (4)

Event ID:        18456

Date:                1/21/2009

Time:                5:11:36 PM

User:                FS\FS-SCCM$

Computer:        FS-SQL1

Description:

Login failed for user ‘FS\FS-SCCM$’. [CLIENT: 10.1.255.163]

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

Data:

0000: 18 48 00 00 0e 00 00 00 .H……

0008: 08 00 00 00 46 00 53 00 ….F.S.

0010: 2d 00 53 00 51 00 4c 00 begin_of_the_skype_highlighting 

00 53 00 51 00 4c 00 FREE  end_of_the_skype_highlighting -.S.Q.L.

0018: 31 00 00 00 07 00 00 00 1…….

0020: 6d 00 61 00 73 00 74 00 m.a.s.t.

0028: 65 00 72 00 00 00 e.r…

 
 

Conduct a System Center Configuration Manager Site Repair by doing the following:

  • Click on Start
  • Click on Microsoft System Center
  • Click on Configuration Manager 2007
  • Click on ConfigMgr Setup
  • The Wizard will pop up
    • Click Next
    • Click Perform site maintenance or reset this Site
    • Click Next
    • Check all 3 options
      • Re-Apply default file and registry permissions on this site server
      • Modify SQL Server Configuration
      • Modify SMS Provider configuration
    • Click Next
    • Confirm the information and Click Next
    • Confirm the information and Click Next
    • A popup will appear asking if you would like to reinstall the provider and click YES
  • This will then automatically go into the actions. When completed, close and restart the server.
Warning: Could not create file e:\Program Files (x86)\Microsoft Configuration Manager\inboxes\WSUSMgr.box\100.SHA, Error=3.  Software Updates released, When? 

Related Posts

Configuration Manager 2007

Have OS deployment ask for a Computer Name 

I found this on TechNet and had to work through it to make it work. I’ve added pics and better explanations on how to add and deploy the script to work for you. I found the scripts at this URL in TechNet. http://social.technet.microsoft.com/forums/en-US/configmgrosd/thread/5924e840-eb6e-48c1-858f-766a5be625a6/     This script will detect if the current assigned value for […]

Configuration Manager 2007

Software Updates Says Unknown 

Ok, what does this mean, how do I figure out where the problem is? Man, what a pain!     Below is an example (PIC 1) of what I’m talking about with the “Unknown”. These “Unknown” machines mean they didn’t send in the Software Update scan on the workstation to the WSUS system. Now, which […]

Configuration Manager 2007

Software Updates released, When? 

Pretty much everyone knows when Microsoft releases their software updates every second Tuesday each month. But did you know it’s actually after 10am Pacific Time. Yes, I said Pacific Time. For you peeps that don’t know how to calculate that…that would be 11am Mountain Time, 12 Central Time, 1pm Eastern Time. Now Hawaii, well…now you […]

Blog Categories

  • Access and Information Protection (AIP)
  • Desktop Virtualization
  • MDOP
  • Application Virtualization
  • Microsoft Azure
  • Remote Desktop Services
  • James Avery Resume
  • Tools
  • References
  • Exchange 2007
  • Windows-8-Desktop
  • Configuration Manager 2007
  • Microsoft Intune
  • SC Configuration Manager 2012
  • SMS 2003
  • Windows Server-2008
  • Windows Server-2012

Search

Tags

Cherished Moments Dreams family Friends Hobby Photography Romance Travel

Recent Posts

  • Scaling a standard Azure website to 380k queries per minute of 163M records with loader.ioScaling a standard Azure website to 380k queries per minute of 163M records with loader.io
    July 3, 2014
  • How to publish URL shortcuts to Windows 8.1
    July 3, 2014
  • Microsoft Virtual Machine Converter 2.0
    June 24, 2014

Social Media

© James Avery 2022
Powered by WordPress • Themify WordPress Themes