Showing posts with label completed. Show all posts
Showing posts with label completed. Show all posts

Friday, March 9, 2012

RS Post installation problem

When RS completed installation a message was dispalyed saying that the
installation was successful, but that RS was unable to initialise.
Now whenever I try to access the http://servername/reports site, I get the
following error.
"
Compilation Error
Description: An error occurred during the compilation of a resource required
to service this request. Please review the following specific error details
and modify your source code appropriately.
Compiler Error Message: CS0016: Could not write to output file
'c:\WINNT\Microsoft.NET\Framework\v1.1.4322\Temporary ASP.NET
Files\reports\dc088531\5500274e\yip07jmq.dll' -- 'Access is denied. '
"
I think both problems are security/permissions related.
The sever is running Win2k3. I actually had it running fine previously, but
cannot replicate the successful installation on other servers or this one
upon reinstallation.
I have tried giving up to administrator rights to the ASPNET account with no
success.
Advice on resolving this issue would be greatly appreciated.I just tried a reinstall to get the warning message at the end of
installation. It reads:
"Setup has installed Microsoft SQL server 2000 Reporting Services
Successfully. Click Finish to exit.
Setup could not initialize the report server. You must manually initialize
the report server before using it for the first time. For more information,
see the Reporting Services setup documentation"
I have yet to find anything in the setup documentation, so help would be
greatly appreciated.
Thanks and regards,
Alex McKellar.
"TriggerFish" <apples@.oranges.com> wrote in message
news:4134102d@.info-mid...
> When RS completed installation a message was dispalyed saying that the
> installation was successful, but that RS was unable to initialise.
> Now whenever I try to access the http://servername/reports site, I get the
> following error.
> "
> Compilation Error
> Description: An error occurred during the compilation of a resource
required
> to service this request. Please review the following specific error
details
> and modify your source code appropriately.
> Compiler Error Message: CS0016: Could not write to output file
> 'c:\WINNT\Microsoft.NET\Framework\v1.1.4322\Temporary ASP.NET
> Files\reports\dc088531\5500274e\yip07jmq.dll' -- 'Access is denied. '
> "
> I think both problems are security/permissions related.
> The sever is running Win2k3. I actually had it running fine previously,
but
> cannot replicate the successful installation on other servers or this one
> upon reinstallation.
> I have tried giving up to administrator rights to the ASPNET account with
no
> success.
> Advice on resolving this issue would be greatly appreciated.
>|||For future reference and anyone who might read this later, I found the
problem.
The Network Service of the server on which RS in installed needs access to
the %systemroot%\temp directory. It also appeared to me that it needed
access to any "temp" directory environment variables that have been setup on
the server. I had two and once I gave access to both, all worked fine.
FYI for anyone that is interested.
Regards,
Alex.
"TriggerFish" <apples@.oranges.com> wrote in message
news:4134154c$1@.info-mid...
> I just tried a reinstall to get the warning message at the end of
> installation. It reads:
> "Setup has installed Microsoft SQL server 2000 Reporting Services
> Successfully. Click Finish to exit.
> Setup could not initialize the report server. You must manually
initialize
> the report server before using it for the first time. For more
information,
> see the Reporting Services setup documentation"
> I have yet to find anything in the setup documentation, so help would be
> greatly appreciated.
> Thanks and regards,
> Alex McKellar.
>
> "TriggerFish" <apples@.oranges.com> wrote in message
> news:4134102d@.info-mid...
> > When RS completed installation a message was dispalyed saying that the
> > installation was successful, but that RS was unable to initialise.
> >
> > Now whenever I try to access the http://servername/reports site, I get
the
> > following error.
> >
> > "
> > Compilation Error
> > Description: An error occurred during the compilation of a resource
> required
> > to service this request. Please review the following specific error
> details
> > and modify your source code appropriately.
> >
> > Compiler Error Message: CS0016: Could not write to output file
> > 'c:\WINNT\Microsoft.NET\Framework\v1.1.4322\Temporary ASP.NET
> > Files\reports\dc088531\5500274e\yip07jmq.dll' -- 'Access is denied. '
> > "
> >
> > I think both problems are security/permissions related.
> >
> > The sever is running Win2k3. I actually had it running fine previously,
> but
> > cannot replicate the successful installation on other servers or this
one
> > upon reinstallation.
> >
> > I have tried giving up to administrator rights to the ASPNET account
with
> no
> > success.
> >
> > Advice on resolving this issue would be greatly appreciated.
> >
> >
>

Saturday, February 25, 2012

RS and Subscription Mail Delivery

Hi Guy,
During installation of Reporting Services we didn't completed SMTP info.
Up to now thos info are really important for subsription delivery via mail.
I found an article in Technet describing which parameter configure in
RSWebApplication.config file to activate RS SMTP Service.
The config file is an XML format and i think i wrote it wrong because, even
if i restarted everything i don't have availability of mail delivery in
subscription configuration.
Someone could help me?
Can you show me an example of your config file if you correctly setted SMTP
info during setup?
Thanks in advance for your help.
Ciao
StefanoHere is a working configuration (done after the install but that doesn't
matter). Note that I have the IP address of the server hardcoded. You should
not have to do this, you should be able to use the name. Note that most of
configurations are left blank. The IP address is the IP address of a SMTP
server that we have.
<RSEmailDPConfiguration>
<SMTPServer>123.45.6.78</SMTPServer>
<SMTPServerPort></SMTPServerPort>
<SMTPAccountName></SMTPAccountName>
<SMTPConnectionTimeout></SMTPConnectionTimeout>
<SMTPServerPickupDirectory></SMTPServerPickupDirectory>
<SMTPUseSSL></SMTPUseSSL>
<SendUsing></SendUsing>
<SMTPAuthenticate></SMTPAuthenticate>
<From>somebody@.bogus.com</From>
<EmbeddedRenderFormats>
<RenderingExtension>MHTML</RenderingExtension>
</EmbeddedRenderFormats>
<PrivilegedUserRenderFormats></PrivilegedUserRenderFormats>
<ExcludedRenderFormats>
<RenderingExtension>HTMLOWC</RenderingExtension>
<RenderingExtension>NULL</RenderingExtension>
</ExcludedRenderFormats>
<SendEmailToUserAlias>True</SendEmailToUserAlias>
<DefaultHostName></DefaultHostName>
<PermittedHosts></PermittedHosts>
</RSEmailDPConfiguration>
Bruce L-C
"Steph" <steph@.steph.it> wrote in message
news:ewbUSSnaEHA.2812@.TK2MSFTNGP11.phx.gbl...
> Hi Guy,
> During installation of Reporting Services we didn't completed SMTP info.
> Up to now thos info are really important for subsription delivery via
mail.
> I found an article in Technet describing which parameter configure in
> RSWebApplication.config file to activate RS SMTP Service.
> The config file is an XML format and i think i wrote it wrong because,
even
> if i restarted everything i don't have availability of mail delivery in
> subscription configuration.
> Someone could help me?
> Can you show me an example of your config file if you correctly setted
SMTP
> info during setup?
> Thanks in advance for your help.
> Ciao
> Stefano
>|||Thanks Bruce,
But i have an additional request for you.....where i have to place those
line in the file.
My config file is actually done in this way:
<Configuration>
<UI>
<ReportServerUrl>http://SQLLUCEPLAN/ReportServer</ReportServerUrl>
</UI>
<Extensions>
<DeliveryUI>
<Extension Name="Report Server Email"
Type="Microsoft.ReportingServices.EmailDeliveryProvider.EmailDeliveryProvide
rControl,ReportingServicesEmailDeliveryProvider">
<DefaultDeliveryExtension>True</DefaultDeliveryExtension>
<Configuration>
<RSEmailDPConfiguration>
<DefaultRenderingExtension>MHTML</DefaultRenderingExtension>
</RSEmailDPConfiguration>
</Configuration>
</Extension>
<Extension Name="Report Server FileShare"
Type="Microsoft.ReportingServices.FileShareDeliveryProvider.FileShareUIContr
ol,ReportingServicesFileShareDeliveryProvider">
<Configuration>
<FileShare>
<DefaultRenderingExtension>MHTML</DefaultRenderingExtension>
</FileShare>
</Configuration>
</Extension>
</DeliveryUI>
</Extensions>
<Add Key="MaxActiveReqForOneUser" Value="20"/>
<Add Key="DisplayErrorLink" Value="true"/>
</Configuration>
Thanks and Ciao
Stefano|||Did you start editing and deleting lines. Yours looks different. For
instance. I have <Delivery> and you have <DeliveryUI>
When I went in and manually modified entries for email I did not have to add
any lines, I just edited lines that were there.
Do you have your original file?
Bruce L-C
"Steph" <steph@.steph.it> wrote in message
news:et1NN7naEHA.1152@.TK2MSFTNGP09.phx.gbl...
> Thanks Bruce,
> But i have an additional request for you.....where i have to place those
> line in the file.
> My config file is actually done in this way:
> <Configuration>
> <UI>
> <ReportServerUrl>http://SQLLUCEPLAN/ReportServer</ReportServerUrl>
> </UI>
> <Extensions>
> <DeliveryUI>
> <Extension Name="Report Server Email"
>
Type="Microsoft.ReportingServices.EmailDeliveryProvider.EmailDeliveryProvide
> rControl,ReportingServicesEmailDeliveryProvider">
> <DefaultDeliveryExtension>True</DefaultDeliveryExtension>
> <Configuration>
> <RSEmailDPConfiguration>
> <DefaultRenderingExtension>MHTML</DefaultRenderingExtension>
> </RSEmailDPConfiguration>
> </Configuration>
> </Extension>
> <Extension Name="Report Server FileShare"
>
Type="Microsoft.ReportingServices.FileShareDeliveryProvider.FileShareUIContr
> ol,ReportingServicesFileShareDeliveryProvider">
> <Configuration>
> <FileShare>
> <DefaultRenderingExtension>MHTML</DefaultRenderingExtension>
> </FileShare>
> </Configuration>
> </Extension>
> </DeliveryUI>
> </Extensions>
> <Add Key="MaxActiveReqForOneUser" Value="20"/>
> <Add Key="DisplayErrorLink" Value="true"/>
> </Configuration>
> Thanks and Ciao
> Stefano
>|||Stefano is looking the wrong file. Look in the RSReportServer.config file
for the elements that Bruce was mentioning.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Bruce Loehle-Conger" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:uCTlpxoaEHA.1000@.TK2MSFTNGP12.phx.gbl...
> Did you start editing and deleting lines. Yours looks different. For
> instance. I have <Delivery> and you have <DeliveryUI>
> When I went in and manually modified entries for email I did not have to
add
> any lines, I just edited lines that were there.
> Do you have your original file?
> Bruce L-C
> "Steph" <steph@.steph.it> wrote in message
> news:et1NN7naEHA.1152@.TK2MSFTNGP09.phx.gbl...
> > Thanks Bruce,
> > But i have an additional request for you.....where i have to place
those
> > line in the file.
> > My config file is actually done in this way:
> >
> > <Configuration>
> > <UI>
> > <ReportServerUrl>http://SQLLUCEPLAN/ReportServer</ReportServerUrl>
> > </UI>
> > <Extensions>
> > <DeliveryUI>
> > <Extension Name="Report Server Email"
> >
>
Type="Microsoft.ReportingServices.EmailDeliveryProvider.EmailDeliveryProvide
> > rControl,ReportingServicesEmailDeliveryProvider">
> > <DefaultDeliveryExtension>True</DefaultDeliveryExtension>
> > <Configuration>
> > <RSEmailDPConfiguration>
> > <DefaultRenderingExtension>MHTML</DefaultRenderingExtension>
> > </RSEmailDPConfiguration>
> > </Configuration>
> > </Extension>
> > <Extension Name="Report Server FileShare"
> >
>
Type="Microsoft.ReportingServices.FileShareDeliveryProvider.FileShareUIContr
> > ol,ReportingServicesFileShareDeliveryProvider">
> > <Configuration>
> > <FileShare>
> > <DefaultRenderingExtension>MHTML</DefaultRenderingExtension>
> > </FileShare>
> > </Configuration>
> > </Extension>
> > </DeliveryUI>
> > </Extensions>
> > <Add Key="MaxActiveReqForOneUser" Value="20"/>
> > <Add Key="DisplayErrorLink" Value="true"/>
> > </Configuration>
> >
> > Thanks and Ciao
> > Stefano
> >
> >
>|||Ahh. Great. Thanks for jumping in.
Bruce L-C
"Daniel Reib [MSFT]" <danreib@.online.microsoft.com> wrote in message
news:uINrD$oaEHA.752@.TK2MSFTNGP09.phx.gbl...
> Stefano is looking the wrong file. Look in the RSReportServer.config file
> for the elements that Bruce was mentioning.
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no
rights.
>
> "Bruce Loehle-Conger" <bruce_lcNOSPAM@.hotmail.com> wrote in message
> news:uCTlpxoaEHA.1000@.TK2MSFTNGP12.phx.gbl...
> > Did you start editing and deleting lines. Yours looks different. For
> > instance. I have <Delivery> and you have <DeliveryUI>
> >
> > When I went in and manually modified entries for email I did not have to
> add
> > any lines, I just edited lines that were there.
> >
> > Do you have your original file?
> >
> > Bruce L-C
> >
> > "Steph" <steph@.steph.it> wrote in message
> > news:et1NN7naEHA.1152@.TK2MSFTNGP09.phx.gbl...
> > > Thanks Bruce,
> > > But i have an additional request for you.....where i have to place
> those
> > > line in the file.
> > > My config file is actually done in this way:
> > >
> > > <Configuration>
> > > <UI>
> > > <ReportServerUrl>http://SQLLUCEPLAN/ReportServer</ReportServerUrl>
> > > </UI>
> > > <Extensions>
> > > <DeliveryUI>
> > > <Extension Name="Report Server Email"
> > >
> >
>
Type="Microsoft.ReportingServices.EmailDeliveryProvider.EmailDeliveryProvide
> > > rControl,ReportingServicesEmailDeliveryProvider">
> > > <DefaultDeliveryExtension>True</DefaultDeliveryExtension>
> > > <Configuration>
> > > <RSEmailDPConfiguration>
> > > <DefaultRenderingExtension>MHTML</DefaultRenderingExtension>
> > > </RSEmailDPConfiguration>
> > > </Configuration>
> > > </Extension>
> > > <Extension Name="Report Server FileShare"
> > >
> >
>
Type="Microsoft.ReportingServices.FileShareDeliveryProvider.FileShareUIContr
> > > ol,ReportingServicesFileShareDeliveryProvider">
> > > <Configuration>
> > > <FileShare>
> > > <DefaultRenderingExtension>MHTML</DefaultRenderingExtension>
> > > </FileShare>
> > > </Configuration>
> > > </Extension>
> > > </DeliveryUI>
> > > </Extensions>
> > > <Add Key="MaxActiveReqForOneUser" Value="20"/>
> > > <Add Key="DisplayErrorLink" Value="true"/>
> > > </Configuration>
> > >
> > > Thanks and Ciao
> > > Stefano
> > >
> > >
> >
> >
>|||Thanks for your help.
I've done the settings and everything looks good except when you try to
confirm subscription or change the schedule i get an error telling that the
value for the field StartDateTime is not valid for this field. It's
impposible to convert string value in the requested type.
Can you help me again?
Thanks in advance!
Stefano|||Are you doing this from Report Manager? Or are you controlling the
subscription via web services. My suggestion is to first do it from Report
Manager to make sure everything is setup correctly. If this is via web
services then I can't help you, no experience with them.
Bruce L-C
"Steph" <steph@.steph.it> wrote in message
news:ee$VbtxaEHA.3944@.tk2msftngp13.phx.gbl...
> Thanks for your help.
> I've done the settings and everything looks good except when you try to
> confirm subscription or change the schedule i get an error telling that
the
> value for the field StartDateTime is not valid for this field. It's
> impposible to convert string value in the requested type.
> Can you help me again?
> Thanks in advance!
> Stefano
>|||Hi Bruce,
I don't use web services, i do entirely from report manager.
Ciao
Stefano
"Bruce Loehle-Conger" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:OzfAkrzaEHA.2340@.TK2MSFTNGP09.phx.gbl...
> Are you doing this from Report Manager? Or are you controlling the
> subscription via web services. My suggestion is to first do it from Report
> Manager to make sure everything is setup correctly. If this is via web
> services then I can't help you, no experience with them.
> Bruce L-C
> "Steph" <steph@.steph.it> wrote in message
> news:ee$VbtxaEHA.3944@.tk2msftngp13.phx.gbl...
> > Thanks for your help.
> > I've done the settings and everything looks good except when you try to
> > confirm subscription or change the schedule i get an error telling that
> the
> > value for the field StartDateTime is not valid for this field. It's
> > impposible to convert string value in the requested type.
> > Can you help me again?
> > Thanks in advance!
> > Stefano
> >
> >
>|||OK, I was confused. Have you tested the report standalone. This seems to me
to be a report parameter problem. Is the report parameter of date data type
(instead of string)
Bruce L-C
"Steph" <steph@.steph.it> wrote in message
news:uwIP%23zzaEHA.3716@.TK2MSFTNGP11.phx.gbl...
> Hi Bruce,
> I don't use web services, i do entirely from report manager.
> Ciao
> Stefano
> "Bruce Loehle-Conger" <bruce_lcNOSPAM@.hotmail.com> wrote in message
> news:OzfAkrzaEHA.2340@.TK2MSFTNGP09.phx.gbl...
> > Are you doing this from Report Manager? Or are you controlling the
> > subscription via web services. My suggestion is to first do it from
Report
> > Manager to make sure everything is setup correctly. If this is via web
> > services then I can't help you, no experience with them.
> >
> > Bruce L-C
> >
> > "Steph" <steph@.steph.it> wrote in message
> > news:ee$VbtxaEHA.3944@.tk2msftngp13.phx.gbl...
> > > Thanks for your help.
> > > I've done the settings and everything looks good except when you try
to
> > > confirm subscription or change the schedule i get an error telling
that
> > the
> > > value for the field StartDateTime is not valid for this field. It's
> > > impposible to convert string value in the requested type.
> > > Can you help me again?
> > > Thanks in advance!
> > > Stefano
> > >
> > >
> >
> >
>|||It doesn't have any parameter......and it works perfectly!
If can help in your problem solving, before inserting the line to activate
e-mail delivey, cliccking on scheduling to have a schedule for save the
report on disk, scheduling was working perfectly!
"Bruce Loehle-Conger" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:%23EFuri0aEHA.1644@.tk2msftngp13.phx.gbl...
> OK, I was confused. Have you tested the report standalone. This seems to
me
> to be a report parameter problem. Is the report parameter of date data
type
> (instead of string)
> Bruce L-C
> "Steph" <steph@.steph.it> wrote in message
> news:uwIP%23zzaEHA.3716@.TK2MSFTNGP11.phx.gbl...
> > Hi Bruce,
> > I don't use web services, i do entirely from report manager.
> > Ciao
> > Stefano
> >
> > "Bruce Loehle-Conger" <bruce_lcNOSPAM@.hotmail.com> wrote in message
> > news:OzfAkrzaEHA.2340@.TK2MSFTNGP09.phx.gbl...
> > > Are you doing this from Report Manager? Or are you controlling the
> > > subscription via web services. My suggestion is to first do it from
> Report
> > > Manager to make sure everything is setup correctly. If this is via web
> > > services then I can't help you, no experience with them.
> > >
> > > Bruce L-C
> > >
> > > "Steph" <steph@.steph.it> wrote in message
> > > news:ee$VbtxaEHA.3944@.tk2msftngp13.phx.gbl...
> > > > Thanks for your help.
> > > > I've done the settings and everything looks good except when you try
> to
> > > > confirm subscription or change the schedule i get an error telling
> that
> > > the
> > > > value for the field StartDateTime is not valid for this field. It's
> > > > impposible to convert string value in the requested type.
> > > > Can you help me again?
> > > > Thanks in advance!
> > > > Stefano
> > > >
> > > >
> > >
> > >
> >
> >
>