locked
as a reporting Services data source FAQ question RRS feed

  • Question

  • Hi!

    reading the FAQ about the support for reporting services, i remain a bit confused of the overall meaning, 


    "Is Reporting Services or Analysis Services supported in the cloud solution?

    (Business Intelligence) is not part of our cloud offerings in v1 of SQL Azure. However they are our incubation projects and we are considering adding them as a service in the Azure platform. In the short term, we are working to enable SQL Azure as a datasource for your BI solutions which would include Analysis Services and Reporting Services...."

    From the above it seems clear that you can't just replace a Reporting Services datasource connectionString with a sql azure connectionstring and expect it to work, however i remain quite unsure after reading the next phrase;

    "You can, however, access SQL Azure from within your locally running Reporting Services and Analysis Services projects."

    could you please elaborate about what this means with 'access' and 'locally'? does this means that it will work from visual studio but not on a deployed reportServer?

     

    Thursday, January 7, 2010 4:15 PM

Answers

  • Hi,

    It means SQL Azure can be the data source of Report server projects/Analysis Services projects. For example, to use SQL Azure as the data source of Report Server project you can:

    1. Double click the .rdl file in the Solution Explorer window of Report Server project.
    2. Click Design tab.
    3. Select View->Report Data from menu bar to view Report Data window.
    4. Add a Data Source or modify existing Data Source to use connection string of SQL Azure db.

    To clarify further, the Reporting service is running locally but grabs data from SQL Azure.

    Please remember to mark the replies as answers if they help and unmark them if they provide no help.
    Friday, January 8, 2010 10:13 AM

All replies

  • Hi,

    It means SQL Azure can be the data source of Report server projects/Analysis Services projects. For example, to use SQL Azure as the data source of Report Server project you can:

    1. Double click the .rdl file in the Solution Explorer window of Report Server project.
    2. Click Design tab.
    3. Select View->Report Data from menu bar to view Report Data window.
    4. Add a Data Source or modify existing Data Source to use connection string of SQL Azure db.

    To clarify further, the Reporting service is running locally but grabs data from SQL Azure.

    Please remember to mark the replies as answers if they help and unmark them if they provide no help.
    Friday, January 8, 2010 10:13 AM
  • thanks for replying!

    so, basically what is it that it won't work? may be the FAQ tried to say that it doesn't offer reporting service pages straight from the azure cloud? so you still need to deploy reporting services somewhere?
    Friday, January 8, 2010 3:49 PM
  • Yes your understanding is correct.
    Please remember to mark the replies as answers if they help and unmark them if they provide no help.
    Monday, January 11, 2010 2:18 AM