none
Using SSAS HTTP Pump as datasource in SSRS

    Question

  • Hi,

    I have successfully setup HTTP access to SSAS using the pump method described here: http://bloggingabout.net/blogs/mglaser/archive/2008/08/15/configuring-http-access-to-sql-server-2008-analysis-services-on-microsoft-windows-server-2008.aspx

    By success, I mean that on the localhost I can use Microsoft Report Builder and select it as a datasource and make reports.

    Is it possible to use the pump method as a datasource in SSRS? I have tried setting up several different ways but it doesn't seem to work.

    Thanks,

    Jon Elling
    Thursday, June 18, 2009 8:14 PM

Answers

  • Hi Jon,

     

    You cannot do that, the BIDS use Security Support Provider Interface (SSPI) for security control, but the integrated security 'sspi' is not supported for http connection. One of good reasons for using HTTP Access to SSAS server, is you can use anonymous authentication, windows authentication and basic authentication. But when you using BIDS, after selecting “Microsoft SQL Server Analysis Server” as datasource type, switch to credential tab, you can only select windows integrated security. And the default windows integrated security doesn’t support HTTP connection. So when you set the severname started with HTTP, click test connection, it always through an error message.

     

    Hope this helps.

    Raymond

    Monday, June 22, 2009 7:42 AM
    Moderator

All replies

  • Hi Jon,

     

    You cannot do that, the BIDS use Security Support Provider Interface (SSPI) for security control, but the integrated security 'sspi' is not supported for http connection. One of good reasons for using HTTP Access to SSAS server, is you can use anonymous authentication, windows authentication and basic authentication. But when you using BIDS, after selecting “Microsoft SQL Server Analysis Server” as datasource type, switch to credential tab, you can only select windows integrated security. And the default windows integrated security doesn’t support HTTP connection. So when you set the severname started with HTTP, click test connection, it always through an error message.

     

    Hope this helps.

    Raymond

    Monday, June 22, 2009 7:42 AM
    Moderator
  • Thanks. It's much better to know that then to keep banging my head against the wall.

    My root problem is that I want to let users outside of the domain connect using BIDS. They will either be coming across the public internet or via a site-to-site VPN, if necessary. Is there anything you suggest?

    When I tried connecting that way myself it didn't seem to want to accept my windows login for the domain hosting SSRS.

    Monday, June 22, 2009 8:37 PM
  • Hi Jon,

     

    It’s not safe, we don’t suggest that. This is related to the network policy, you need to discuss with your IT department, implement Virtual Private Networking (VPN) in your organization. Otherwise you cannot connect to the SQL Server Databases with BIDS from outside.

     

    Hope this helps.

    Raymond

     

    Tuesday, June 23, 2009 2:32 AM
    Moderator
  • I agree. But when I connected via VPN - but not as part of the domain - I had problems connecting. Just to confirm, this should work via VPN?
    Tuesday, June 23, 2009 2:28 PM
  • Hi Jon,

     

    Generally speaking, you access to domain server from outside through VPN just like working in a domain, because you should enter your domain account first and then use your domain account credential to access the SQL Server. So you can connect to SQL SERVER with BIDS from outside through VPN. Of cause, there could be some problems when using VPN, if you have these kinds of issue, you can refer to Networking Forum:

    http://social.technet.microsoft.com/Forums/en-US/winserverPN/threads

     

    Hope this helps.

    Raymond

    Wednesday, June 24, 2009 6:47 AM
    Moderator