Help on setting up Reporting Service...

I am new to Reporting Services. I set up the infrastruicture with two
computers to learn the Reporting Service, a stand alone server (No DNS and
AD and not a domain server) and a workstation, and both computers are in the
same workgroup. On the server computer I have a SQL 2000 SP4, mixed mode,
running on a Windows 2003 Server SP1. The second computer is installed with
the Reporting Service SP2 and is running on Windows XP Professional SP2 with
IIS enabled, also I have Visual Studio 2003 installed on this box to create
test reports. I can create and deploy reports using the Visual Studio 2003
and also view the report by typing the something like http://<IIS Server
Name>/ReportServer on the address bar in the Internet Explorer on the
workstation within the LAN. It opens the Report Manager UI and I can see all
the reports I deployed using the VS 2003. However if I try to access the
Report Manager from a remote location which I asked my friend try it from
his home computer by typing http://<My IIS public IP address>/ReportServer
and it did not work. I know that it is something to do with the security
setting with the IIS and the SQL 2000. How can I change the setting to allow
remote computer to access the reports directly or using the Report Manager
UI? Also how can I implment security to stop people access the reports or
Report Manager UI? Should I implement the security at the IIS server or to
the SQL 2000 or on individual database? Or should I implement the security
on both IIS and SQL 2000 and database? Thanks.I had a similar issue with the Firewall on XP SP2. You can add exclusions
to the firewall using the firewall administrator.
--
| From: "Paul" <paul_mak@.hotmail.com>
| Subject: Help on setting up Reporting Service...
| Date: Thu, 25 Aug 2005 10:38:13 -0700
| Lines: 23
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
| X-RFC2646: Format=Flowed; Original
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
| Message-ID: <#UqJ3vZqFHA.272@.TK2MSFTNGP15.phx.gbl>
| Newsgroups: microsoft.public.sqlserver.reportingsvcs
| NNTP-Posting-Host: 64.114.25.49
| Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP15.phx.gbl
| Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.reportingsvcs:51138
| X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
|
| I am new to Reporting Services. I set up the infrastruicture with two
| computers to learn the Reporting Service, a stand alone server (No DNS
and
| AD and not a domain server) and a workstation, and both computers are in
the
| same workgroup. On the server computer I have a SQL 2000 SP4, mixed mode,
| running on a Windows 2003 Server SP1. The second computer is installed
with
| the Reporting Service SP2 and is running on Windows XP Professional SP2
with
| IIS enabled, also I have Visual Studio 2003 installed on this box to
create
| test reports. I can create and deploy reports using the Visual Studio
2003
| and also view the report by typing the something like http://<IIS Server
| Name>/ReportServer on the address bar in the Internet Explorer on the
| workstation within the LAN. It opens the Report Manager UI and I can see
all
| the reports I deployed using the VS 2003. However if I try to access the
| Report Manager from a remote location which I asked my friend try it from
| his home computer by typing http://<My IIS public IP
address>/ReportServer
| and it did not work. I know that it is something to do with the security
| setting with the IIS and the SQL 2000. How can I change the setting to
allow
| remote computer to access the reports directly or using the Report
Manager
| UI? Also how can I implment security to stop people access the reports or
| Report Manager UI? Should I implement the security at the IIS server or
to
| the SQL 2000 or on individual database? Or should I implement the
security
| on both IIS and SQL 2000 and database? Thanks.
|
|
|