Accessing Analysis Services 2005 using HTTP from Vista Business

Question

Hye,
      Recently I installed Windows Vistal Business on my PC & created few cubes in SSAS 2005 which I want to browse using Excell 2007.

But unfortunately I'm not able to configure my IIS 7.0 to use msmsdpump.dll.
I am able to do the same when my OS is Windows 2003 Server.

Can anyone please have any suggestions or any KB article or any link related to this problem.
Thanz in advance...

Answer 1

If this is on your local machine you don't need to configure IIS or msmdpump.dll, you can just access the server by name to browse the cubes in Excel. You would only really use HTTP when you are forced to because the client and server are not part of the same windows domain.

Answer 2

Dear Darren,

                     Thanks for the reply. I would just explain my setup to U, I have deployed my OLAP Cubes which I created in SQL Analysis Services 2005 on Windows Vista Businesss. I not only want to access the cube locally but also grant access to the same to my team members(which are in the same workgroup)& my QCC Team(which unfortunately is on some other domain).

                    Previously I used to create a Virtul Directory which had msmdpump.dll and all my users use to access the cube using the follwing string... "http://<ip adress>/<virtual dir.>/msmdpump.dll. But in Vista I am able to create the Virtual Directory and put msmdpump.dll & the relevent files in it. But I'm not able to find the option to configure it(eg... rights,adding  .dll extension ,etc.) .

                   I would really appriciate if u can elaborate a bit on the solution you have provided or give me some relevent link of KB article which can help Me.

                  Thanks again for the response.

                                                                       Regards,

                                                                                       Rohan !!

Answer 3

The fact that your QCC team are in a different domain does mean that you would either need to use HTTP or possibly allow annonymous connections (which would let anyone in). I'm guessing that it should be possible, unfortunately I don't have access to a copy of Vista at this point in time to have a look. You could try asking on the IIS forums to see if there are equivalent steps in Vista for the following Win XP http://www.microsoft.com/technet/prodtechnol/sql/2005/httpssas.mspx or Win2003 http://www.microsoft.com/technet/prodtechnol/sql/2005/httpasws.mspx configurations.

Answer 4

Thanks Darren for ur advice. !!

Answer 5

I also have a similar configuration, and I tried to adapt the documents here to IIS 7 and Vista but without success.  I get to the point of having HTTP 405 errors - which sounds like a handshake issue but I can't get beyond that.  Any plans to write a How to configure HTTP for Analysis Services 2005 via Vista in the works?

 

Thanks in advance,

 

K.

Answer 6

I don't know if MS are planning to release anything, but I have it working on Vista Ultimate on my laptop. I will try and put together some basic steps and screen shots over the next few days. I will post a link back here when I have something for you to look at.

 

Answer 7

Thanks Darren - I was finally able to resolve my issue: it was caused by an incorrect setting on my IIS 7 server.  Apparently the server was set to only run 32-bit applications, whereas the msmdpump.dll I was trying to use is 64-bit and so failed to register correctly.  Running the following command corrected this: "

cscript %SYSTEMDRIVE%\inetpub\adminscripts\adsutil.vbs SET W3SVC/AppPools/Enable32bitAppOnWin64 0" .

 

For further information on setting up IIS to run in the correct mode check out http://support.microsoft.com/kb/894435.

 

Answer 8

Darren,

 

Be careful to make sure that no other applications on IIS stopped functioning.  The Enable 32 bit flag is set by default to 0, so chances are something you installed or another application is 32 bit and could now be broken.

 

Answer 9

Actually it was Karnj who was having the issues.

 

I have started writting up a blog post with screen shots, showing how to set up http access on Vista, but I am giving a presentation at the SQL Downunder code camp this weekend and the preparations for that have taken precedence at the moment.

 

I did not really have any trouble at all, so I was checking to see if I had changed any default settings. The 64bit thing is interesting as a lot of people are not running SSAS on 64 bit servers. Thanks for posting back about that KB Karnj - I will add that link to my post when I get back to it

 

Answer 10

You're correct, Brian - I had run an installation of VMWare Server on the same box and its WebAdmin component switched the IIS Server setting behind the scenes, with no warning or notification, or recognition that the server was already set to 64-bit for a reason!

 

Answer 11

 

Hi,
      I have installed SQL Server 2005 on a Vista Business. I am able to connect to SQL Server instance on Vista machine from Management Studio on other machine (Running on Xp).
      But I am not able to connect to Analysis Services default instance on Vista Business machine from Management Studio on other machine (Running on Xp).
      I did all settings with Vista firewall exceptions, SQL Surface area configuration, Security, everything.
      Please tell me do I need to modify something else on 'Vista Business'.

      Thank you.

Answer 12

I have installed SQL Server 2005 on a Vista Business. I am able to connect to SQL Server instance on Vista machine from Management Studio on other machine (Running on Xp).       But I am not able to connect to Analysis Services default instance on Vista Business machine from Management Studio on other machine (Running on Xp).       I did all settings with Vista firewall exceptions, SQL Surface area configuration, Security, everything.       Please tell me do I need to modify something else on 'Vista Business'.

Are these machines in the same domain?

Have you set up the security in both SSAS and IIS?

What error message are you getting?

 

Answer 13

 

Hi,

       Both client and server are in same domain.

       I have set up the security in SSAS by adding my login to SSAS Server properties -> Security.

       I did not configure anything on IIS.

 

       The error that I get in Management Studio is ' a connection can not be made, ensure that the server is running '.

 

       I checked the Vista firewall log. Its dropping request package at Port 2382 which is Analysis Services port.

       Its already in the firewall exceptions.

 

       Darren, I really appreciate your reply.

 

 

Mahesh K.

        

Answer 14

Mahesh K wrote:

I did not configure anything on IIS.

So I guess this means that you are not using the HTTP connectivity then. I figured you were as that is in the title of this thread.

 

Mahesh K wrote:

The error that I get in Management Studio is ' a connection can not be made, ensure that the server is running '.

It sounds like you are having server name or instance name resolution issues. The following two articles cover most connectivity issues.

 

http://www.microsoft.com/technet/prodtechnol/sql/bestpractice/CISQL2005ASCS.mspx

http://www.sqljunkies.com/WebLog/edwardm/archive/2006/05/26/21447.aspx

 

Mahesh K wrote:

I checked the Vista firewall log. Its dropping request package at Port 2382 which is Analysis Services port. Its already in the firewall exceptions.

 

2382 is the SQL Browser port which is used to discover named instances, if you have a named instance the port that this is running under also needs to be open. If you only have a default instance you need to have port 2383 open.

Answer 15

Hi,

      I have an Analysis Server default instance on Vista Business. 

      And both the ports 2382 and 2383 are in firewall exceptions list.

      

      I am sorry, actually requests on Port 2383 are dropped by firewall.

 

     Still no success.

 

     Thanks for the reply.

 

Mahesh K. 

 

Answer 16

Hello Darren:

 

Could you post the link to show how to set up the datapump on IIS7.0. We are having similar issues.

 

Thanks

 

-VT

 

Answer 17

Sure, I have a walkthrough on my blog of how I did it:

http://geekswithblogs.net/darrengosbell/archive/2007/11/04/SSAS-Connecting-via-HTTP-on-Windows-Vista.aspx