Thursday, March 22, 2012

Does reporting services need SQL Server for the RS application tables?

Would it be possible to buy a license for SQL server, not install SQL
server and then have both the data and application tables in an Oracle
database?
A customer of ours does not want to support SQL Server at all. I can
accept that they need a SQL license to use RS, but is there a way to
get around the SQL requirment for the app tables? Will moving the
tables from SQL to Oracle (and the configuring RS to use Oracle)
result in application errors?
I was hoping someone knew the answers before I started testing the
scenarios above.No. SQL Server is needed by Reporting Services. The data can be anywhere but
RS needs SQL Server to operate (the database can be on a separate server but
it has to be somewhere).
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"coldfact" <bryan@.coldfact.com> wrote in message
news:249185cd.0410261208.1283bdf1@.posting.google.com...
> Would it be possible to buy a license for SQL server, not install SQL
> server and then have both the data and application tables in an Oracle
> database?
> A customer of ours does not want to support SQL Server at all. I can
> accept that they need a SQL license to use RS, but is there a way to
> get around the SQL requirment for the app tables? Will moving the
> tables from SQL to Oracle (and the configuring RS to use Oracle)
> result in application errors?
> I was hoping someone knew the answers before I started testing the
> scenarios above.

No comments:

Post a Comment