Can the SQL Server 2005 Reporting Services configured to use the SQL2K Server
as reporting database server?
Rationale:
So that I can put the 2005 reporting services in the DMZ and use exisitng
sql2K server behind the DMZ to store the reporting database. Another reason
is that , I don't have to buy 2 licenses (1 for the reporting services and 1
for reporting database). If I have the reporting database on the SQL2K,
exisiting license would cover that.
I am not sure whether this can be done. Can somebody throw some light on this.
Thanks,Yes it's possible to store the report server database in a sql server 2000.
look at the post "RS 2005 with SQL Server 2000" (26.09.2005)
"JDS" <JDS@.discussions.microsoft.com> schrieb im Newsbeitrag
news:F92E7419-4B02-4B8C-B63A-AFA736FA6A2F@.microsoft.com...
> Can the SQL Server 2005 Reporting Services configured to use the SQL2K
> Server
> as reporting database server?
> Rationale:
> So that I can put the 2005 reporting services in the DMZ and use exisitng
> sql2K server behind the DMZ to store the reporting database. Another
> reason
> is that , I don't have to buy 2 licenses (1 for the reporting services and
> 1
> for reporting database). If I have the reporting database on the SQL2K,
> exisiting license would cover that.
> I am not sure whether this can be done. Can somebody throw some light on
> this.
> Thanks,
>|||=?Utf-8?B?SkRT?= <JDS@.discussions.microsoft.com> wrote in
news:F92E7419-4B02-4B8C-B63A-AFA736FA6A2F@.microsoft.com:
Yes it will work BUT
You need to license SQL 2005 to use RS2005 AND since RS is not a separate
product, you need a SQL license for the computer hosting RS.
> Can the SQL Server 2005 Reporting Services configured to use the SQL2K
> Server as reporting database server?
> Rationale:
> So that I can put the 2005 reporting services in the DMZ and use
> exisitng sql2K server behind the DMZ to store the reporting database.
> Another reason is that , I don't have to buy 2 licenses (1 for the
> reporting services and 1 for reporting database). If I have the
> reporting database on the SQL2K, exisiting license would cover that.
> I am not sure whether this can be done. Can somebody throw some light
> on this.
> Thanks,
>|||Thanks Jens and Asher
"Asher_N" wrote:
> =?Utf-8?B?SkRT?= <JDS@.discussions.microsoft.com> wrote in
> news:F92E7419-4B02-4B8C-B63A-AFA736FA6A2F@.microsoft.com:
> Yes it will work BUT
> You need to license SQL 2005 to use RS2005 AND since RS is not a separate
> product, you need a SQL license for the computer hosting RS.
> > Can the SQL Server 2005 Reporting Services configured to use the SQL2K
> > Server as reporting database server?
> >
> > Rationale:
> > So that I can put the 2005 reporting services in the DMZ and use
> > exisitng sql2K server behind the DMZ to store the reporting database.
> > Another reason is that , I don't have to buy 2 licenses (1 for the
> > reporting services and 1 for reporting database). If I have the
> > reporting database on the SQL2K, exisiting license would cover that.
> >
> > I am not sure whether this can be done. Can somebody throw some light
> > on this.
> >
> > Thanks,
> >
> >
>
Sunday, March 25, 2012
Deployment: SRS2005 can use SQL2K as ReportDatabase
Labels:
configured,
database,
deployment,
microsoft,
mysql,
oracle,
rationale,
reportdatabase,
reporting,
server,
services,
sql,
sql2k,
srs2005
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment