question

simeon avatar image
simeon asked

Log Object Name: MSSQLServerOLAPService

am trying to start this services but it automatically stops - is that normal or is there a way I can start the service : MSSQLServerOLAPService (Supplies online analytical processing (OLAP) and data mining functionality for business intelligence applications.)
sql service broker
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

sqlaj 1 avatar image
sqlaj 1 answered
That is an error message but not very descriptive, huh? What about errors in the Application event log? Anything in there with more information? It sounds like permissions issue. Have you tried changing the account to LocalSystem then see if it starts? If it does, change back and test.
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

sqlaj 1 avatar image
sqlaj 1 answered
What errors are you seeing? How are you trying to start the service? What account is the service trying to use? Is it a domain account? Is the account locked?
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

simeon avatar image
simeon answered
Thank you, from the Server manager under services - the account is being used is Local services and start up type is automatic and service start up status stopped, when I click the start service the error am getting is the service on this this server started and stopped. some services stop automatically if they are not in use by other services or program.
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

simeon avatar image
simeon answered
Thank you it worked - problem solved with a smile on my face
2 comments
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Cool! Make sure you mark it "answered" Thanks
0 Likes 0 ·
good day again same problem on deferent server I did a research Log Object Name: MSSQLServerOLAPService and this is what I did changed system locale from English South Africa to English US 4.Restart the System 5.Once your system is Restarted open the Registry Editor (from Start = > Run => regedit) 6.Navigate to HKEY_USERS 7.Look for LSA entry @ S-1-5-18 8.Search for LocaleName 9.Update the following keys 1.Locale = 00000409 2.LocaleName = en-US 3.sCountry = United States 1. Open the SQL Server Configuration Manager, and start the SQL Server Analysis Services - service - did not start-up rebooted server - did not, come back online - I did the back up of the registry
0 Likes 0 ·
simeon avatar image
simeon answered
good day again same problem on deferent server I did a research Log Object Name: MSSQLServerOLAPService and this is what I did changed system locale from English South Africa to English US 4.Restart the System 5.Once your system is Restarted open the Registry Editor (from Start = > Run => regedit) 6.Navigate to HKEY_USERS 7.Look for LSA entry @ S-1-5-18 8.Search for LocaleName 9.Update the following keys 1.Locale = 00000409 2.LocaleName = en-US 3.sCountry = United States 1. Open the SQL Server Configuration Manager, and start the SQL Server Analysis Services rebooted server - did not come back online - I did the back up of the registry
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.