RS2005 configuration problem ASPNET account and DBs

Hi all,
I have instaled SQL Server 2005 on my W2K SP4 machine. When I go to RS
configuration I get problems in two areas. First under "Web Service
Identity" no account is listed. ASPNET account is set up on my machine
correctly. Second, under "Database Setup" I can't set up dbs. When I
click "New" and create ReportServer db and then click "Apply" I get an
error that says something like "Virtual Directories have to be crated
first." Under IIS I have ReportServer and Reports directories.
What may be the problem?
Thanks,
StanHi, Stan
just for fun...try running the command line tool "aspnet_regiis -i"
(you can get to it from the VS.NET Command Prompt, or by opening a
regular cmd window and browsing to
c:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\)
Once that's run, open your IIS Manager, and check the virtual
directories for Reports and ReportServer web apps. Make sure that they
are running and that the .net mappings are setup appropriately in the
Configuration... > Mappings tab, and also check the security for those
2 folders (use windows auth).
Then try running the RS2005 config tool again, and setup the virtual
directories and apply changes before moving along the different steps
in the tool.
Hope that works.
Regards,
Thiago Silva
MCAD.NET
suslikovich wrote:
> Hi all,
> I have instaled SQL Server 2005 on my W2K SP4 machine. When I go to RS
> configuration I get problems in two areas. First under "Web Service
> Identity" no account is listed. ASPNET account is set up on my machine
> correctly. Second, under "Database Setup" I can't set up dbs. When I
> click "New" and create ReportServer db and then click "Apply" I get an
> error that says something like "Virtual Directories have to be crated
> first." Under IIS I have ReportServer and Reports directories.
> What may be the problem?
> Thanks,
> Stan|||Hi Thiago,
Thanks for the quick reply. I forgot to mention I ran 'aspnet_regiis
-i' but I need to look at othet things you mentioned about mappings and
security. I will do that tonight.
Thanks again,
Stan
tafs7 wrote:
> Hi, Stan
> just for fun...try running the command line tool "aspnet_regiis -i"
> (you can get to it from the VS.NET Command Prompt, or by opening a
> regular cmd window and browsing to
> c:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\)
> Once that's run, open your IIS Manager, and check the virtual
> directories for Reports and ReportServer web apps. Make sure that they
> are running and that the .net mappings are setup appropriately in the
> Configuration... > Mappings tab, and also check the security for those
> 2 folders (use windows auth).
> Then try running the RS2005 config tool again, and setup the virtual
> directories and apply changes before moving along the different steps
> in the tool.
> Hope that works.
> Regards,
> Thiago Silva
> MCAD.NET
> suslikovich wrote:
> > Hi all,
> > I have instaled SQL Server 2005 on my W2K SP4 machine. When I go to RS
> > configuration I get problems in two areas. First under "Web Service
> > Identity" no account is listed. ASPNET account is set up on my machine
> > correctly. Second, under "Database Setup" I can't set up dbs. When I
> > click "New" and create ReportServer db and then click "Apply" I get an
> > error that says something like "Virtual Directories have to be crated
> > first." Under IIS I have ReportServer and Reports directories.
> > What may be the problem?
> >
> > Thanks,
> >
> > Stan|||I did "aspnet_regiis -i" once again. Looked at IIS directories.
Mappings look ok. I am quite puzzled about where to check
authentication. In any case, the problem remains. Any other
suggestions?
Thanks,
Stan
suslikovich wrote:
> Hi Thiago,
> Thanks for the quick reply. I forgot to mention I ran 'aspnet_regiis
> -i' but I need to look at othet things you mentioned about mappings and
> security. I will do that tonight.
> Thanks again,
> Stan
> tafs7 wrote:
> > Hi, Stan
> >
> > just for fun...try running the command line tool "aspnet_regiis -i"
> > (you can get to it from the VS.NET Command Prompt, or by opening a
> > regular cmd window and browsing to
> > c:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\)
> >
> > Once that's run, open your IIS Manager, and check the virtual
> > directories for Reports and ReportServer web apps. Make sure that they
> > are running and that the .net mappings are setup appropriately in the
> > Configuration... > Mappings tab, and also check the security for those
> > 2 folders (use windows auth).
> >
> > Then try running the RS2005 config tool again, and setup the virtual
> > directories and apply changes before moving along the different steps
> > in the tool.
> >
> > Hope that works.
> >
> > Regards,
> > Thiago Silva
> > MCAD.NET
> >
> > suslikovich wrote:
> > > Hi all,
> > > I have instaled SQL Server 2005 on my W2K SP4 machine. When I go to RS
> > > configuration I get problems in two areas. First under "Web Service
> > > Identity" no account is listed. ASPNET account is set up on my machine
> > > correctly. Second, under "Database Setup" I can't set up dbs. When I
> > > click "New" and create ReportServer db and then click "Apply" I get an
> > > error that says something like "Virtual Directories have to be crated
> > > first." Under IIS I have ReportServer and Reports directories.
> > > What may be the problem?
> > >
> > > Thanks,
> > >
> > > Stansql

rs won't start

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
>

RS Installation

Hi,
When I install RS on my W2K/SP4/IIS 5.0/SQL2K EE server, I got a msg at the
end of my installation that I must Initialize RS. I looked up and found
that I have to run RSACTIVATE with the -c option. When I did that via a CMD
prompt, I got:
"Failure Starting the web service:
The Report Server Web service has not generated a public key"
Anyone help me on this one?
Thanks,
SteveHey Steve,
yeah I had the similar problem on one of the servers. One thing you might
try to do is to export whatever keys there are in db (usually normal
behaving server has 3 keys, one is all nulls, but in your case there might
be only one non-null key. To check, go to MSRS db called Keys) and then
delete them from db and reapply the keys. All is done with rskeymgmt
utility. However I am not sure if this is going to work for you, it worked
on one of my machines and didn't on another. Check the help on key
management as well (i know the help docs suck right now, but still ...)
REMEMBER: this might completely screw your installation up and you will have
to reinstall. So i am not responsible for any damages