question

vksgurbani avatar image
vksgurbani asked

one of our Windows 2000 server domain changed after that MSSQLSERVEROLAPSERVICE is not starting.

This is the error message we are getting Error 1067: The process terminated unexpectedly. In even viewer below message is shown: The MSSQLServerOLAPService service terminated unexpectedly. It has done this 11 time(s). The following corrective action will be taken in 0 milliseconds: No action.
sql-server-2000olapanalysis-serviceswindows-server-2000
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

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

2 Answers

·
raghavenderchavva avatar image
raghavenderchavva answered
Check the service accounts and then provide correct service accounts.
1 comment
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

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

vksgurbani avatar image vksgurbani commented ·
Hi Raghavender, Thank for reply. I checked all the accounts and permission on all folders and done enough R&D related to accounts and permissions. But services are still giving same error. Regards, Vikas Gurbani
0 Likes 0 ·
ThomasRushton avatar image
ThomasRushton answered
Have you changed the service accounts? If so, did you do this just in the services MMC snap-in, or did you use the SQL Server configuration manager? There's more to it than just adding a different account/password, and the SQL Config manager does all that work for you.
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

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.