Deployment of analysis services on windows 2003(Very urgent Please)

I have window 2000 as my development machine. I am using visual studio 2003 and sql server 2000.
I was able to develop a web application which uses the pivot table componant.
Every thing was working fine with out any problem.

I deployed my Project to windows 2003.
I am able to see the pivot table control.
I am not able to get any data into my pivot table.

I am not sure what is going wrong.
Is there anything I need to take care in windows 2003 specifically.

I don't have microsoft office on windows 2003.
Does it make a difference?

Please help!!!

Anil

Help Please|||

If you are using MSOWC for your pivot table component and if yout new server do not have riyhrt MSOWC installled or Office instaled,then you will not be able to view the data.

|||

MSOWC is already available on that machine.
I think the webservice is not able to contact the iis properly.
I have already setup the virtual directory for olap on IIS.

Any ideas

|||

Are you using the HTTP connection to Analysis Services or are you connection directly?

If you are connecting directly, what is the version of the MSOLAP80.dll? You may have to upgrade it to a service pack for Analysis Services.

Copy the MDX Sample Application exe to the 2003 machine and see if it can connect.

David

|||

Finally we narrow down the error it is with the fieldsets for the pivot table.

The web service is working fine if we remove the accessing fieldsets code.

When ever we tried to access the fieldsets in the cube we are getting error.

The error message is "Interop.OWC10 - Unspecified error ".

We installed service pack 4 on sql server.

I reinstalled the owc10 dll again.

I gave the permissions to the user machinename_iuser....

But nothing has solved my problem.

Please help.

|||

Hello. I have some doubts about if OWC:s work with HTTP unless you write some code to make them work. OWC are ActiveX controls and they use tcp/ip.

If you disable the SSAS Olap connection and publish an excel OWC OLAP- report in a folder on your IIS machine, will this work? This is to make sure that nothing else is causing these problems.

It is not recommended to develop on an older O/S than the server O/S, but you are probably aware of that now.

Also check that you are allowed to run programs in your IIS folder on Windows 2003.

In IIS/ Win2003 you can check what web service extensions that are allowed.

Regards

Thomas Ivarsson

|||

i am not sure how to disable the SSAS Olap connection and publish an excel OWC OLAP- report in a folder on your IIS machine.

Yes I am member in administrator group. I can run programs in my IIS folder.

Webservice has extensions allowed in iis are
Active Server Pages
ASP.Net v1.1.4322
Front Page server extensions
HwsMessages HttpReceive
Windows Sharepoint Services.

Regards
Anil

|||

Hello. Build a report from SSAS2000 in Excel and publish it to a webfolder on your IIS. I see that you have Sharepoint services. Upload your Excel SSAS2000 report to Sharepoint on Win2003 server.

Regards

Thomas Ivarsson

|||

I published it on iis and I am able to see all dimension but I am not able to see the fact table values.
I don't know what else to do.

Thanks So much for your help

Anil

|||

Here is link to a kb with your keywords(http://support.microsoft.com/kb/331400)

Regards

Thomas Ivarsson