Deployment to IIS and SQL

I've written a number of reports that now need to be deployed to a production
environment. The reports will be sitting on one IIS server that is
completely hidden from SQL Server. The reports data is retrieved via a web
service.
Can the reports be deployed to IIS and SQL server independantly? If so how?Deployment is easy, you just say where it resides (the IIS portion of RS)
and RS design client within VS does the rest. The real issue for you is
installing RS in this configuration. RS is an asp.net application. Your IIS
has to be configured appropriately for this. Read up on installing where the
SQL Server is not on the same box. This is totally supported. Note that you
will still need a license for the IIS box. You have to have a license on
every box that has RS server software installed.
Bruce L-C
"Buzz" <Buzz@.discussions.microsoft.com> wrote in message
news:90E11231-A3AE-42CC-9CD3-A0F469A00AD4@.microsoft.com...
> I've written a number of reports that now need to be deployed to a
production
> environment. The reports will be sitting on one IIS server that is
> completely hidden from SQL Server. The reports data is retrieved via a
web
> service.
> Can the reports be deployed to IIS and SQL server independantly? If so
how?|||VS does not have to be installed on the Server. Only on the development
machine.
Bruce L-C
"Buzz" <Buzz@.discussions.microsoft.com> wrote in message
news:76C3CEA2-DD41-4F26-A197-8C7FA36D1F41@.microsoft.com...
> We cannot use Visual Studio to deploy in a production environment, its
just
> not installed. I am looking into using the .NET ReportingService() class
to
> deploy via a windows application or script.
> "Bruce Loehle-Conger" wrote:
> > Deployment is easy, you just say where it resides (the IIS portion of
RS)
> > and RS design client within VS does the rest. The real issue for you is
> > installing RS in this configuration. RS is an asp.net application. Your
IIS
> > has to be configured appropriately for this. Read up on installing where
the
> > SQL Server is not on the same box. This is totally supported. Note that
you
> > will still need a license for the IIS box. You have to have a license on
> > every box that has RS server software installed.
> >
> > Bruce L-C
> >
> > "Buzz" <Buzz@.discussions.microsoft.com> wrote in message
> > news:90E11231-A3AE-42CC-9CD3-A0F469A00AD4@.microsoft.com...
> > > I've written a number of reports that now need to be deployed to a
> > production
> > > environment. The reports will be sitting on one IIS server that is
> > > completely hidden from SQL Server. The reports data is retrieved via
a
> > web
> > > service.
> > >
> > > Can the reports be deployed to IIS and SQL server independantly? If
so
> > how?
> >
> >
> >

Deployment Acritecture of SRS 2005

Hi,
I want to know how the .rdl files are deployed in the IIS Server and what is
the path where there are deplyed. Also how the UI identifes from where to
access the .rdl file attached to the perticular record.THe reports are stored in a table named Content(s?) if I remember
correctly...
--
Wayne Snyder MCDBA, SQL Server MVP
Mariner, Charlotte, NC
(Please respond only to the newsgroup.)
I support the Professional Association for SQL Server ( PASS) and it's
community of SQL Professionals.
"Parimal" <Parimal@.discussions.microsoft.com> wrote in message
news:6BE09721-2DF8-4681-BFEB-FEF790CC9B5D@.microsoft.com...
> Hi,
> I want to know how the .rdl files are deployed in the IIS Server and what
is
> the path where there are deplyed. Also how the UI identifes from where to
> access the .rdl file attached to the perticular record.

Deploying too many reports causes error in report manager

sql reporting services (sp2)
windows 2003 server
Sql 200 sp4
all on one server (iis & sql server)
I have about 30 reports which I deploy from my local environment to our
reporting server. If I deploy about 10 of the reports everything is fine,
all reports deployed work. However, the more reports I deploy I notice the
slower the report manager screen takes to load. After I deploy about 15 of
my reports I will eventually get an error on report manager screen:
There is an error in XML document (1, 4078)
I have tried to deploy differnent reports to see if it is a specific report
that may be causing this, but this does not seem to be the case.
Any help with this would be greatly appreciated, as I am out of ideas and
resources to figure this out.
Regards,
Troygensx100 wrote:
> sql reporting services (sp2)
> windows 2003 server
> Sql 200 sp4
> all on one server (iis & sql server)
> I have about 30 reports which I deploy from my local environment to our
> reporting server. If I deploy about 10 of the reports everything is fine,
> all reports deployed work. However, the more reports I deploy I notice the
> slower the report manager screen takes to load. After I deploy about 15 of
> my reports I will eventually get an error on report manager screen:
> There is an error in XML document (1, 4078)
> I have tried to deploy differnent reports to see if it is a specific report
> that may be causing this, but this does not seem to be the case.
> Any help with this would be greatly appreciated, as I am out of ideas and
> resources to figure this out.
> Regards,
> Troy
sounds strange ,30 reports not a lot at all .|||gensx100 wrote:
> sql reporting services (sp2)
> windows 2003 server
> Sql 200 sp4
> all on one server (iis & sql server)
> I have about 30 reports which I deploy from my local environment to our
> reporting server. If I deploy about 10 of the reports everything is fine,
> all reports deployed work. However, the more reports I deploy I notice the
> slower the report manager screen takes to load. After I deploy about 15 of
> my reports I will eventually get an error on report manager screen:
> There is an error in XML document (1, 4078)
> I have tried to deploy differnent reports to see if it is a specific report
> that may be causing this, but this does not seem to be the case.
> Any help with this would be greatly appreciated, as I am out of ideas and
> resources to figure this out.
> Regards,
> Troy
Troy, i may test your reports in your environment just
to verify nothing is really wrong with them, if you
wish.
We have our own tool to deploy reports, so this could
be useful - to deploy them at once but slightly
another way...
I just need your .rdls to do so.
Let me know.
Cheers

Deploying SSRS

I am trying to get SSRS to work and am having trouble getting it to go.
When I go to IIS and browse, it won't let me see the page, it reads "This
page cannot be displayed". The internet has connectivity because I can get
on my email and other sites.
When I try to deploy the report, I am having issues as well with
connectivity. I get an error that reads "A connection could not be made to
the report server http://localhost/ReportServer"
I went to services on the server and verified that SSRS was running and so
was IIS.
Any thoughts?Check the access (security) rights on the ReportServer.
David
"Ryan Mcbee" <RyanMcbee@.discussions.microsoft.com> wrote in message
news:ED56B7A0-274E-4345-914C-3AAFA0B4CF59@.microsoft.com...
>I am trying to get SSRS to work and am having trouble getting it to go.
> When I go to IIS and browse, it won't let me see the page, it reads "This
> page cannot be displayed". The internet has connectivity because I can
> get
> on my email and other sites.
> When I try to deploy the report, I am having issues as well with
> connectivity. I get an error that reads "A connection could not be made
> to
> the report server http://localhost/ReportServer"
> I went to services on the server and verified that SSRS was running and so
> was IIS.
> Any thoughts?|||David,
Do you mean the ReportServer db database in SQL management studio? What
security are you referring to?
Thanks,
Ryan
"David C" wrote:
> Check the access (security) rights on the ReportServer.
> David
> "Ryan Mcbee" <RyanMcbee@.discussions.microsoft.com> wrote in message
> news:ED56B7A0-274E-4345-914C-3AAFA0B4CF59@.microsoft.com...
> >I am trying to get SSRS to work and am having trouble getting it to go.
> > When I go to IIS and browse, it won't let me see the page, it reads "This
> > page cannot be displayed". The internet has connectivity because I can
> > get
> > on my email and other sites.
> >
> > When I try to deploy the report, I am having issues as well with
> > connectivity. I get an error that reads "A connection could not be made
> > to
> > the report server http://localhost/ReportServer"
> >
> > I went to services on the server and verified that SSRS was running and so
> > was IIS.
> >
> > Any thoughts?
>
>|||Go into the Report Manager from your browser. Select the folder that holds
your reports, click the Properties tab and then the Security link. Users
should have at least Browser (I think) to run the reports.
Use the "New Role Assignment" button to add users or groups. I suggest you
use an Active Directory (or local) group as it will be easier to manage.
David
"Ryan Mcbee" <RyanMcbee@.discussions.microsoft.com> wrote in message
news:AB4F831D-1CBB-4786-80B4-5747988BA44F@.microsoft.com...
> David,
> Do you mean the ReportServer db database in SQL management studio? What
> security are you referring to?
> Thanks,
> Ryan
> "David C" wrote:
>> Check the access (security) rights on the ReportServer.
>> David
>> "Ryan Mcbee" <RyanMcbee@.discussions.microsoft.com> wrote in message
>> news:ED56B7A0-274E-4345-914C-3AAFA0B4CF59@.microsoft.com...
>> >I am trying to get SSRS to work and am having trouble getting it to go.
>> > When I go to IIS and browse, it won't let me see the page, it reads
>> > "This
>> > page cannot be displayed". The internet has connectivity because I can
>> > get
>> > on my email and other sites.
>> >
>> > When I try to deploy the report, I am having issues as well with
>> > connectivity. I get an error that reads "A connection could not be
>> > made
>> > to
>> > the report server http://localhost/ReportServer"
>> >
>> > I went to services on the server and verified that SSRS was running and
>> > so
>> > was IIS.
>> >
>> > Any thoughts?
>>|||David,
That is the problem, I can't even get the browser page to show up. When I
try to deploy a report, it isn't connecting to the report server. Not sure
what is going on. IIS is on and so is SSRS services.
Any other thoughts?
Ryan
"David C" wrote:
> Go into the Report Manager from your browser. Select the folder that holds
> your reports, click the Properties tab and then the Security link. Users
> should have at least Browser (I think) to run the reports.
> Use the "New Role Assignment" button to add users or groups. I suggest you
> use an Active Directory (or local) group as it will be easier to manage.
> David
> "Ryan Mcbee" <RyanMcbee@.discussions.microsoft.com> wrote in message
> news:AB4F831D-1CBB-4786-80B4-5747988BA44F@.microsoft.com...
> > David,
> > Do you mean the ReportServer db database in SQL management studio? What
> > security are you referring to?
> >
> > Thanks,
> > Ryan
> >
> > "David C" wrote:
> >
> >> Check the access (security) rights on the ReportServer.
> >>
> >> David
> >> "Ryan Mcbee" <RyanMcbee@.discussions.microsoft.com> wrote in message
> >> news:ED56B7A0-274E-4345-914C-3AAFA0B4CF59@.microsoft.com...
> >> >I am trying to get SSRS to work and am having trouble getting it to go.
> >> > When I go to IIS and browse, it won't let me see the page, it reads
> >> > "This
> >> > page cannot be displayed". The internet has connectivity because I can
> >> > get
> >> > on my email and other sites.
> >> >
> >> > When I try to deploy the report, I am having issues as well with
> >> > connectivity. I get an error that reads "A connection could not be
> >> > made
> >> > to
> >> > the report server http://localhost/ReportServer"
> >> >
> >> > I went to services on the server and verified that SSRS was running and
> >> > so
> >> > was IIS.
> >> >
> >> > Any thoughts?
> >>
> >>
> >>
>
>|||Hi,
It seems to be a problem to hit the web server.
Have you check IIS logs ? Do you see connection attempts ? What is the HTTP
status code ?
Does SSRS and IIS on the same server ?
Jean-Pierre
"Ryan Mcbee" <RyanMcbee@.discussions.microsoft.com> wrote in message
news:CCE4F651-B458-4435-9FCA-0EFAE4235594@.microsoft.com...
> David,
> That is the problem, I can't even get the browser page to show up. When I
> try to deploy a report, it isn't connecting to the report server. Not
> sure
> what is going on. IIS is on and so is SSRS services.
> Any other thoughts?
> Ryan
> "David C" wrote:
>> Go into the Report Manager from your browser. Select the folder that
>> holds
>> your reports, click the Properties tab and then the Security link. Users
>> should have at least Browser (I think) to run the reports.
>> Use the "New Role Assignment" button to add users or groups. I suggest
>> you
>> use an Active Directory (or local) group as it will be easier to manage.
>> David
>> "Ryan Mcbee" <RyanMcbee@.discussions.microsoft.com> wrote in message
>> news:AB4F831D-1CBB-4786-80B4-5747988BA44F@.microsoft.com...
>> > David,
>> > Do you mean the ReportServer db database in SQL management studio?
>> > What
>> > security are you referring to?
>> >
>> > Thanks,
>> > Ryan
>> >
>> > "David C" wrote:
>> >
>> >> Check the access (security) rights on the ReportServer.
>> >>
>> >> David
>> >> "Ryan Mcbee" <RyanMcbee@.discussions.microsoft.com> wrote in message
>> >> news:ED56B7A0-274E-4345-914C-3AAFA0B4CF59@.microsoft.com...
>> >> >I am trying to get SSRS to work and am having trouble getting it to
>> >> >go.
>> >> > When I go to IIS and browse, it won't let me see the page, it reads
>> >> > "This
>> >> > page cannot be displayed". The internet has connectivity because I
>> >> > can
>> >> > get
>> >> > on my email and other sites.
>> >> >
>> >> > When I try to deploy the report, I am having issues as well with
>> >> > connectivity. I get an error that reads "A connection could not be
>> >> > made
>> >> > to
>> >> > the report server http://localhost/ReportServer"
>> >> >
>> >> > I went to services on the server and verified that SSRS was running
>> >> > and
>> >> > so
>> >> > was IIS.
>> >> >
>> >> > Any thoughts?
>> >>
>> >>
>> >>
>>

Deploying Reporting Services as an internet application

Are there any resources available in regards to deploying reporting services
on an IIS server that would be available from an internet IP address.
Users would not be Windows users but customers of the company. Users will be
set up in sql tables with rights assigned rhrough sql tables.
Thanks in advanceThis is documented in BOL @.
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsadmin/htm/drp_deploying_v1_0h9e.asp.
Check the "Deploying a Report Server for Internet Access" section.
--
Ravi Mumulla (Microsoft)
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Will Byron" <WillB@.CEPSystems.com> wrote in message
news:%23fswN8TWEHA.1656@.TK2MSFTNGP09.phx.gbl...
> Are there any resources available in regards to deploying reporting
services
> on an IIS server that would be available from an internet IP address.
> Users would not be Windows users but customers of the company. Users will
be
> set up in sql tables with rights assigned rhrough sql tables.
> Thanks in advance
>

Deploying error

IIS and other things were re-installed on a machine I used to deploy to.
Now when I deploy, I get this error.
The underlying connection was closed: Unable to connect to the remote
server.
What should I check for this?Sorry, i found it in another message, changing the config file.
"Cindy Lee" <cindylee@.hotmail.com> wrote in message
news:ePRTeT$VFHA.2700@.TK2MSFTNGP12.phx.gbl...
> IIS and other things were re-installed on a machine I used to deploy to.
> Now when I deploy, I get this error.
> The underlying connection was closed: Unable to connect to the remote
> server.
> What should I check for this?
>

deploy MS Reporting services to IIS on my own pc

How do I deploy a report developed in MS Reporting Services to an IIS
on my own pc?
FrancoOn 14 Oct 2005 10:13:45 -0700, francowell@.gmail.com wrote:
>How do I deploy a report developed in MS Reporting Services to an IIS
>on my own pc?
>Franco
You can't - at least not if you only have IIS on the machine.
You can deploy to a server running Reporting Services, which also
require IIS.
Or, if you are using Reporting Services 2005, you can also use the new
ReportViewer controls which don't require Reporting Services on a
server but have more limited functionality.
Andrew Watt
MVP - InfoPath|||My PC also has SQL 2000 and VS Studio.net 2003 installed on it. Do I
have what is needeed to deploy a report on this pc?
Franco|||On 14 Oct 2005 11:30:12 -0700, francowell@.gmail.com wrote:
>My PC also has SQL 2000 and VS Studio.net 2003 installed on it. Do I
>have what is needeed to deploy a report on this pc?
>Franco
If you have SQL Server 2000 then, assuming you obtained Reporting
Services 2000, you can deploy on the machine.
If you have SQL Server 2000 Developer Edition you can test deployment
but you are not licensed, as I understand it, to deploy for production
use.
Andrew Watt
MVP - InfoPath|||This is only for testing the reports that I am developing. How do I go
about deploying the report?
Franco|||On 14 Oct 2005 12:26:11 -0700, francowell@.gmail.com wrote:
>This is only for testing the reports that I am developing. How do I go
>about deploying the report?
>Franco
Franco,
In VS2003, open Solution Explorer, right click on the Solution name,
select Deploy Solution.
Likely it will deploy to the correct location by default if you are
deploying locally.
Try accessing the report by going to http://localhost/reports/ in
Internet Explorer.
Andrew Watt
MVP - InfoPath|||Andrew
Your suggestion is not working, but thank you anyway. I appreciate
your help.
Have a great weekend....Franco|||Hi Franco,
There are lots of possibilities for it not working.
If you describe which aspect isn't working and what error message(s)
you get, then I can suggest how you can maybe fix it.
Andrew Watt
MVP - InfoPath
On 14 Oct 2005 13:16:16 -0700, francowell@.gmail.com wrote:
>Andrew
>Your suggestion is not working, but thank you anyway. I appreciate
>your help.
>Have a great weekend....Franco|||Franco, Have you ever installed Reporting Services Server. I assume since
you have created a report you installed the tools. Did you ever install
Reporting Services. Can you go to the website and see Report Manager?
You need to make sure it is installed and working properly before trying to
deploy.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
<francowell@.gmail.com> wrote in message
news:1129320976.701766.251640@.g44g2000cwa.googlegroups.com...
> Andrew
> Your suggestion is not working, but thank you anyway. I appreciate
> your help.
> Have a great weekend....Franco
>