- SSAS
- SQL
- Microsoft SQL Server
- Query Syntax
SQL Server Analysis Services 2012: Login Failure Events found in Event Viewer
The following events were found while going through the Event Viewer. I did verify that the SQL Server Analysis Services (MSSQLSERVER) service is using the account 'NT Service\MSSQLServerOLAPSer
The error appears to occur every two hours, at about 20 minutes after the hour.
I do not have much experience in Analysis Services (but I do in SQL Server itself). Analysis Services was set up to be used with MS SharePoint and MS Team Foundation.
As a test, I have disabled reporting in Team Foundation. Team Foundation was configured to use the specified administrator account for reporting. So I should know in a few hours if that was the issue.
Thanks in Advance,
- Michael
There error is as follows:
An account failed to log on.
Subject:
Security ID: NT SERVICE\MSSQLServerOLAPSer
Account Name: MSSQLServerOLAPService
Account Domain: NT Service
Logon ID: 0x25872
Logon Type: 8
Account For Which Logon Failed:
Security ID: NULL SID
Account Name: Administrator
Account Domain: MYDOMAIN
Failure Information:
Failure Reason: Unknown user name or bad password.
Status: 0xc000006d
Sub Status: 0xc000006a
Process Information:
Caller Process ID: 0x7dc
Caller Process Name: C:\Program Files\Microsoft SQL Server\MSAS11.MSSQLSERVER\
Network Information:
Workstation Name: MYTEAMFOUNDATION
Source Network Address: -
Source Port: -
Detailed Authentication Information:
Logon Process: Advapi
Authentication Package: Negotiate
Transited Services: -
Package Name (NTLM only): -
Key Length: 0
This event is generated when a logon request fails. It is generated on the computer where access was attempted.
The Subject fields indicate the account on the local system which requested the logon. This is most commonly a service such as the Server service, or a local process such as Winlogon.exe or Services.exe.
The Logon Type field indicates the kind of logon that was requested. The most common types are 2 (interactive) and 3 (network).
The Process Information fields indicate which account and process on the system requested the logon.
The Network Information fields indicate where a remote logon request originated. Workstation name is not always available and may be left blank in some cases.
The authentication information fields provide detailed information about this specific logon request.
- Transited services indicate which intermediate services have participated in this logon request.
- Package name indicates which sub-protocol was used among the NTLM protocols.
- Key length indicates the length of the generated session key. This will be 0 if no session key was requested.
The error appears to occur every two hours, at about 20 minutes after the hour.
I do not have much experience in Analysis Services (but I do in SQL Server itself). Analysis Services was set up to be used with MS SharePoint and MS Team Foundation.
As a test, I have disabled reporting in Team Foundation. Team Foundation was configured to use the specified administrator account for reporting. So I should know in a few hours if that was the issue.
Thanks in Advance,
- Michael
There error is as follows:
An account failed to log on.
Subject:
Security ID: NT SERVICE\MSSQLServerOLAPSer
Account Name: MSSQLServerOLAPService
Account Domain: NT Service
Logon ID: 0x25872
Logon Type: 8
Account For Which Logon Failed:
Security ID: NULL SID
Account Name: Administrator
Account Domain: MYDOMAIN
Failure Information:
Failure Reason: Unknown user name or bad password.
Status: 0xc000006d
Sub Status: 0xc000006a
Process Information:
Caller Process ID: 0x7dc
Caller Process Name: C:\Program Files\Microsoft SQL Server\MSAS11.MSSQLSERVER\
Network Information:
Workstation Name: MYTEAMFOUNDATION
Source Network Address: -
Source Port: -
Detailed Authentication Information:
Logon Process: Advapi
Authentication Package: Negotiate
Transited Services: -
Package Name (NTLM only): -
Key Length: 0
This event is generated when a logon request fails. It is generated on the computer where access was attempted.
The Subject fields indicate the account on the local system which requested the logon. This is most commonly a service such as the Server service, or a local process such as Winlogon.exe or Services.exe.
The Logon Type field indicates the kind of logon that was requested. The most common types are 2 (interactive) and 3 (network).
The Process Information fields indicate which account and process on the system requested the logon.
The Network Information fields indicate where a remote logon request originated. Workstation name is not always available and may be left blank in some cases.
The authentication information fields provide detailed information about this specific logon request.
- Transited services indicate which intermediate services have participated in this logon request.
- Package name indicates which sub-protocol was used among the NTLM protocols.
- Key length indicates the length of the generated session key. This will be 0 if no session key was requested.
check if your failed login is still active MYDOMAIN\ Administrator
and clarify and post masked all EV error
this one looks like EV security one
if all is set ok for your server SSAS and system and apps EV logs are clean
and service is running fine
you should be fine
waiting for your logs clarifications
and clarify and post masked all EV error
this one looks like EV security one
if all is set ok for your server SSAS and system and apps EV logs are clean
and service is running fine
you should be fine
waiting for your logs clarifications
The wrong account was being used for Team Foundation Reporting.
![Team Foundation Reporting Configuration]()
Please see the following document for more information on the report that should be used:
https://msdn.microsoft.com/en-us/library/ms253149.aspx
Please see the following document for more information on the report that should be used:
https://msdn.microsoft.com/en-us/library/ms253149.aspx
Premium Content
You need an Expert Office subscription to comment.Start Free Trial