Welcome to dbFreaks.com!
FAQFAQ      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

Security Event log error message for audit failures

 
   Database Help (Home) -> Server RSS
Next:  Assigning Variables During IF Statement - Can it ..  
Author Message
kunalap

External


Since: Aug 05, 2008
Posts: 5



(Msg. 1) Posted: Thu Dec 04, 2008 3:07 am
Post subject: Security Event log error message for audit failures
Archived from groups: microsoft>public>sqlserver>server (more info?)

Hello,
We have a small problem with SQL 2005 on Windows 2003 SP1 - well not exactly
a problem because all is working fine.
We have our security event log filling up with audit failure messages from
time to time.

Mydomain\ktest is my login with which I logins.
Mydomain\sqlserviceaccount is login used to start SQL services.
NT AUTHORITY\SYSTEM is already added as 'sysadmin' in SQL 2005.
Server8740 is the server in queston.

The messages are as follows:

Privileged Service Called:
Server: Security
Service: -
Primary User Name: ktest
Primary Domain: Mydomain
Primary Logon ID: (0x0,0x1330122D)
Client User Name: -
Client Domain: -
Client Logon ID: -
Privileges: SeTcbPrivilege

and

Logon Failure:
Reason: Account currently disabled
User Name:
Domain:
Logon Type: 3
Logon Process: Authz
Authentication Package: Kerberos
Workstation Name: Server8740
Caller User Name: sqlserviceaccount
Caller Domain: Mydomain
Caller Logon ID: (0x0,0x1302E)
Caller Process ID: 1164
Transited Services: -
Source Network Address: -
Source Port: -

I've already checked all permissions under local security policies and given
gave SQL service account Admin rights on Windows level, but still the same
problem.

Can someone shine some light on this?

Thanks.
Kunal.

 >> Stay informed about: Security Event log error message for audit failures 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
Event 18456 - Failure Audit in event viewer - SLQ2005 - We currently use BrightStor/Arcserve as our backup software which includes the option to use either their own database product or use Microsoft's SQL server. In September 2007 I decided to switch and place the database on the SQL 2005 server. ..

Failure Audit - Event ID: 18456 - Hi I'm using SQL Server 2005 and , I keep getting the following message in the Event Viewer: Event Type: Failure Audit Event Source: MSSQLSERVER Event Category: (4) Event ID: 18456 Date: 1/21/200...

DDL LOGON - event to Audit Logins - We have SqlServer 2005 with a bunch of databases. To audit logins, I created DDL trigger on LOGON event to capture the EVENTDATA from a successful login and INSERT into a table (say, Tbl_AuditLogins) in one of the databases in the same Instance. Plain...

xp_cmdshell failures - We recently migrated to SQL 2005, and we are running xp_cmdshell calls at through our proxy account, which works fine the majority of the time. However... occasionally xp_cmdshells will start to fail, and do not begin working again until the cluster i...

error message - I'm trying to install SQL Server 2000 with sp3 so I can move our existing Data Base to a new server, But I keep getting this error - Error running script:sp3_serv_uni.sql(1). I've tried sp4 but same thing. What is it looking for that it's not..
   Database Help (Home) -> Server All times are: Pacific Time (US & Canada) (change)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]