locked
Integrating SQL RS 2005 into our apps RRS feed

  • Question

  • Microsoft Support

    here is our scenario

    We are an ISV that develops software products for our customers. We have two different flavors of Customers (Enterprise and Standard..) Ya, just like Microsoft 

    We would like to take SQL RS 2005 and integrate it within our apps

    For our standard customers, we were thinking of packaging our canned reports into SQL 2005 Express Advanced versions

    For our Enterprise customers, we were thinking of using the SQl 2005 Standard or Enterprise Reporting services.

    As I was going down this path and making recommendations,  I got an error trying to make this architecture work for us

    Have  SQL 2005 Report Server running on (Express- Advanced)  talk to a SQL Express Catalog database on another box.

    It appears that SQL 2005 Express can only work with local catalog database and local data sources. This is turning out to be a dampener to our migration to this server based reporting product for our low end customers.

    Can you guys think of a workaround ? Our customer databases are going to be in SQL 2000 and it is going to be that way for a long time to come.. Meanwhile, we also want to adopt SQL2005  Reporting Services and move from Local reporting to Server based reporting. 

    Thoughts or ideas on helping me sell SQL 2005 Rs to folks here ?

     

     

     

     

     

     

     

     

     

     

     

     

     

    Wednesday, July 19, 2006 9:52 PM

Answers

  • Hi,

    I am not from MS Support, but I think, that I am also allowed to answer? :-)

    SQL Express wAF will only be allowed to access the local data storage - that is correct. You will be able to evaluate this in the feature comparison at www.microsoft.com/sql.

    Why do you want a SQL Express for your Standard Users while connecting to another box?

    Will this be the central data storage for your application? While couldn´t this be the Reporting Server also?

    As another alternative you could use the reportviewer-control in your application.

    Cheers,
    Markus

    Wednesday, July 19, 2006 10:17 PM