How do I trace what is causing an "MSSQLServerOLAPService error 3001" error?

Posted on 2009-05-24
Medium Priority
Last Modified: 2013-11-30
I am seeing the following error in the event log:

Event Type:      Error
Event Source:      MSSQLServerOLAPService
Event Category:      Server
Event ID:      124
Date:            25/05/2009
Time:            1:05:27 p.m.
User:            N/A
Computer:      BEANIE
Relational data provider reported error: [Invalid argument.;3001].

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

I have tried a number of SQL Profile traces but am obviously not having any luck!

Any ideas?
Question by:paultormey
  • 4

Expert Comment

ID: 24464638

Author Comment

ID: 24465961
This is SQL Server 2000 SP3a

Author Comment

ID: 24465970
And the link you reference doesn't have any bearing on this problem. I;ve already looked at that link.
Build your data science skills into a career

Are you ready to take your data science career to the next step, or break into data science? With Springboard’s Data Science Career Track, you’ll master data science topics, have personalized career guidance, weekly calls with a data science expert, and a job guarantee.


Expert Comment

ID: 24465980
why not apply sp4

Author Comment

ID: 24569055
No responses as yet that have been helpful.

Accepted Solution

paultormey earned 0 total points
ID: 24626312
The problem has been resolved.

The permissions of the SQL Server startup / admin account had been changed.

The MSSQLServerOLAPService was being started as the local system account and looks as if these were clashing.

Changed the MSSQLServerOLAPService to start with the same account used by SQL Server service.

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

In part one, we reviewed the prerequisites required for installing SQL Server vNext. In this part we will explore how to install Microsoft's SQL Server on Ubuntu 16.04.
In this article, we will show how to detach and attach a database and then show how to repair a corrupt database and attach it, If it has some errors. We will show how to detach and attach using SSMS or using T-SQL sentences.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

627 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question