RS and HTTPS: controller

I got 4 computers, all connected to a domain controller. I got one instance
of standard report server running OK on the W2k domain controller. On my
other 3 machines I installed one local copy of report server developper
edition together with VS 2003( I develop different projects on different
machines, its a good way I think to keep em clearly separated and have one
portable for demos). Anyway, problem is that after doing a successfull
install on all three machines when I start report server I can't access the
server On all of the 3 client computers I have the report server databases
and web sites installed locally in the local inetpub folders. I log in as a
domain adminisitrator and I gave Iwam_machineName full rights to the the
local bin folders. The aspent_wp.exe service is running locally under the
local system account. In spite of all of this I always get.
Server Error in '/Reports' Application.
----
Access to the path "C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
Services\ReportManager\bin" is denied.
Description: An unhandled exception occurred during the execution of the
current web request. Please review the stack trace for more information
about the error and where it originated in the code.
Exception Details: System.UnauthorizedAccessException: Access to the path
"C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
Services\ReportManager\bin" is denied.
ASP.NET is not authorized to access the requested resource. Consider
granting access rights to the resource to the ASP.NET request identity.
ASP.NET has a base process identity (typically {MACHINE}\ASPNET on IIS 5 or
Network Service on IIS 6) that is used if the application is not
impersonating. If the application is impersonating via <identity
impersonate="true"/>, the identity will be the anonymous user (typically
IUSR_MACHINENAME) or the authenticated request user.
To grant ASP.NET write access to a file, right-click the file in Explorer,
choose "Properties" and select the Security tab. Click "Add" to add the
appropriate user or group. Highlight the ASP.NET account, and check the
boxes for the desired access.
Source Error:
An unhandled exception was generated during the execution of the
current web request. Information regarding the origin and location of the
exception can be identified using the exception stack trace below.
Stack Trace:
[UnauthorizedAccessException: Access to the path "C:\Program Files\Microsoft
SQL Server\MSSQL\Reporting Services\ReportManager\bin" is denied.]
System.IO.__Error.WinIOError(Int32 errorCode, String str) +393
System.IO.Directory.InternalGetFileDirectoryNames(String fullPath, String
userPath, Boolean file) +229
System.IO.Directory.InternalGetDirectories(String path, String userPath,
String searchPattern) +24
System.IO.Directory.GetDirectories(String path, String searchPattern)
+477
Microsoft.ReportingServices.Diagnostics.Localization.GetInstalledCultures()
Microsoft.ReportingServices.Diagnostics.Localization..cctor()
[TypeInitializationException: The type initializer for
"Microsoft.ReportingServices.Diagnostics.Localization" threw an exception.]
Microsoft.ReportingServices.Diagnostics.Localization.SetCultureFromPriorityList(String[]
localeList) +0
Microsoft.ReportingServices.UI.GlobalApp.Application_BeginRequest(Object
sender, EventArgs e)
System.Web.SyncEventExecutionStep.System.Web.HttpApplication+IExecutionStep.Execute()
+60
System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean&
completedSynchronously) +87
----
Version Information: Microsoft .NET Framework Version:1.1.4322.2032; ASP.NET
Version:1.1.4322.2032
I can successfully access the report server on the server computer using
my internet explorer, but never any of the local report server instances. I
have exactly the identical problem at a customer site where I installed
report services on their sql server, following the steps outlined in the ms
docs.
I also think that if I try to run a webservice locally o an of these
machines it will fail with essentially the same message, going to try that
next using the ms samples on my laptop, will keep you posted. Something is
amiss. Has anyone had similar experioences and how did you fix them.
Thanks for any help.
BobJust started the ms sample Async web service on my laptop, that works OK. I
thinkthe problem lies in the security configuration section of the web.
config file but I don't know what to change so that I keep the normal
secirity functionality of the application.
Help, help, help :-(
Bob
"Bob" <bdufour@.sgiims.com> wrote in message
news:%23oiyUjttFHA.2328@.TK2MSFTNGP10.phx.gbl...
>I got 4 computers, all connected to a domain controller. I got one instance
>of standard report server running OK on the W2k domain controller. On my
>other 3 machines I installed one local copy of report server developper
>edition together with VS 2003( I develop different projects on different
>machines, its a good way I think to keep em clearly separated and have one
>portable for demos). Anyway, problem is that after doing a successfull
>install on all three machines when I start report server I can't access the
>server On all of the 3 client computers I have the report server databases
>and web sites installed locally in the local inetpub folders. I log in as a
>domain adminisitrator and I gave Iwam_machineName full rights to the the
>local bin folders. The aspent_wp.exe service is running locally under the
>local system account. In spite of all of this I always get.
>
> Server Error in '/Reports' Application.
> ----
> Access to the path "C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
> Services\ReportManager\bin" is denied.
> Description: An unhandled exception occurred during the execution of the
> current web request. Please review the stack trace for more information
> about the error and where it originated in the code.
> Exception Details: System.UnauthorizedAccessException: Access to the path
> "C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
> Services\ReportManager\bin" is denied.
> ASP.NET is not authorized to access the requested resource. Consider
> granting access rights to the resource to the ASP.NET request identity.
> ASP.NET has a base process identity (typically {MACHINE}\ASPNET on IIS 5
> or Network Service on IIS 6) that is used if the application is not
> impersonating. If the application is impersonating via <identity
> impersonate="true"/>, the identity will be the anonymous user (typically
> IUSR_MACHINENAME) or the authenticated request user.
> To grant ASP.NET write access to a file, right-click the file in Explorer,
> choose "Properties" and select the Security tab. Click "Add" to add the
> appropriate user or group. Highlight the ASP.NET account, and check the
> boxes for the desired access.
> Source Error:
> An unhandled exception was generated during the execution of the
> current web request. Information regarding the origin and location of the
> exception can be identified using the exception stack trace below.
> Stack Trace:
> [UnauthorizedAccessException: Access to the path "C:\Program
> Files\Microsoft SQL Server\MSSQL\Reporting Services\ReportManager\bin" is
> denied.]
> System.IO.__Error.WinIOError(Int32 errorCode, String str) +393
> System.IO.Directory.InternalGetFileDirectoryNames(String fullPath,
> String userPath, Boolean file) +229
> System.IO.Directory.InternalGetDirectories(String path, String userPath,
> String searchPattern) +24
> System.IO.Directory.GetDirectories(String path, String searchPattern)
> +477
> Microsoft.ReportingServices.Diagnostics.Localization.GetInstalledCultures()
> Microsoft.ReportingServices.Diagnostics.Localization..cctor()
> [TypeInitializationException: The type initializer for
> "Microsoft.ReportingServices.Diagnostics.Localization" threw an
> exception.]
> Microsoft.ReportingServices.Diagnostics.Localization.SetCultureFromPriorityList(String[]
> localeList) +0
> Microsoft.ReportingServices.UI.GlobalApp.Application_BeginRequest(Object
> sender, EventArgs e)
> System.Web.SyncEventExecutionStep.System.Web.HttpApplication+IExecutionStep.Execute()
> +60
> System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean&
> completedSynchronously) +87
>
> ----
> Version Information: Microsoft .NET Framework Version:1.1.4322.2032;
> ASP.NET Version:1.1.4322.2032
> I can successfully access the report server on the server computer using
> my internet explorer, but never any of the local report server instances.
> I have exactly the identical problem at a customer site where I installed
> report services on their sql server, following the steps outlined in the
> ms docs.
> I also think that if I try to run a webservice locally o an of these
> machines it will fail with essentially the same message, going to try that
> next using the ms samples on my laptop, will keep you posted. Something is
> amiss. Has anyone had similar experioences and how did you fix them.
> Thanks for any help.
> Bob
>|||Further Info: Te docs says to give permissions to the account
Iwam_MachineName, but because we are on a domain controller the only ASPNET
account that I can find is IWAM_DomainName.
I give that account rights to either the default internet root folder or to
the bin folder of the reportserver. It still does not work.
Bob, help , you don't wanna see a grown man cry :-(
"Bob" <bdufour@.sgiims.com> wrote in message
news:eXLRKtttFHA.3792@.TK2MSFTNGP10.phx.gbl...
> Just started the ms sample Async web service on my laptop, that works OK.
> I thinkthe problem lies in the security configuration section of the web.
> config file but I don't know what to change so that I keep the normal
> secirity functionality of the application.
> Help, help, help :-(
> Bob
> "Bob" <bdufour@.sgiims.com> wrote in message
> news:%23oiyUjttFHA.2328@.TK2MSFTNGP10.phx.gbl...
>>I got 4 computers, all connected to a domain controller. I got one
>>instance of standard report server running OK on the W2k domain
>>controller. On my other 3 machines I installed one local copy of report
>>server developper edition together with VS 2003( I develop different
>>projects on different machines, its a good way I think to keep em clearly
>>separated and have one portable for demos). Anyway, problem is that after
>>doing a successfull install on all three machines when I start report
>>server I can't access the server On all of the 3 client computers I have
>>the report server databases and web sites installed locally in the local
>>inetpub folders. I log in as a domain adminisitrator and I gave
>>Iwam_machineName full rights to the the local bin folders. The
>>aspent_wp.exe service is running locally under the local system account.
>>In spite of all of this I always get.
>>
>> Server Error in '/Reports' Application.
>> ----
>> Access to the path "C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
>> Services\ReportManager\bin" is denied.
>> Description: An unhandled exception occurred during the execution of the
>> current web request. Please review the stack trace for more information
>> about the error and where it originated in the code.
>> Exception Details: System.UnauthorizedAccessException: Access to the path
>> "C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
>> Services\ReportManager\bin" is denied.
>> ASP.NET is not authorized to access the requested resource. Consider
>> granting access rights to the resource to the ASP.NET request identity.
>> ASP.NET has a base process identity (typically {MACHINE}\ASPNET on IIS 5
>> or Network Service on IIS 6) that is used if the application is not
>> impersonating. If the application is impersonating via <identity
>> impersonate="true"/>, the identity will be the anonymous user (typically
>> IUSR_MACHINENAME) or the authenticated request user.
>> To grant ASP.NET write access to a file, right-click the file in
>> Explorer, choose "Properties" and select the Security tab. Click "Add" to
>> add the appropriate user or group. Highlight the ASP.NET account, and
>> check the boxes for the desired access.
>> Source Error:
>> An unhandled exception was generated during the execution of the
>> current web request. Information regarding the origin and location of the
>> exception can be identified using the exception stack trace below.
>> Stack Trace:
>> [UnauthorizedAccessException: Access to the path "C:\Program
>> Files\Microsoft SQL Server\MSSQL\Reporting Services\ReportManager\bin" is
>> denied.]
>> System.IO.__Error.WinIOError(Int32 errorCode, String str) +393
>> System.IO.Directory.InternalGetFileDirectoryNames(String fullPath,
>> String userPath, Boolean file) +229
>> System.IO.Directory.InternalGetDirectories(String path, String
>> userPath, String searchPattern) +24
>> System.IO.Directory.GetDirectories(String path, String searchPattern)
>> +477
>> Microsoft.ReportingServices.Diagnostics.Localization.GetInstalledCultures()
>> Microsoft.ReportingServices.Diagnostics.Localization..cctor()
>> [TypeInitializationException: The type initializer for
>> "Microsoft.ReportingServices.Diagnostics.Localization" threw an
>> exception.]
>> Microsoft.ReportingServices.Diagnostics.Localization.SetCultureFromPriorityList(String[]
>> localeList) +0
>> Microsoft.ReportingServices.UI.GlobalApp.Application_BeginRequest(Object
>> sender, EventArgs e)
>> System.Web.SyncEventExecutionStep.System.Web.HttpApplication+IExecutionStep.Execute()
>> +60
>> System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean&
>> completedSynchronously) +87
>>
>> ----
>> Version Information: Microsoft .NET Framework Version:1.1.4322.2032;
>> ASP.NET Version:1.1.4322.2032
>> I can successfully access the report server on the server computer
>> using my internet explorer, but never any of the local report server
>> instances. I have exactly the identical problem at a customer site where
>> I installed report services on their sql server, following the steps
>> outlined in the ms docs.
>> I also think that if I try to run a webservice locally o an of these
>> machines it will fail with essentially the same message, going to try
>> that next using the ms samples on my laptop, will keep you posted.
>> Something is amiss. Has anyone had similar experioences and how did you
>> fix them.
>> Thanks for any help.
>> Bob
>

I have RS installed on Win 2003 (not domain controller) and SQL server/AS on
a Win 2000 machine. I have no problem openning the report locally through IE
on the RS machine (Win 2003). However, I could not open the same report from
client machines (XP professional, Win 2000). The error message says "An error
has occurred during report processing. (rsProcessingAborted) Get Online Help
Cannot create a connection to data source 'DataSourceName'.
(rsErrorOpeningConnection) Get Online Help
Database 'DatabaseName' does not exist. ".
If I pulish the same report to RS on a Win 2000 machines, I don't have any
problem to open the report from any of client machines. I guess it might
related to credentials not being passed correctly. What kind of configurate I
need on a Win 2003 machine.
Thanks.It is a security issue. IIS user on Win 2003 needs to be a member of OLAP
admins.
Regards,
Cem Demircioglu
"BBH" <BBH@.discussions.microsoft.com> wrote in message
news:13B92E7D-C230-4C94-94C2-65C9411FA1F0@.microsoft.com...
>I have RS installed on Win 2003 (not domain controller) and SQL server/AS
>on
> a Win 2000 machine. I have no problem openning the report locally through
> IE
> on the RS machine (Win 2003). However, I could not open the same report
> from
> client machines (XP professional, Win 2000). The error message says "An
> error
> has occurred during report processing. (rsProcessingAborted) Get Online
> Help
> Cannot create a connection to data source 'DataSourceName'.
> (rsErrorOpeningConnection) Get Online Help
> Database 'DatabaseName' does not exist. ".
> If I pulish the same report to RS on a Win 2000 machines, I don't have any
> problem to open the report from any of client machines. I guess it might
> related to credentials not being passed correctly. What kind of
> configurate I
> need on a Win 2003 machine.
> Thanks.
>|||Thanks fro your reply. Are you referring to the service account which starts
the IIS?
"Cem Demircioglu" wrote:
> It is a security issue. IIS user on Win 2003 needs to be a member of OLAP
> admins.
> Regards,
> Cem Demircioglu
>
> "BBH" <BBH@.discussions.microsoft.com> wrote in message
> news:13B92E7D-C230-4C94-94C2-65C9411FA1F0@.microsoft.com...
> >I have RS installed on Win 2003 (not domain controller) and SQL server/AS
> >on
> > a Win 2000 machine. I have no problem openning the report locally through
> > IE
> > on the RS machine (Win 2003). However, I could not open the same report
> > from
> > client machines (XP professional, Win 2000). The error message says "An
> > error
> > has occurred during report processing. (rsProcessingAborted) Get Online
> > Help
> > Cannot create a connection to data source 'DataSourceName'.
> > (rsErrorOpeningConnection) Get Online Help
> > Database 'DatabaseName' does not exist. ".
> >
> > If I pulish the same report to RS on a Win 2000 machines, I don't have any
> > problem to open the report from any of client machines. I guess it might
> > related to credentials not being passed correctly. What kind of
> > configurate I
> > need on a Win 2003 machine.
> >
> > Thanks.
> >
>
>|||I can't remember the account name but it is either IIS (IUSR*) or Report
Server account (NT Authority\Network Service). You can test it by granting
read access to everyone.
Analysis Manager > XYZ Cube > Database Roles > New ... > Membership:
Everyone
Use Windows NT integrated security on the server while creating the data
source.
Hope this helps.
Regards,
Cem Demircioglu
"BBH" <BBH@.discussions.microsoft.com> wrote in message
news:BB12FAB7-F3CE-42D8-8CD4-F3F707A0A0FF@.microsoft.com...
> Thanks fro your reply. Are you referring to the service account which
> starts
> the IIS?
> "Cem Demircioglu" wrote:
>> It is a security issue. IIS user on Win 2003 needs to be a member of OLAP
>> admins.
>> Regards,
>> Cem Demircioglu
>>
>> "BBH" <BBH@.discussions.microsoft.com> wrote in message
>> news:13B92E7D-C230-4C94-94C2-65C9411FA1F0@.microsoft.com...
>> >I have RS installed on Win 2003 (not domain controller) and SQL
>> >server/AS
>> >on
>> > a Win 2000 machine. I have no problem openning the report locally
>> > through
>> > IE
>> > on the RS machine (Win 2003). However, I could not open the same report
>> > from
>> > client machines (XP professional, Win 2000). The error message says "An
>> > error
>> > has occurred during report processing. (rsProcessingAborted) Get Online
>> > Help
>> > Cannot create a connection to data source 'DataSourceName'.
>> > (rsErrorOpeningConnection) Get Online Help
>> > Database 'DatabaseName' does not exist. ".
>> >
>> > If I pulish the same report to RS on a Win 2000 machines, I don't have
>> > any
>> > problem to open the report from any of client machines. I guess it
>> > might
>> > related to credentials not being passed correctly. What kind of
>> > configurate I
>> > need on a Win 2003 machine.
>> >
>> > Thanks.
>> >
>>

Monday, March 12, 2012

rs won't start

Friday, March 9, 2012

RS on Win2003 cannot connect to Analysis Service

Wednesday, March 7, 2012

RS installation trouble on the server

RS and HTTPS

Blog Archive

About Me