Install RS with SSL handled in firewall

Hi,

We are trying to install RS in an unusual environment. The Web server's SSL and public IP address are installed in the firewall. The communications between Web server and other servers such as database server are not encrypted; all the servers have no public IP addresses.

My question is if RS can be installed and if it will work properly. Any other advice?

Thanks

Yes - we call this SSL Offloading.

With SQL Server 2005 Reporting Services, things should just work with the exception of the following:

1) Report Builder - it requires a direct connection to the report server to download and to function.

2) Links in Emails - we use the URLRoot property in the rsreportserver.config file to form the URL for the link. You'll need to set the property to your external IP Address or the external hostname, and remember to use the https protocol designatiion.

3) Drill-through links in Exported reports (PDF, Excel, etc.) - again we use the URLRoot property in the rsreportserve.config file to form the URL for the link. See comment above.

4) SharePoint V2 web parts - need a direct connection to the report server to view reports.

With SQL Server 2000 Reporting Services, this is supported starting with SP2. The instructions for setting this up are in the SP2 readme file. One note I should add, is that it is required for the router to translate URLs.

-Lukasz

This posting is provided "AS IS" with no warranties, and confers no rights.

sql

Install RS Report Server without VS .Net

I want to install RS Report Server component but I don't want to install
Visual Studio. Can it be done ? Because the installer always check for Visual
Studio .Net in the beginning. ThanksYour machine needs to have MS .NET Framework version 1.1 installed, IIS
configured to run ASP.NET, MDAC 2.6 or higher and be able to connect to an
instance of SQL 2000 or even MSDE.
You can find all this info @.
http://www.microsoft.com/sql/reporting/productinfo/sysreqs.asp
SAL E. YOUNG
www.syoungdesigns.com
"Keenz" <Keenz@.discussions.microsoft.com> wrote in message
news:57122096-DC0B-47D8-AA06-215520C39D80@.microsoft.com...
>I want to install RS Report Server component but I don't want to install
> Visual Studio. Can it be done ? Because the installer always check for
> Visual
> Studio .Net in the beginning. Thanks|||On Mon, 10 Jan 2005 19:07:03 -0800, "Keenz" <Keenz@.discussions.microsoft.com>
wrote:
>I want to install RS Report Server component but I don't want to install
>Visual Studio. Can it be done ? Because the installer always check for Visual
>Studio .Net in the beginning. Thanks
Ignore the warning and continue with the installation. RS will be installed.
Only the report builder needs Visual Studio.
Joachim.

Install RS on SQL2000

I have SQL2000 Developer installed my XP box. Look like I can't put any
except the trial version of RS. Does RS run on SQL Std and Ent only? I
want to play with RS but don't want to install the trial version. Is there
a workaround? Thanks.Hi,
I have SS2000 Developer SP3 AND RS2000 SP2 on my XP SP2 machine with no
problem.
You need to double-check what is the problem with your installation.
Best Regards
Jordi Rambla
SQL Server MVP
Solid Quality Learning
Spain

Install RS in one machine

I have installed Reporting Services in two systems, server-client, without any problem.

Then I tried to add in the client the server part just to be able to work as standalone system.

The client is one W2003 with IIS and SQLServer, similar to the server machine.

I can built and generate a report with VStudio, but when I tried to implement in localhost it gives me error: a trust conection with the "remote" server" is not possible.
I can see in the Reports page that the folder for the report is created, but it is empty.
If I try the implementation in the smae project just changing the TargetUrl to the real remote server, it is working.

I have compared nearly all the security conditions in the localhost an remote servres, mainly the ones related to security, without finding any difference.

Has anyone installed Reporting Services in one system?Hi Robert,

I am developing all on one system. You might check that your Shared Datasource is
using "Use a specific and password" for Credentials and not "Use Windows Authentication".

Best Regards, Jane

Install RS for multiple websites on single computer

My understanding is that RS installs ONLY on the default website. I'm hosting
four websites on a single IIS computer. I want to use Reporting Services
separately on each of the websites. That is, each will have its own database
and its own set of reports. Is this possible? How?
Thanks.
DilipDilip,
I am not sure if you can host multiple instances of RS on single server,
but I have achieved the same requirement by creating a separate directory for
each application. Each corresponding application can have separate directory
with its Reports and required Dataset.
Hope this helps.
Mahesh
"Dilip Kumar" wrote:
> My understanding is that RS installs ONLY on the default website. I'm hosting
> four websites on a single IIS computer. I want to use Reporting Services
> separately on each of the websites. That is, each will have its own database
> and its own set of reports. Is this possible? How?
> Thanks.
> Dilip|||Thanks for your reply, Mahesh.
I want to keep all the domains separate. I want to access each set of
reports as follows:
http://www.companyA.com/Reports
http://www.companyB.com/Reports
http://www.companyC.com/Reports
http://www.companyD.com/Reports
Dilip
"Mahesh Gaware" wrote:
> Dilip,
> I am not sure if you can host multiple instances of RS on single server,
> but I have achieved the same requirement by creating a separate directory for
> each application. Each corresponding application can have separate directory
> with its Reports and required Dataset.
> Hope this helps.
> Mahesh
> "Dilip Kumar" wrote:
> > My understanding is that RS installs ONLY on the default website. I'm hosting
> > four websites on a single IIS computer. I want to use Reporting Services
> > separately on each of the websites. That is, each will have its own database
> > and its own set of reports. Is this possible? How?
> >
> > Thanks.
> > Dilip|||hi Dilip,
hmm.. I am sorry, I have no idea about how this can be acheived using
single IIS server for single RS instance.
Thanks,
Mahesh
"Dilip Kumar" wrote:
> Thanks for your reply, Mahesh.
> I want to keep all the domains separate. I want to access each set of
> reports as follows:
> http://www.companyA.com/Reports
> http://www.companyB.com/Reports
> http://www.companyC.com/Reports
> http://www.companyD.com/Reports
> Dilip
> "Mahesh Gaware" wrote:
> > Dilip,
> > I am not sure if you can host multiple instances of RS on single server,
> > but I have achieved the same requirement by creating a separate directory for
> > each application. Each corresponding application can have separate directory
> > with its Reports and required Dataset.
> >
> > Hope this helps.
> >
> > Mahesh
> >
> > "Dilip Kumar" wrote:
> >
> > > My understanding is that RS installs ONLY on the default website. I'm hosting
> > > four websites on a single IIS computer. I want to use Reporting Services
> > > separately on each of the websites. That is, each will have its own database
> > > and its own set of reports. Is this possible? How?
> > >
> > > Thanks.
> > > Dilip|||Hi Dilip,
I have been thinking about how to do this as I have been thinking of
doing the same...though I am coming to the conclusion it is probably
best to have one server per customer....
However, my thoughts on the subject were as follows...
1. Set up links or domains for each customer.
2. repoint the domains into a single dot net nuke portal (I am
considerign using dot net nuke www.dotnetnuke.com) as the 'BI portal'
for clients....probably a release 2.0 thing for me now.
3. User signs in or can now use integrated security for DNN but if you
have multiple companies on one server you are probably going to host
the server outside their security domains so you need a way to securely
log them into DNN.
4. Present reports inside the DNN environment which will allow you to
have the users looking at the one IIS server and one database without
each customer knowing about the other.....you control where the users
point to for each report or directory so you can just set up different
directories for different customers.
5. You could even set graphics etc from the userid or portal you were
looking at so the clients saw different formats etc inside their BI
portal...
Having played with all this...I thought it was easier just to get the
clients to pay for one machine each...
Peter

Install RS 2000 with SQL 2005

Hello,
i want to install Reporting Services 2000 with SQL 2005 Express Edition. Is
this possible? Any problems?
THX
Andre ScheiberleBooks On LIne says that this functionality will be added to SQL Express soon
( the doc was dated Nov 7 2005.) However, if it is on your CD already - go
for it...I don't think you'll get Report Builder however
--
Wayne Snyder MCDBA, SQL Server MVP
Mariner, Charlotte, NC
I support the Professional Association for SQL Server ( PASS) and it''s
community of SQL Professionals.
"Andre Scheiberle" wrote:
> Hello,
> i want to install Reporting Services 2000 with SQL 2005 Express Edition. Is
> this possible? Any problems?
> THX
> Andre Scheiberle
>|||"=?Utf-8?B?QW5kcmUgU2NoZWliZXJsZQ==?="
<AndreScheiberle@.discussions.microsoft.com> wrote in
news:469351AA-80FB-4AAF-B62E-FC4D7049E3EC@.microsoft.com:
> Hello,
> i want to install Reporting Services 2000 with SQL 2005 Express
> Edition. Is this possible? Any problems?
> THX
> Andre Scheiberle
>
WHY'?|||Maybe because no license needs to be paid?
Jan D''Hondt
Jade bvba
Belgium
Database and .NET development
<Toto, I''ve got a feeling we''re not in Kansas anymore.>
"Asher_N" wrote:
> "=?Utf-8?B?QW5kcmUgU2NoZWliZXJsZQ==?="
> <AndreScheiberle@.discussions.microsoft.com> wrote in
> news:469351AA-80FB-4AAF-B62E-FC4D7049E3EC@.microsoft.com:
> > Hello,
> > i want to install Reporting Services 2000 with SQL 2005 Express
> > Edition. Is this possible? Any problems?
> > THX
> > Andre Scheiberle
> >
> WHY'?
>|||You need a SQL 2000 license to install RS2000.
"=?Utf-8?B?SmFuIERIb25kdA==?=" <JanDHondt@.discussions.microsoft.com> wrote
in news:F6120D99-D7B8-4EB0-8E83-11FBF1827B66@.microsoft.com:
> Maybe because no license needs to be paid?
>
> --
> Jan D''Hondt
> Jade bvba
> Belgium
> Database and .NET development
> <Toto, I''ve got a feeling we''re not in Kansas anymore.>
>
>
> "Asher_N" wrote:
>> "=?Utf-8?B?QW5kcmUgU2NoZWliZXJsZQ==?="
>> <AndreScheiberle@.discussions.microsoft.com> wrote in
>> news:469351AA-80FB-4AAF-B62E-FC4D7049E3EC@.microsoft.com:
>> > Hello,
>> > i want to install Reporting Services 2000 with SQL 2005 Express
>> > Edition. Is this possible? Any problems?
>> > THX
>> > Andre Scheiberle
>> >
>> WHY'?
>|||Do you know a date when this functionality will be a added?
The installation and configuration works (tricky), but now I have a
Web-Application developed in .Net 2.0. Is it possible to configure RS 2000 to
run with .Net 2.0?
THX
Andre Scheiberle
"Wayne Snyder" wrote:
> Books On LIne says that this functionality will be added to SQL Express soon
> ( the doc was dated Nov 7 2005.) However, if it is on your CD already - go
> for it...I don't think you'll get Report Builder however
> --
> Wayne Snyder MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> I support the Professional Association for SQL Server ( PASS) and it''s
> community of SQL Professionals.
>
> "Andre Scheiberle" wrote:
> > Hello,
> > i want to install Reporting Services 2000 with SQL 2005 Express Edition. Is
> > this possible? Any problems?
> > THX
> > Andre Scheiberle
> >|||We have a free SQL 2000 license and can use that. The installation with SQL
Express works (tricky) but now I have a Web-Application developed in .Net
2.0. Is there a way to configure RS 2000 to run with .Net 2.0?
THX
Andre Scheiberle
"Asher_N" wrote:
> You need a SQL 2000 license to install RS2000.
>
> "=?Utf-8?B?SmFuIERIb25kdA==?=" <JanDHondt@.discussions.microsoft.com> wrote
> in news:F6120D99-D7B8-4EB0-8E83-11FBF1827B66@.microsoft.com:
> > Maybe because no license needs to be paid?
> >
> >
> > --
> > Jan D''Hondt
> > Jade bvba
> > Belgium
> > Database and .NET development
> >
> > <Toto, I''ve got a feeling we''re not in Kansas anymore.>
> >
> >
> >
> >
> > "Asher_N" wrote:
> >
> >> "=?Utf-8?B?QW5kcmUgU2NoZWliZXJsZQ==?="
> >> <AndreScheiberle@.discussions.microsoft.com> wrote in
> >> news:469351AA-80FB-4AAF-B62E-FC4D7049E3EC@.microsoft.com:
> >>
> >> > Hello,
> >> > i want to install Reporting Services 2000 with SQL 2005 Express
> >> > Edition. Is this possible? Any problems?
> >> > THX
> >> > Andre Scheiberle
> >> >
> >>
> >> WHY'?
> >>
> >
> >
>|||I don'r believe it is possible.
"=?Utf-8?B?QW5kcmUgU2NoZWliZXJsZQ==?="
<AndreScheiberle@.discussions.microsoft.com> wrote in
news:67FB0B63-622B-4791-969C-E1F9117526C1@.microsoft.com:
> We have a free SQL 2000 license and can use that. The installation
> with SQL Express works (tricky) but now I have a Web-Application
> developed in .Net 2.0. Is there a way to configure RS 2000 to run with
> .Net 2.0?
> THX
> Andre Scheiberle
> "Asher_N" wrote:
>> You need a SQL 2000 license to install RS2000.
>>
>> "=?Utf-8?B?SmFuIERIb25kdA==?=" <JanDHondt@.discussions.microsoft.com>
>> wrote in news:F6120D99-D7B8-4EB0-8E83-11FBF1827B66@.microsoft.com:
>> > Maybe because no license needs to be paid?
>> >
>> >
>> > --
>> > Jan D''Hondt
>> > Jade bvba
>> > Belgium
>> > Database and .NET development
>> >
>> > <Toto, I''ve got a feeling we''re not in Kansas anymore.>
>> >
>> >
>> >
>> >
>> > "Asher_N" wrote:
>> >
>> >> "=?Utf-8?B?QW5kcmUgU2NoZWliZXJsZQ==?="
>> >> <AndreScheiberle@.discussions.microsoft.com> wrote in
>> >> news:469351AA-80FB-4AAF-B62E-FC4D7049E3EC@.microsoft.com:
>> >>
>> >> > Hello,
>> >> > i want to install Reporting Services 2000 with SQL 2005 Express
>> >> > Edition. Is this possible? Any problems?
>> >> > THX
>> >> > Andre Scheiberle
>> >> >
>> >>
>> >> WHY'?
>> >>
>> >
>> >
>>
>|||You will not be able to make RS2000 run under .NET 2.0, however you can
run .NET 2.0 websites side-by-side with .NET 1.1 or 1.0 websites
without any problem. To do this, you can use the "aspnet_regiis.exe"
utility to switch the sites to the correct .NET version of ASP.NET.
For example, if you have both v1.1 and v2.0 installed on your server,
but all websites are setup as v2.0 (since its installation updates the
ASP.NET settings)
You could do the following to reset the SRS websites to the v1.1
version of ASP.NET:
C:\WINDOWS\Microsoft.NET\Framework\v1.1.4322\aspnet_regiis.exe -s
W3SVC/1/ROOT/ReportServer
C:\WINDOWS\Microsoft.NET\Framework\v1.1.4322\aspnet_regiis.exe -s
W3SVC/1/ROOT/Reports
I hope this helps,
Lance Hunt
http://www.lance-hunt.net/

Install RS - Separate DB from Web

I am trying to install reporting services on a web server, which will connect
to an existing instance of the RS Sql Server backend on another machine.
This backend server already has SP2 installed - so when I install RS on the
web server machine and try to point to the existing backend during
installation, it tells me that it is not compatible.
What would be the correct steps to take in order to install on a web server
and connect to an existing RS backend DB? Any relevant articles will help...
Enjoy!
mikeFirst, are you implementing a web farm?
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Michael R" <MichaelR@.discussions.microsoft.com> wrote in message
news:9F638932-02F0-48DF-8EF9-A54EF42AF0FA@.microsoft.com...
>I am trying to install reporting services on a web server, which will
>connect
> to an existing instance of the RS Sql Server backend on another machine.
> This backend server already has SP2 installed - so when I install RS on
> the
> web server machine and try to point to the existing backend during
> installation, it tells me that it is not compatible.
> What would be the correct steps to take in order to install on a web
> server
> and connect to an existing RS backend DB? Any relevant articles will
> help...
> Enjoy!
> mike|||Not in the sense that I will have multiple ReportServer databases. I will
have a one to one relationship: 1 web server and 1 server with the
ReportServer database.
It was recommended that I do this by the server admins, in order to take the
load off of IIS.
"Bruce L-C [MVP]" wrote:
> First, are you implementing a web farm?
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Michael R" <MichaelR@.discussions.microsoft.com> wrote in message
> news:9F638932-02F0-48DF-8EF9-A54EF42AF0FA@.microsoft.com...
> >I am trying to install reporting services on a web server, which will
> >connect
> > to an existing instance of the RS Sql Server backend on another machine.
> > This backend server already has SP2 installed - so when I install RS on
> > the
> > web server machine and try to point to the existing backend during
> > installation, it tells me that it is not compatible.
> >
> > What would be the correct steps to take in order to install on a web
> > server
> > and connect to an existing RS backend DB? Any relevant articles will
> > help...
> >
> > Enjoy!
> >
> > mike
>
>|||I would try this:
1) install SQL RS on the web server, and during the install, create new
SQL RS database(s) for it to point to / use (doesn't matter where you
put the DB, you'll end up dropping them soon). At the end of the
install, you'll have a new SQL RS web app, pointing to a new SQL RS db.
2) Apply SP1 to the SQL RS instance (web & new database).
3) Apply SP2 to the SQL RS instance (web & new database).
4) Now that you're web app is up to SP2, you can point it to your
original database using the 'rsconfig' command line utility (see SQL RS
Books Online for details of usage & syntax). After using 'rsconfig' to
point your app to the original database, you'll need to run the
'rskeymgmt' command line utility to initialize / activate your Report
Server for use with the original database (allows it to read the
original database) -- see Books Online for details of syntax and usage.
5) Drop the new SQL RS databases that were created in Step #1, since
you're not going to use them, now that your web app is pointing to the
'original' SP2 database.