Big delay authenticating for a query

[MrPeds]

Hi,

I have an SSRS 2000 report that contains 2 datasets. Each dataset holds the results of a basic MDX query (the queries come back almost instantaneously in the sample MDX app). The report also contains a very simple stored procedure call which returns only 1 row of data.

Our problem is that the report is taking about 45 seconds to render, which seems ridiculous for the small amount and simplicity of data beign returned.

Looking at the log files it seems that it is taking 15 seconds to be authenticated per olap dataset.

Our connection string is:

Provider=MSOLAP.2;Initial Catalog=Mycatalog;Data Source=MyServer

We have tried carrying out an oledb connection test in C# to see if opening the connection takes the same time and it does e.g.

OleDbConnection ole = new OleDbConnection("Provider=MSOLAP.2;Initial Catalog=Mycatalog;Data Source=MyServer");
ole.Open();

We do not think it is a hardware issue as the server has 16GB of Ram and 8 processors. The version of RS is Enterprise.

My question is therefore, is there anything in the connection string that we can change or add to speed up authentication, or any config setting we can change to make authentication faster?

Regards,

MrPeds

 

[ks2000]

Are MyServer and the reporting server both same? If Myserver is different server then copy the cube from Myserver to Reporting server and point connection to reporting server.

Thanks