RS / AS 2005 on Microsoft and Non-Microsoft databases.

[wiseteufel via SQLMonster.com]

Hello -

Background -
We have 18 seperate servers with 6 non- SQL Server 2000/2005 databases. So,
many of the boxes we have are windows based and some with SQL Server 2000 and
some with SQL Server 2005 databses. My understanding is that Reporting
Services and Analysis Services are server software and are bundled with the
SQL SERVER 2000 and 2005 Servers Licenses we purchased.

Question -
Can we dedicate a couple of the Microsoft-based Servers (with Windows2003,
SQL Server2005) one for Reporting Services 2005 and one for Analysis Services
2005 to do the reporting for the Microsoft based database servers as well as
the Non-Microsoft databases; i.e can Server X with Reporting Services 2005
get data and report on data from 4 different databases residing on 2 other
non-windows-based servers without paying for licenses.

Thank You in Advance for Your Reply -

Wise -

--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-reporting/200706/1

[Jeje]

there is 2 differents things here:
RS and SSAS can be installed on separate servers. but every time you need a
complete SQL Server license to install 1 of these applications on a new
server.
installing RS required the access to an SQL Server server to store the RS
repository (which is an SQL Server database); Any SQL Server installed on
your network can be used for this.
if SSAS or RS is installed on the same box as an existing SQL Server
deployment, there is no additional cost, 1 license for both services.

After this, RS and SSAS can use any OLEDB or ODBC compatible database as
their source. (RS also support custom data providers to access other
ressources like SAP, Hyperion, XML files, WebServices...)
Accessing a database required that the user have as valid license to access
the back end server which contains the data you display through RS. (if you
access an Oracle database the user must have a valid license to access
Oracle through RS and a valid license to use RS himself)
The data accessed by RS can be anywhere , including data outside the network
(like a remote webservice or a remote database); again you must have as
valid license on the remote system.

"wiseteufel via SQLMonster.com" <u4067@uwe> wrote in message
news:73684d6d15343@uwe...