Showing posts with label iis6. Show all posts
Showing posts with label iis6. Show all posts

Friday, March 30, 2012

Install Reporting Services on another IIS website

I am using IIS6 and installed Reporting Services on http://myWebsite in IIS.
This works fine and I can access http://myWebsite/ReportServer and http://myWebsite/Reports

My problem is that I also need Reporting Services on another website in IIS6.
I have a website http://www.myothersite.com which I also need Reporting Services on. I created two virtual directories (Reports,ReportServer) that point to the same directories as which the original Reporting Services site does, but it doesn't work. I get "You are not authorized to view this page message in IE." when I view http://www.myothersite.com/ReportViewer in my browser

Any suggestions?i dont think you would need to report managers. you would only need one report manager and create your folders in it and use the appropriate paths in various websites on the server.

hthsql

Monday, March 26, 2012

Install issues under IIS6

Hello,
I ran the installer on a windows 2000/ iis5 server and no issues at all, the
server components were available during setup (trial version downloaded from
MS).
I subsequently tried the same thing on a Windows 2003 / IIS6 server and it
says IIS is not properly configured but it does not tell me what
specifically is the problem. IIS works fine on the server, i have over 10
sites hosted and it is working fine.
My guess is there must be a security/permission problem?
Anybody else have issues running the Report Services installer on an IIS6
machine?
PLEASE HELP! :)
thanks in advance,
-ZDRS will not install if you are running IIS 6 in IIS 5 compatibility mode.
You should check that first. If that is not the case then look in the
rsspt<#>.log file, search for prereq and there should be a line in there
telling you what check is failing.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Z D" <NOSPAM@.NOSPAM.com> wrote in message
news:O1wrZhUVEHA.2336@.TK2MSFTNGP12.phx.gbl...
> Hello,
> I ran the installer on a windows 2000/ iis5 server and no issues at all,
the
> server components were available during setup (trial version downloaded
from
> MS).
> I subsequently tried the same thing on a Windows 2003 / IIS6 server and it
> says IIS is not properly configured but it does not tell me what
> specifically is the problem. IIS works fine on the server, i have over 10
> sites hosted and it is working fine.
> My guess is there must be a security/permission problem?
> Anybody else have issues running the Report Services installer on an IIS6
> machine?
> PLEASE HELP! :)
> thanks in advance,
> -ZD
>|||Daniel,
Thanks for your reply. :)
IIS6 is NOT running in IIS5 compat mode.
I am unable to find the rsspt*.log file anywhere on my webserver. Do you
know which directory it's supposed to be in? When exactly is it created? (I
cancel out of the install after I get the warning message saying IIS is not
installed/configured for a server component installation).
Thanks,
-ZD
"Daniel Reib [MSFT]" <danreib@.online.microsoft.com> wrote in message
news:%23$ETx9VVEHA.2752@.TK2MSFTNGP10.phx.gbl...
> RS will not install if you are running IIS 6 in IIS 5 compatibility mode.
> You should check that first. If that is not the case then look in the
> rsspt<#>.log file, search for prereq and there should be a line in there
> telling you what check is failing.
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no
rights.
>
> "Z D" <NOSPAM@.NOSPAM.com> wrote in message
> news:O1wrZhUVEHA.2336@.TK2MSFTNGP12.phx.gbl...
> > Hello,
> >
> > I ran the installer on a windows 2000/ iis5 server and no issues at all,
> the
> > server components were available during setup (trial version downloaded
> from
> > MS).
> >
> > I subsequently tried the same thing on a Windows 2003 / IIS6 server and
it
> > says IIS is not properly configured but it does not tell me what
> > specifically is the problem. IIS works fine on the server, i have over
10
> > sites hosted and it is working fine.
> >
> > My guess is there must be a security/permission problem?
> >
> > Anybody else have issues running the Report Services installer on an
IIS6
> > machine?
> >
> > PLEASE HELP! :)
> >
> > thanks in advance,
> > -ZD
> >
> >
>|||Hi Daniel, thanks for your reply.
I finally found the file, it was named rsstp<#>.log (not rsspt<#>.log).
Anyways, below is the relevant portion of the log that is failing. It seems
as though its looking for W3SVC #1 ' Is that the default website? I deleted
that when I originally configured IIS, but I do have another site from which
the server can be accessed through http://localhost and http://<serverName>
Any ideas?
Thanks
-ZD
<EndFunc Name='PerformDetections' Return='0' GetLastError='0'>
<Prerequisite Name="IsIISInstalled" Checked="Metabase"
Item="/LM/W3SVC/1/1016" Found="Can not read value" Expected="No error"
Result="Fail" />
Machine = WWW01, Article = IIS, Result = 60350 (0xebbe)
<Prerequisite Name="IsVS71Installed" Checked="Registry"
Item="HKLM\SOFTWARE\Microsoft\VisualStudio\7.1" Found="Can not open key"
Expected="No error" Result="Fail" />
Machine = WWW01, Article = VSNET, Result = 60351 (0xebbf)
Machine = WWW01, Article = ASPNET, Result = 0 (0x0)
Machine = WWW01, Article = MDAC, Result = 0 (0x0)
Machine = WWW01, Article = DTC, Result = 0 (0x0)
Machine = WWW01, Article = SERVEROS, Result = 0 (0x0)
Machine = WWW01, Article = SHAREPOINT, Result = 0 (0x0)
Machine = WWW01, Article = AUTHZ, Result = 0 (0x0)
Machine = WWW01, Article = RSACCOUNTS, Result = 0 (0x0)
**************
WWW01
**************
Report Server component requirement
<B>Explanation:</B> Internet Information Services 5.0 (IIS) or later is
either not installed, or it is configured in a way that is incompatible with
a Reporting Services installation.
<B>Action:</B> To install the Report Server and Report Manager components,
you must first install Internet Information Services 5.0 (IIS) or later, and
then verify that the Web server configuration requirements are compatible
with Setup. Check the Setup documentation for more information about Web
server configuration requirements.
Report Designer component requirement
<B>Explanation:</B> Visual Studio .NET 2003 is not installed.
<B>Action:</B> Install Visual Studio .NET 2003, and then rerun Setup to
install Report Designer. Or, continue Setup to complete the installation
without Report Designer.
Report size = 1050
"Daniel Reib [MSFT]" <danreib@.online.microsoft.com> wrote in message
news:%23$ETx9VVEHA.2752@.TK2MSFTNGP10.phx.gbl...
> RS will not install if you are running IIS 6 in IIS 5 compatibility mode.
> You should check that first. If that is not the case then look in the
> rsspt<#>.log file, search for prereq and there should be a line in there
> telling you what check is failing.
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no
rights.
>
> "Z D" <NOSPAM@.NOSPAM.com> wrote in message
> news:O1wrZhUVEHA.2336@.TK2MSFTNGP12.phx.gbl...
> > Hello,
> >
> > I ran the installer on a windows 2000/ iis5 server and no issues at all,
> the
> > server components were available during setup (trial version downloaded
> from
> > MS).
> >
> > I subsequently tried the same thing on a Windows 2003 / IIS6 server and
it
> > says IIS is not properly configured but it does not tell me what
> > specifically is the problem. IIS works fine on the server, i have over
10
> > sites hosted and it is working fine.
> >
> > My guess is there must be a security/permission problem?
> >
> > Anybody else have issues running the Report Services installer on an
IIS6
> > machine?
> >
> > PLEASE HELP! :)
> >
> > thanks in advance,
> > -ZD
> >
> >
>|||RS setup only supports installing to the default website. Unfortunately
there is no way to change this. After the install the vdirs can be moved
using the following instructions:
http://www.sqljunkies.com/HowTo/525B575A-7F61-483A-AC8F-FEC700C34674.scuk
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Z D" <NOSPAM@.NOSPAM.com> wrote in message
news:eWA$JcIWEHA.2972@.TK2MSFTNGP12.phx.gbl...
> Hi Daniel, thanks for your reply.
> I finally found the file, it was named rsstp<#>.log (not rsspt<#>.log).
> Anyways, below is the relevant portion of the log that is failing. It
seems
> as though its looking for W3SVC #1 ' Is that the default website? I
deleted
> that when I originally configured IIS, but I do have another site from
which
> the server can be accessed through http://localhost and
http://<serverName>
> Any ideas?
> Thanks
> -ZD
>
> <EndFunc Name='PerformDetections' Return='0' GetLastError='0'>
> <Prerequisite Name="IsIISInstalled" Checked="Metabase"
> Item="/LM/W3SVC/1/1016" Found="Can not read value" Expected="No error"
> Result="Fail" />
> Machine = WWW01, Article = IIS, Result = 60350 (0xebbe)
> <Prerequisite Name="IsVS71Installed" Checked="Registry"
> Item="HKLM\SOFTWARE\Microsoft\VisualStudio\7.1" Found="Can not open key"
> Expected="No error" Result="Fail" />
> Machine = WWW01, Article = VSNET, Result = 60351 (0xebbf)
> Machine = WWW01, Article = ASPNET, Result = 0 (0x0)
> Machine = WWW01, Article = MDAC, Result = 0 (0x0)
> Machine = WWW01, Article = DTC, Result = 0 (0x0)
> Machine = WWW01, Article = SERVEROS, Result = 0 (0x0)
> Machine = WWW01, Article = SHAREPOINT, Result = 0 (0x0)
> Machine = WWW01, Article = AUTHZ, Result = 0 (0x0)
> Machine = WWW01, Article = RSACCOUNTS, Result = 0 (0x0)
> **************
> WWW01
> **************
> Report Server component requirement
> <B>Explanation:</B> Internet Information Services 5.0 (IIS) or later is
> either not installed, or it is configured in a way that is incompatible
with
> a Reporting Services installation.
> <B>Action:</B> To install the Report Server and Report Manager components,
> you must first install Internet Information Services 5.0 (IIS) or later,
and
> then verify that the Web server configuration requirements are compatible
> with Setup. Check the Setup documentation for more information about Web
> server configuration requirements.
> Report Designer component requirement
> <B>Explanation:</B> Visual Studio .NET 2003 is not installed.
> <B>Action:</B> Install Visual Studio .NET 2003, and then rerun Setup to
> install Report Designer. Or, continue Setup to complete the installation
> without Report Designer.
> Report size = 1050
>
>
> "Daniel Reib [MSFT]" <danreib@.online.microsoft.com> wrote in message
> news:%23$ETx9VVEHA.2752@.TK2MSFTNGP10.phx.gbl...
> > RS will not install if you are running IIS 6 in IIS 5 compatibility
mode.
> > You should check that first. If that is not the case then look in the
> > rsspt<#>.log file, search for prereq and there should be a line in there
> > telling you what check is failing.
> >
> > --
> > -Daniel
> > This posting is provided "AS IS" with no warranties, and confers no
> rights.
> >
> >
> > "Z D" <NOSPAM@.NOSPAM.com> wrote in message
> > news:O1wrZhUVEHA.2336@.TK2MSFTNGP12.phx.gbl...
> > > Hello,
> > >
> > > I ran the installer on a windows 2000/ iis5 server and no issues at
all,
> > the
> > > server components were available during setup (trial version
downloaded
> > from
> > > MS).
> > >
> > > I subsequently tried the same thing on a Windows 2003 / IIS6 server
and
> it
> > > says IIS is not properly configured but it does not tell me what
> > > specifically is the problem. IIS works fine on the server, i have
over
> 10
> > > sites hosted and it is working fine.
> > >
> > > My guess is there must be a security/permission problem?
> > >
> > > Anybody else have issues running the Report Services installer on an
> IIS6
> > > machine?
> > >
> > > PLEASE HELP! :)
> > >
> > > thanks in advance,
> > > -ZD
> > >
> > >
> >
> >
>

Wednesday, March 21, 2012

install error on web server (windows 2003 web edition/iis6)

During the web server install, I used the network service account to run the
report server.
My Error: setup could not initialize the report server. you must manually
initialize the report server before using it for the 1st time. see reporting
services setup doc.
My environment:
sql server = dbs
web server = report server
client = designer
Do I need to run the rsactivate utility on the web server? How is this done?
Is this correct syntax in the command prompt?
rsconfig -m \\<webserver> -u<administrator> -p<password>
Or, if I am logged onto the web server directly; is this the correct way to
activate the report server?
rsconfig -c"C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
Services\ReportServer\RSReportServer.config"
Thanks,When I tried to pull up the site on my client, I got:
reporting services error
the report server installation is not initialized. check the doc for more
info. (rsreportservernotactivated) get help:
http://www.microsoft.com/products/ee/transform.aspx?EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings.resources.Strings&EvtID=rsReportServerNotActivated&ProdName=Microsoft+SQL+Server+Reporting+Services&ProdVer=8.00
As a result of the error, I restarted the web server and typed in the
address for the reportserver and got prompted to login. I could not use the
servername, but the ipaddress 192.168.0.4/reportserver
It let me in after logging in and displayed the ms sql server reporting
services v 8.
Does this mean that it is working?
---
"wills" wrote:
> During the web server install, I used the network service account to run the
> report server.
> My Error: setup could not initialize the report server. you must manually
> initialize the report server before using it for the 1st time. see reporting
> services setup doc.
> My environment:
> sql server = dbs
> web server = report server
> client = designer
> Do I need to run the rsactivate utility on the web server? How is this done?
> Is this correct syntax in the command prompt?
> rsconfig -m \\<webserver> -u<administrator> -p<password>
>
> Or, if I am logged onto the web server directly; is this the correct way to
> activate the report server?
> rsconfig -c"C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
> Services\ReportServer\RSReportServer.config"
> Thanks,
>|||I tried to test the report manager, 192.168.0.4/reports
I got the following: 192.168.0.4/reports/pages/folder.aspx
Error
The request failed with http status 400. Bad Request.
Home
Does this mean that it is working?
"wills" wrote:
> When I tried to pull up the site on my client, I got:
> reporting services error
> the report server installation is not initialized. check the doc for more
> info. (rsreportservernotactivated) get help:
> http://www.microsoft.com/products/ee/transform.aspx?EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings.resources.Strings&EvtID=rsReportServerNotActivated&ProdName=Microsoft+SQL+Server+Reporting+Services&ProdVer=8.00
>
> As a result of the error, I restarted the web server and typed in the
> address for the reportserver and got prompted to login. I could not use the
> servername, but the ipaddress 192.168.0.4/reportserver
> It let me in after logging in and displayed the ms sql server reporting
> services v 8.
> Does this mean that it is working?
>
> ---
> "wills" wrote:
> > During the web server install, I used the network service account to run the
> > report server.
> >
> > My Error: setup could not initialize the report server. you must manually
> > initialize the report server before using it for the 1st time. see reporting
> > services setup doc.
> >
> > My environment:
> > sql server = dbs
> > web server = report server
> > client = designer
> >
> > Do I need to run the rsactivate utility on the web server? How is this done?
> > Is this correct syntax in the command prompt?
> >
> > rsconfig -m \\<webserver> -u<administrator> -p<password>
> >
> >
> > Or, if I am logged onto the web server directly; is this the correct way to
> > activate the report server?
> >
> > rsconfig -c"C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
> > Services\ReportServer\RSReportServer.config"
> >
> > Thanks,
> >
> >