Reporting Services Activation error

I try to activate it by command prompt like so:
C:\Documents and Settings\Administrator>rsactivate -c"C:\Program
Files\Microsoft
SQL Server\MSSQL\Reporting Services\ReportServer\RSReportServer.config"
And I get this for output:
Failure starting the web service:
Unable to connect to the database (-2147159551) 0x80070005
I have looked through every knowledgebase article and have found no answers.
Can anyone help me here?If you get an answer to this question, please let me know, as I am having the same issue. rsahakian1960 at yahoo dot com. Thanks
--
Message posted via http://www.sqlmonster.com

Reporting Services 2000 broke by installing .NET 2.0 redistributable runtime files

We have RS 2000 running in our lab environment where I recently installed the .NET Framework 2.0 Redistributable Package. After installation, reporting services stopped working with the following error:

Security Exception

Description: The application attempted to perform an operation not allowed by the security policy. To grant this application the required permission please contact your system administrator or change the application's trust level in the configuration file.

Exception Details: System.Security.SecurityException: Request for the permission of type 'System.Security.Permissions.SecurityPermission, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed.

I noticed the Version=2.0.0.0 part and went into the IIS properties for the /Reports directory and verified that 1.1 was selected and not 2.0.

Not sure why it appears 2.0 is being referenced when the site should be pointing to 1.1 libraries.

Any ideas would be appreciated.

Make sure you check both virtual folders: /Reports and /ReportServer. When you go to the properties of these virtual folders, go to application configuration and check all script maps. Make sure there's no v2.0 DLLs in the script maps.|||If you are running Windows XP or you have Reporting Services installed in the same application pool as an ASP.NET 2.0 application, then this will happen. You can't run two version of the .NET Framework in the same IIS process.|||I tried both posted solutions and neither worked, although they were good ideas. Both the /Reports and /ReportServer directores have the 1.1 binaries in the Application Mappings tab in IIS. Of interest is the /Reports directory has many application extensions listed and no wildcard maps. The /ReportServer directory has the opposite, no application extensions and one wildcard mapping. Regardless, they all point to 1.1 binaries.

I created a new application pool and put the /Reports and /ReportServer in that pool and am getting the same error.
|||In addition, this event was logged in the Application Events. Still appears to be using the 2.0 libraries yet I don't know why:

Event code: 4010
Event message: An unhandled security exception has occurred.
Event time: 12/1/2005 4:54:28 PM
Event time (UTC): 12/1/2005 9:54:28 PM
Event ID: 37a8c59bd4d14536ac63fdd0b43185d3
Event sequence: 7
Event occurrence: 2
Event detail code: 0
Application information:
Application domain: /LM/W3SVC/1/Root/Reports-1-127779471911380892
Trust level: RosettaMgr
Application Virtual Path: /Reports
Application Path: C:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\ReportManager\
Machine name: TLCB1
Process information:
Process ID: 1864
Process name: w3wp.exe
Account name: NT AUTHORITY\NETWORK SERVICE
Request information:
Request URL: http://tlcb1/reports/Pages/Folder.aspx
Request path: /reports/Pages/Folder.aspx
User host address: 10.125.124.17
User: xxxx\yyyyy
Is authenticated: True
Authentication Type: Negotiate
Thread account name: NT AUTHORITY\NETWORK SERVICE
Custom event details:

For more information, see Help and Support Center at
|||After working with Microsoft support for weeks on this (yes overseas support isn't very expeditious), it turns out it was a problem with a content management ISAPI plugin. The plugin was coded to always run in the context of the latest .net framework version. Since the plugin ran in the default application pool, every app in the default pool then would use the 2.0 framework instead of the 1.1 framework, regardless of what was set for each site.

The solution was to put the content management ISAPI plugin in its own app pool with nothing else. That allow the other apps to use the framework of their specification.
|||

I just updated my Windows 2003 server running Reporting Services 2000 with Net 2.0 and had the same error. I solved it by just selecting the old version 1.1.4 from the ASP.Net settings under the properties tab on IIS. Seems it allows you to select which version to run at each level of a Web/Sub Web. Make sure to select the reportserver and the report sub webs.

Hope this helps.

Tim

|||I had this problem when i've installed MSSQL 2005 and tried to use ReportServer. First I've tried to disable .NET 2.0, but it didn't help. so i uninstalled .net 2.0 and restarted IIS server. it worked. after i've downloaded .net 2.0 from microsoft.com, installed it. Everything works perfect. seems like the .net packege that is distributed with SQL 2005 is broken or something like that.

Reporting Services 2000 broke by installing .NET 2.0 redistributable runtime files

We have RS 2000 running in our lab environment where I recently installed the .NET Framework 2.0 Redistributable Package. After installation, reporting services stopped working with the following error:

Security Exception

Description: The application attempted to perform an operation not allowed by the security policy. To grant this application the required permission please contact your system administrator or change the application's trust level in the configuration file.

Exception Details: System.Security.SecurityException: Request for the permission of type 'System.Security.Permissions.SecurityPermission, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed.

I noticed the Version=2.0.0.0 part and went into the IIS properties for the /Reports directory and verified that 1.1 was selected and not 2.0.

Not sure why it appears 2.0 is being referenced when the site should be pointing to 1.1 libraries.

Any ideas would be appreciated.

Make sure you check both virtual folders: /Reports and /ReportServer. When you go to the properties of these virtual folders, go to application configuration and check all script maps. Make sure there's no v2.0 DLLs in the script maps.|||If you are running Windows XP or you have Reporting Services installed in the same application pool as an ASP.NET 2.0 application, then this will happen. You can't run two version of the .NET Framework in the same IIS process.|||I tried both posted solutions and neither worked, although they were good ideas. Both the /Reports and /ReportServer directores have the 1.1 binaries in the Application Mappings tab in IIS. Of interest is the /Reports directory has many application extensions listed and no wildcard maps. The /ReportServer directory has the opposite, no application extensions and one wildcard mapping. Regardless, they all point to 1.1 binaries.

I created a new application pool and put the /Reports and /ReportServer in that pool and am getting the same error.
|||In addition, this event was logged in the Application Events. Still appears to be using the 2.0 libraries yet I don't know why:

Event code: 4010
Event message: An unhandled security exception has occurred.
Event time: 12/1/2005 4:54:28 PM
Event time (UTC): 12/1/2005 9:54:28 PM
Event ID: 37a8c59bd4d14536ac63fdd0b43185d3
Event sequence: 7
Event occurrence: 2
Event detail code: 0
Application information:
Application domain: /LM/W3SVC/1/Root/Reports-1-127779471911380892
Trust level: RosettaMgr
Application Virtual Path: /Reports
Application Path: C:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\ReportManager\
Machine name: TLCB1
Process information:
Process ID: 1864
Process name: w3wp.exe
Account name: NT AUTHORITY\NETWORK SERVICE
Request information:
Request URL: http://tlcb1/reports/Pages/Folder.aspx
Request path: /reports/Pages/Folder.aspx
User host address: 10.125.124.17
User: xxxx\yyyyy
Is authenticated: True
Authentication Type: Negotiate
Thread account name: NT AUTHORITY\NETWORK SERVICE
Custom event details:

For more information, see Help and Support Center at
|||After working with Microsoft support for weeks on this (yes overseas support isn't very expeditious), it turns out it was a problem with a content management ISAPI plugin. The plugin was coded to always run in the context of the latest .net framework version. Since the plugin ran in the default application pool, every app in the default pool then would use the 2.0 framework instead of the 1.1 framework, regardless of what was set for each site.

The solution was to put the content management ISAPI plugin in its own app pool with nothing else. That allow the other apps to use the framework of their specification.
|||

I just updated my Windows 2003 server running Reporting Services 2000 with Net 2.0 and had the same error. I solved it by just selecting the old version 1.1.4 from the ASP.Net settings under the properties tab on IIS. Seems it allows you to select which version to run at each level of a Web/Sub Web. Make sure to select the reportserver and the report sub webs.

Hope this helps.

Tim

|||I had this problem when i've installed MSSQL 2005 and tried to use ReportServer. First I've tried to disable .NET 2.0, but it didn't help. so i uninstalled .net 2.0 and restarted IIS server. it worked. after i've downloaded .net 2.0 from microsoft.com, installed it. Everything works perfect. seems like the .net packege that is distributed with SQL 2005 is broken or something like that.

Reporting Services 2000 broke by installing .NET 2.0 redistributable runtime files

We have RS 2000 running in our lab environment where I recently installed the .NET Framework 2.0 Redistributable Package. After installation, reporting services stopped working with the following error:

Security Exception

Description: The application attempted to perform an operation not allowed by the security policy. To grant this application the required permission please contact your system administrator or change the application's trust level in the configuration file.

Exception Details: System.Security.SecurityException: Request for the permission of type 'System.Security.Permissions.SecurityPermission, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed.

I noticed the Version=2.0.0.0 part and went into the IIS properties for the /Reports directory and verified that 1.1 was selected and not 2.0.

Not sure why it appears 2.0 is being referenced when the site should be pointing to 1.1 libraries.

Any ideas would be appreciated.

Make sure you check both virtual folders: /Reports and /ReportServer. When you go to the properties of these virtual folders, go to application configuration and check all script maps. Make sure there's no v2.0 DLLs in the script maps.|||If you are running Windows XP or you have Reporting Services installed in the same application pool as an ASP.NET 2.0 application, then this will happen. You can't run two version of the .NET Framework in the same IIS process.|||I tried both posted solutions and neither worked, although they were good ideas. Both the /Reports and /ReportServer directores have the 1.1 binaries in the Application Mappings tab in IIS. Of interest is the /Reports directory has many application extensions listed and no wildcard maps. The /ReportServer directory has the opposite, no application extensions and one wildcard mapping. Regardless, they all point to 1.1 binaries.

I created a new application pool and put the /Reports and /ReportServer in that pool and am getting the same error.
|||In addition, this event was logged in the Application Events. Still appears to be using the 2.0 libraries yet I don't know why:

Event code: 4010
Event message: An unhandled security exception has occurred.
Event time: 12/1/2005 4:54:28 PM
Event time (UTC): 12/1/2005 9:54:28 PM
Event ID: 37a8c59bd4d14536ac63fdd0b43185d3
Event sequence: 7
Event occurrence: 2
Event detail code: 0
Application information:
Application domain: /LM/W3SVC/1/Root/Reports-1-127779471911380892
Trust level: RosettaMgr
Application Virtual Path: /Reports
Application Path: C:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\ReportManager\
Machine name: TLCB1
Process information:
Process ID: 1864
Process name: w3wp.exe
Account name: NT AUTHORITY\NETWORK SERVICE
Request information:
Request URL: http://tlcb1/reports/Pages/Folder.aspx
Request path: /reports/Pages/Folder.aspx
User host address: 10.125.124.17
User: xxxx\yyyyy
Is authenticated: True
Authentication Type: Negotiate
Thread account name: NT AUTHORITY\NETWORK SERVICE
Custom event details:

For more information, see Help and Support Center at
|||After working with Microsoft support for weeks on this (yes overseas support isn't very expeditious), it turns out it was a problem with a content management ISAPI plugin. The plugin was coded to always run in the context of the latest .net framework version. Since the plugin ran in the default application pool, every app in the default pool then would use the 2.0 framework instead of the 1.1 framework, regardless of what was set for each site.

The solution was to put the content management ISAPI plugin in its own app pool with nothing else. That allow the other apps to use the framework of their specification.
|||

I just updated my Windows 2003 server running Reporting Services 2000 with Net 2.0 and had the same error. I solved it by just selecting the old version 1.1.4 from the ASP.Net settings under the properties tab on IIS. Seems it allows you to select which version to run at each level of a Web/Sub Web. Make sure to select the reportserver and the report sub webs.

Hope this helps.

Tim

|||I had this problem when i've installed MSSQL 2005 and tried to use ReportServer. First I've tried to disable .NET 2.0, but it didn't help. so i uninstalled .net 2.0 and restarted IIS server. it worked. after i've downloaded .net 2.0 from microsoft.com, installed it. Everything works perfect. seems like the .net packege that is distributed with SQL 2005 is broken or something like that.

Reporting Services

when I try to access reporting services from my web browser I get a page ind
icating that there is an internal error, from the log files the best I can f
ind is
"aspnet_wp!library!bc8!07/19/2004-15:20:04:: e ERROR: Throwing Microsoft.Rep
ortingServices.Diagnostics.Utilities.InternalCatalogException: An internal e
rror occurred on the report server. See the error log for more details., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogExcep
tion: An internal error occurred on the report server. See the error log for
more details. --> System.Runtime.InteropServices.COMException (0x80090024)
: The profile for the user
is a temporary profile."
I cannot locate the Error Log in question, any ideas on how I can figure thi
s out?I am having the same problem. Please post the solution here if you find it,
and I'll do the same.
Thanks,
Corey

Reporting Services

when I try to access reporting services from my web browser I get a page indicating that there is an internal error, from the log files the best I can find is
"aspnet_wp!library!bc8!07/19/2004-15:20:04:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities. InternalCatalogException: An internal error occurred on the report server. See the error log for more details., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities. InternalCatalogException: An internal error occurred on the report server. See the error log for more details. --> System.Runtime.InteropServices.COMException (0x80090024): The profile for the user
is a temporary profile."
I cannot locate the Error Log in question, any ideas on how I can figure this out?
I am having the same problem. Please post the solution here if you find it, and I'll do the same.
Thanks,
Corey

reporting service install help files only

Hi,
I am trying to install reporting services on windows 2003 server, everytime
it only installs help files. there are no virtual directories and nothing in
IIS at all.
there is no log file, no error messages...install runs ithout even
prompting for the settings such as sql server etc....install just runs and
after few minutes says it is finished.
what can be causing this.
thanks
K DhariwalI had this problem some months ago, when someone only installed Books
Online and not the whole Reporting Services 2000 package as planned. In
the end, I had to uninstall everything, reboot the server, and then
start the installation again.
If you're installing Reporting Services 2000 version:
Start your Reporting Services installation setup. When you're asked if
you want to repair/modify or uninstall, choose uninstall. This should
clean up most of it. Boot and start setup. See if there's anything
missing. If IIS (Internet Information Services) or .NET framework is
missing, you need to install these first, before continuing with the
installation. IIS can be installed by opening "Add/remove programs",
click on "Add/remove Windows Components" and adding it from the
Application Server menu.
Read more at http://support.microsoft.com/kb/324742/en-us
If the installation wizard says that Visual Studio is missing, you can
continue, if you're installing this on a server not used for developing
reports.
This should send you on the right track to install Reporting Services
properly.
Kaisa M. Lindahl|||Hello,
I ran the install file to remove sql reporting services. funny enough
install setup ran and tried to install reporting services and at the end it
says installation successful. then i removed it from add/remove programs and
rebooted the server. made sure all required components are there. install
reporting services, same issue. no prompts for sql server specification
server componenets etc.
i have done quite a few installations of sql reporting services and never
had funny program like this. worst part is that it is not even producing
error message. there is no log file to look at. only thing which is there is
the help file [bunch of html files etc.]
thanks in advance
k dhariwal
"Kaisa M. Lindahl" wrote:
> I had this problem some months ago, when someone only installed Books
> Online and not the whole Reporting Services 2000 package as planned. In
> the end, I had to uninstall everything, reboot the server, and then
> start the installation again.
> If you're installing Reporting Services 2000 version:
> Start your Reporting Services installation setup. When you're asked if
> you want to repair/modify or uninstall, choose uninstall. This should
> clean up most of it. Boot and start setup. See if there's anything
> missing. If IIS (Internet Information Services) or .NET framework is
> missing, you need to install these first, before continuing with the
> installation. IIS can be installed by opening "Add/remove programs",
> click on "Add/remove Windows Components" and adding it from the
> Application Server menu.
> Read more at http://support.microsoft.com/kb/324742/en-us
> If the installation wizard says that Visual Studio is missing, you can
> continue, if you're installing this on a server not used for developing
> reports.
> This should send you on the right track to install Reporting Services
> properly.
> Kaisa M. Lindahl
>|||Hello,
I'm with same problem, you can help-me?
Clayton Cardozo
"K M Dhariwal" wrote:
> Hello,
> I ran the install file to remove sql reporting services. funny enough
> install setup ran and tried to install reporting services and at the end it
> says installation successful. then i removed it from add/remove programs and
> rebooted the server. made sure all required components are there. install
> reporting services, same issue. no prompts for sql server specification
> server componenets etc.
> i have done quite a few installations of sql reporting services and never
> had funny program like this. worst part is that it is not even producing
> error message. there is no log file to look at. only thing which is there is
> the help file [bunch of html files etc.]
> thanks in advance
> k dhariwal
> "Kaisa M. Lindahl" wrote:
> > I had this problem some months ago, when someone only installed Books
> > Online and not the whole Reporting Services 2000 package as planned. In
> > the end, I had to uninstall everything, reboot the server, and then
> > start the installation again.
> >
> > If you're installing Reporting Services 2000 version:
> > Start your Reporting Services installation setup. When you're asked if
> > you want to repair/modify or uninstall, choose uninstall. This should
> > clean up most of it. Boot and start setup. See if there's anything
> > missing. If IIS (Internet Information Services) or .NET framework is
> > missing, you need to install these first, before continuing with the
> > installation. IIS can be installed by opening "Add/remove programs",
> > click on "Add/remove Windows Components" and adding it from the
> > Application Server menu.
> > Read more at http://support.microsoft.com/kb/324742/en-us
> >
> > If the installation wizard says that Visual Studio is missing, you can
> > continue, if you're installing this on a server not used for developing
> > reports.
> >
> > This should send you on the right track to install Reporting Services
> > properly.
> >
> > Kaisa M. Lindahl
> >
> >

Reporting Server Log

Is it possible to write out messages to the reporting server log files? If so, a sample code would be greatly appreciated.
Thanks,
AlexNo this is not possible.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Alex Munk" <AlexMunk@.discussions.microsoft.com> wrote in message
news:3FB8FD99-2355-42B4-895A-9F17FA737E64@.microsoft.com...
> Is it possible to write out messages to the reporting server log files? If
so, a sample code would be greatly appreciated.
> Thanks,
> Alex

Reporting Log Problem

Every so often I find reporting services logs (C:\Program Files\Microsoft SQL
Server\MSSQL\Reporting Services\LogFiles) in excess of 33 mb. For example
there are 135 log files from today with the name similar to
ReportServerService__05_19_2005_09_11_25.log and are all between 33 and 34 mb
in size. I only use reporting services for MOM 2005 reporting. What are
these logs for and can they be deleted without causing problems?
Thank you,
KevinThis is a known issue (Bug #: 304241 -
http://support.microsoft.com/kb/885286/) and is fixed in Reporting Services
SP2
http://www.microsoft.com/downloads/details.aspx?FamilyID=502C0D89-1308-4662-8F58-CEC55EF1235B&displaylang=en
--
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Kevin" <Kevin@.discussions.microsoft.com> wrote in message
news:7E421675-8157-49BC-9557-CE04152CD77C@.microsoft.com...
> Every so often I find reporting services logs (C:\Program Files\Microsoft
> SQL
> Server\MSSQL\Reporting Services\LogFiles) in excess of 33 mb. For example
> there are 135 log files from today with the name similar to
> ReportServerService__05_19_2005_09_11_25.log and are all between 33 and 34
> mb
> in size. I only use reporting services for MOM 2005 reporting. What are
> these logs for and can they be deleted without causing problems?
> Thank you,
> Kevin|||thank you! Can I delete these logs?
"Jasper Smith" wrote:
> This is a known issue (Bug #: 304241 -
> http://support.microsoft.com/kb/885286/) and is fixed in Reporting Services
> SP2
> http://www.microsoft.com/downloads/details.aspx?FamilyID=502C0D89-1308-4662-8F58-CEC55EF1235B&displaylang=en
> --
> HTH
> Jasper Smith (SQL Server MVP)
> http://www.sqldbatips.com
> I support PASS - the definitive, global
> community for SQL Server professionals -
> http://www.sqlpass.org
> "Kevin" <Kevin@.discussions.microsoft.com> wrote in message
> news:7E421675-8157-49BC-9557-CE04152CD77C@.microsoft.com...
> > Every so often I find reporting services logs (C:\Program Files\Microsoft
> > SQL
> > Server\MSSQL\Reporting Services\LogFiles) in excess of 33 mb. For example
> > there are 135 log files from today with the name similar to
> > ReportServerService__05_19_2005_09_11_25.log and are all between 33 and 34
> > mb
> > in size. I only use reporting services for MOM 2005 reporting. What are
> > these logs for and can they be deleted without causing problems?
> >
> > Thank you,
> >
> > Kevin
>
>|||Yes, technically the logs can be deleted w/out affecting RS.
--
Adrian M.
MCP
"Kevin" <Kevin@.discussions.microsoft.com> wrote in message
news:3FB18D84-1D41-483E-AA2D-FDB9A0519FC9@.microsoft.com...
> thank you! Can I delete these logs?
> "Jasper Smith" wrote:
>> This is a known issue (Bug #: 304241 -
>> http://support.microsoft.com/kb/885286/) and is fixed in Reporting
>> Services
>> SP2
>> http://www.microsoft.com/downloads/details.aspx?FamilyID=502C0D89-1308-4662-8F58-CEC55EF1235B&displaylang=en
>> --
>> HTH
>> Jasper Smith (SQL Server MVP)
>> http://www.sqldbatips.com
>> I support PASS - the definitive, global
>> community for SQL Server professionals -
>> http://www.sqlpass.org
>> "Kevin" <Kevin@.discussions.microsoft.com> wrote in message
>> news:7E421675-8157-49BC-9557-CE04152CD77C@.microsoft.com...
>> > Every so often I find reporting services logs (C:\Program
>> > Files\Microsoft
>> > SQL
>> > Server\MSSQL\Reporting Services\LogFiles) in excess of 33 mb. For
>> > example
>> > there are 135 log files from today with the name similar to
>> > ReportServerService__05_19_2005_09_11_25.log and are all between 33 and
>> > 34
>> > mb
>> > in size. I only use reporting services for MOM 2005 reporting. What
>> > are
>> > these logs for and can they be deleted without causing problems?
>> >
>> > Thank you,
>> >
>> > Kevin
>>