RS and HTTPS: run

Showing posts with label run. Show all posts

Friday, March 30, 2012

rsInternalError (RSClientCOnnection.GetProperties)

Hello,

We are converting from 2000 to 2005 and are getting the following error when attempting to run any RS reports. Any help would be greatly appreciated.

************** Exception Text **************

Microsoft.SqlServer.ReportingServices2005.ReportServiceDetailsException:

An internal error occurred on the report server. See the error log for more details. (rsInternalError) >

Microsoft.SqlServer.ReportingServices2005.ReportServiceMoreInformationException:

An internal error occurred on the report server. See the error log for more details. (rsInternalError)

End of inner exception stack trace

Microsoft.SqlServer.Management.UI.RSClient.RSClientConnection.GetProperties(String

Item, Property[] Properties)

Microsoft.SqlServer.Management.UI.RSUserInterface.MenuAccessHandler2.PermissionsCacheItem.get_ItemProperties()

Microsoft.SqlServer.Management.UI.RSUserInterface.MenuAccessHandler2.EvaluateNode(XPathNavigator

navigator, PermissionsCacheItem cache)

Microsoft.SqlServer.Management.UI.RSUserInterface.MenuAccessHandler2.Evaluate(String

xmlExpression, INodeInformation source)

Microsoft.SqlServer.Management.UI.RSUserInterface.MenuAccessHandler2.Visible(INodeInformation

source)

Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.ToolsMenuItemBase.UpdateMenuCommandStatus(MenuCommand

menuCommand)

Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.DefaultMenuHandler.UpdateMenuCommandsStatus(MenuCommand

menuCommand)

Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.DefaultMenuHandler.GetMenuItems(ArrayList

items)

Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.DefaultMenuHandler.GetMenuItems()

Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.ExplorerHierarchyNode.ShowContextMenu(Point

windowPos)

Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.LazyTreeView.WmContextMenu(Message&

Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.LazyTreeView.WndProc(Message&

System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)

at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message&

at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

************** Loaded Assemblies ************** mscorlib

Assembly Version: 2.0.0.0

Win32 Version: 2.0.50727.42 (RTM.050727-4200)

CodeBase:

file:///C:/WINDOWS/Microsoft.NET/Framework/v2.0.50727/mscorlib.dll

AppIDPackage

Assembly Version: 9.0.242.0

Win32 Version: 9.00.1399.00

CodeBase:

file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/AppIDPackage.DLL

System

Assembly Version: 2.0.0.0

Win32 Version: 2.0.50727.42 (RTM.050727-4200)

CodeBase:

file:///C:/WINDOWS/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll

Microsoft.SqlServer.SqlTools.VSIntegration

Assembly Version: 9.0.242.0

Win32 Version: 9.00.1399.00

CodeBase:

file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/Microsoft.SqlServer.SqlTools.VSIntegration.DLL

Microsoft.VisualStudio.Shell.Interop

Assembly Version: 7.1.40304.0

Win32 Version: 7.0.4054

CodeBase:

file:///C:/WINDOWS/assembly/GAC/Microsoft.VisualStudio.Shell.Interop/7.1.40304.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.Shell.Interop.dll

Microsoft.VisualStudio.OLE.Interop

Assembly Version: 7.1.40304.0

Win32 Version: 7.0.4054

CodeBase:

file:///C:/WINDOWS/assembly/GAC/Microsoft.VisualStudio.OLE.Interop/7.1.40304.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.OLE.Interop.dll

System.Windows.Forms

Assembly Version: 2.0.0.0

Win32 Version: 2.0.50727.42 (RTM.050727-4200)

CodeBase:

file:///C:/WINDOWS/assembly/GAC_MSIL/System.Windows.Forms/2.0.0.0__b77a5c561934e089/System.Windows.Forms.dll

System.Drawing

Assembly Version: 2.0.0.0

Win32 Version: 2.0.50727.42 (RTM.050727-4200)

CodeBase:

file:///C:/WINDOWS/assembly/GAC_MSIL/System.Drawing/2.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll

Microsoft.SqlServer.SqlTDiagM

Assembly Version: 9.0.242.0

Win32 Version: 9.00.1399.00

CodeBase:

file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.SqlServer.SqlTDiagM/9.0.242.0__89845dcd8080cc91/Microsoft.SqlServer.SqlTDiagM.dll

Microsoft.DataWarehouse.SQM

Assembly Version: 9.0.242.0

Win32 Version: 9.00.1399.00

CodeBase:

file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/Microsoft.DataWarehouse.SQM.DLL

Microsoft.SqlServer.Instapi

Assembly Version: 9.0.242.0

Win32 Version: 9.00.1399.00

CodeBase:

file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.SqlServer.Instapi/9.0.242.0__89845dcd8080cc91/Microsoft.SqlServer.Instapi.dll

ObjectExplorer

Assembly Version: 9.0.242.0

Win32 Version: 9.00.1399.00

CodeBase:

file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/ObjectExplorer.DLL

ConnectionDlg

Assembly Version: 9.0.242.0

Win32 Version: 9.00.1399.00

CodeBase:

file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/ConnectionDlg.DLL

SqlWorkbench.Interfaces

Assembly Version: 9.0.242.0

Win32 Version: 9.00.1399.00

CodeBase:

file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/SqlWorkbench.Interfaces.DLL

Microsoft.SqlServer.CustomControls

Assembly Version: 9.0.242.0

Win32 Version: 9.00.1399.00

CodeBase:

file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.SqlServer.CustomControls/9.0.242.0__89845dcd8080cc91/Microsoft.SqlServer.CustomControls.dll

Accessibility

Assembly Version: 2.0.0.0

Win32 Version: 2.0.50727.42 (RTM.050727-4200)

CodeBase:

file:///C:/WINDOWS/assembly/GAC_MSIL/Accessibility/2.0.0.0__b03f5f7f11d50a3a/Accessibility.dll

SqlMgmt

Assembly Version: 9.0.242.0

Win32 Version: 9.00.1399.00

CodeBase:

file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/SqlMgmt.DLL

Microsoft.SqlServer.RegSvrEnum

Assembly Version: 9.0.242.0

Win32 Version: 9.00.1399.00

CodeBase:

file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.SqlServer.RegSvrEnum/9.0.242.0__89845dcd8080cc91/Microsoft.SqlServer.RegSvrEnum.dll

EnvDTE

Assembly Version: 8.0.0.0

Win32 Version: 8.0.50727.42 (RTM.050727-4200)

CodeBase:

file:///C:/WINDOWS/assembly/GAC/EnvDTE/8.0.0.0__b03f5f7f11d50a3a/EnvDTE.dll

Microsoft.NetEnterpriseServers.ExceptionMessageBox

Assembly Version: 9.0.242.0

Win32 Version: 9.00.1399.00

CodeBase:

file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.NetEnterpriseServers.ExceptionMessageBox/9.0.242.0__89845dcd8080cc91/Microsoft.NetEnterpriseServers.ExceptionMessageBox.dll

System.Data

Assembly Version: 2.0.0.0

Win32 Version: 2.0.50727.42 (RTM.050727-4200)

CodeBase:

file:///C:/WINDOWS/assembly/GAC_32/System.Data/2.0.0.0__b77a5c561934e089/System.Data.dll

Microsoft.SqlServer.ConnectionInfo

Assembly Version: 9.0.242.0

Win32 Version: 9.00.1399.00

CodeBase:

file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.SqlServer.ConnectionInfo/9.0.242.0__89845dcd8080cc91/Microsoft.SqlServer.ConnectionInfo.dll

Microsoft.SqlServer.Management.UI.RSClient

Assembly Version: 9.0.242.0

Win32 Version: 9.00.1399.00

CodeBase:

file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/Microsoft.SqlServer.Management.UI.RSClient.DLL

System.Xml

Assembly Version: 2.0.0.0

Win32 Version: 2.0.50727.42 (RTM.050727-4200)

CodeBase:

file:///C:/WINDOWS/assembly/GAC_MSIL/System.Xml/2.0.0.0__b77a5c561934e089/System.Xml.dll

Microsoft.SqlServer.SmoEnum

Assembly Version: 9.0.242.0

Win32 Version: 9.00.1399.00

CodeBase:

file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.SqlServer.SmoEnum/9.0.242.0__89845dcd8080cc91/Microsoft.SqlServer.SmoEnum.dll

System.Management

Assembly Version: 2.0.0.0

Win32 Version: 2.0.50727.42 (RTM.050727-4200)

CodeBase:

file:///C:/WINDOWS/assembly/GAC_MSIL/System.Management/2.0.0.0__b03f5f7f11d50a3a/System.Management.dll

System.Web.Services

Assembly Version: 2.0.0.0

Win32 Version: 2.0.50727.42 (RTM.050727-4200)

CodeBase:

file:///C:/WINDOWS/assembly/GAC_MSIL/System.Web.Services/2.0.0.0__b03f5f7f11d50a3a/System.Web.Services.dll

System.Configuration

Assembly Version: 2.0.0.0

Win32 Version: 2.0.50727.42 (RTM.050727-4200)

CodeBase:

file:///C:/WINDOWS/assembly/GAC_MSIL/System.Configuration/2.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll

zhphbr91

Assembly Version: 9.0.242.0

Win32 Version: 2.0.50727.42 (RTM.050727-4200)

CodeBase:

file:///C:/WINDOWS/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll

Microsoft.SqlServer.Management.UI.RSUserInterface

Assembly Version: 9.0.242.0

Win32 Version: 9.00.1399.00

CodeBase:

file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/Microsoft.SqlServer.Management.UI.RSUserInterface.DLL

Microsoft.SqlServer.SqlEnum

Assembly Version: 9.0.242.0

Win32 Version: 9.00.1399.00

CodeBase:

file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.SqlServer.SqlEnum/9.0.242.0__89845dcd8080cc91/Microsoft.SqlServer.SqlEnum.dll

Microsoft.ReportViewer.WinForms

Assembly Version: 8.0.0.0

Win32 Version: 8.0.50727.42

CodeBase:

file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.ReportViewer.WinForms/8.0.0.0__b03f5f7f11d50a3a/Microsoft.ReportViewer.WinForms.dll

Microsoft.SqlServer.Smo

Assembly Version: 9.0.242.0

Win32 Version: 9.00.1399.00

CodeBase:

file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.SqlServer.Smo/9.0.242.0__89845dcd8080cc91/Microsoft.SqlServer.Smo.dll

Microsoft.SqlServer.Management.UI.RSWrapper

Assembly Version: 9.0.242.0

Win32 Version: 9.00.1399.00

CodeBase:

file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/Microsoft.SqlServer.Management.UI.RSWrapper.DLL

************** JIT Debugging ************** To enable just-in-time (JIT) debugging, the .config file for this application or computer (machine.config) must have the jitDebugging value set in the system.windows.forms section.

The application must also be compiled with debugging enabled.

For example:

<system.windows.forms jitDebugging="true" /> </configuration>

When JIT debugging is enabled, any unhandled exception will be sent to the JIT debugger registered on the computer rather than be handled by this dialog box.

Not quite sure if this will help, but I do not what this method Is. Basically its a method on the Data Extension to retrieve the properties of the command object, within the Report Designer.

Do you know which Data extension the report is using (SQL Server, Oracle or maybe a Custom data extension?)

|||

We are using SQL Server.

It appears that we may have solved this issue by reinstalling RS SP1. I'm unsure why we were receiving this error though but it is gone now.

Thanks for your help.

Dan

rsInternalError

I have reporting services installed on my xp laptop and haven't used it for a
while. Now when I try to run a report I get the following error message.
@.AwaitingFirstExecution is not a parameter for procedure CreateSession
Anybody seen this before? I can't find any information about this.
Thanks
MGSounds like the report is calling a stored procedure called "CreateSession".
Is that a datasource of your report? If not, make sure you have enough
permission to run the report.
Ed
"Mardy" wrote:
> I have reporting services installed on my xp laptop and haven't used it for a
> while. Now when I try to run a report I get the following error message.
> @.AwaitingFirstExecution is not a parameter for procedure CreateSession
> Anybody seen this before? I can't find any information about this.
> Thanks
> MG|||Thanks Ed but no it's not using a stored procedure. Actually all the reports
that I try to run return this same message. All work fine when I run from
visual studio. I've tested and reloaded the data sources but no success.
"Ed" wrote:
> Sounds like the report is calling a stored procedure called "CreateSession".
> Is that a datasource of your report? If not, make sure you have enough
> permission to run the report.
> Ed
> "Mardy" wrote:
> > I have reporting services installed on my xp laptop and haven't used it for a
> > while. Now when I try to run a report I get the following error message.
> > @.AwaitingFirstExecution is not a parameter for procedure CreateSession
> >
> > Anybody seen this before? I can't find any information about this.
> >
> > Thanks
> > MG|||Not sure if it is related. We were getting the rsinternalerror as well.
After working with Microsoft, they determined that the error had to do with
the AMD processor on our server. Are you using an AMD processor?
"Mardy" <Mardy@.discussions.microsoft.com> wrote in message
news:B555F393-D1B1-421B-9DE8-9686F305FE06@.microsoft.com...
>I have reporting services installed on my xp laptop and haven't used it for
>a
> while. Now when I try to run a report I get the following error message.
> @.AwaitingFirstExecution is not a parameter for procedure CreateSession
> Anybody seen this before? I can't find any information about this.
> Thanks
> MG|||Thanks Chris
I have reporting services loaded on a Dell Inspiron with an Intel Pentium M
processor.
"Chris" wrote:
> Not sure if it is related. We were getting the rsinternalerror as well.
> After working with Microsoft, they determined that the error had to do with
> the AMD processor on our server. Are you using an AMD processor?
>
> "Mardy" <Mardy@.discussions.microsoft.com> wrote in message
> news:B555F393-D1B1-421B-9DE8-9686F305FE06@.microsoft.com...
> >I have reporting services installed on my xp laptop and haven't used it for
> >a
> > while. Now when I try to run a report I get the following error message.
> > @.AwaitingFirstExecution is not a parameter for procedure CreateSession
> >
> > Anybody seen this before? I can't find any information about this.
> >
> > Thanks
> > MG
>
>

Wednesday, March 28, 2012

RSExecutionLog_Update.dtsx error!!

Hi,

When I execute the RSExecutionLog_Update.dtsx, I get an error saying "The task "Set Time period" cannot run on this edition of Integration Services. It requires higher level edition". I am using the Proffesional Edition of SQL2005 and the Integration Services Version is 9.00.1399.00. I have configured the target database RSExecutionLog correctly. Wat could be the problem?

TIA

Is this a script task that is specifically generating this error? You can tell by looking in the execution progress to see which task is creating the error.

I am receiving this error on script tasks and I wanted to see if you have found a work-around or a solution to the error.

|||

As far as I know there is no Professional Editio of SQL 2005. We have Express, Workgroup, Standard and Enterprise.

Donald

|||

Donald:

Thanks for responding.

I am encountering this error when I run a script task, Error: The task "ScriptTask" cannot run on this edition of Integration Services. It requires a higher level edition.

We are running SQL Server Enterprise Edition so SSIS should be included. Do you have any thoughts?

|||

Is it possible that you have installed only the tools, but not selected to install SSIS itself?

Donald

RSExecutionLog_Update.dtsx error!!

Hi,

TIA

Is this a script task that is specifically generating this error? You can tell by looking in the execution progress to see which task is creating the error.

I am receiving this error on script tasks and I wanted to see if you have found a work-around or a solution to the error.

|||

As far as I know there is no Professional Editio of SQL 2005. We have Express, Workgroup, Standard and Enterprise.

Donald

|||

Donald:

Thanks for responding.

I am encountering this error when I run a script task, Error: The task "ScriptTask" cannot run on this edition of Integration Services. It requires a higher level edition.

We are running SQL Server Enterprise Edition so SSIS should be included. Do you have any thoughts?

|||

Is it possible that you have installed only the tools, but not selected to install SSIS itself?

Donald

sql

RSExecutionLog_Update.dts fails for named SQL Instance

Hi:
I am running SRS on a named instance of SQL. When I attempt to run this DTS
package, it fails on the five update steps with the error message "Cannot
open database requested in login 'ReportServer'. Login fails."
How can I point it to the non-default instance of SQL.
Thanks in advance.
Bruce.Have you tried changing the server name in the RSExecutionLog_Update.ini
file? I have never used the package with a non-default instance of SQL
server, but I assume it should work when you make the appropriate edits in
the above ini file.
Charles Kangai, MCT, MCDBA
"bwschiek@.hotmail.com" wrote:
> Hi:
> I am running SRS on a named instance of SQL. When I attempt to run this DTS
> package, it fails on the five update steps with the error message "Cannot
> open database requested in login 'ReportServer'. Login fails."
> How can I point it to the non-default instance of SQL.
> Thanks in advance.
> Bruce.|||Hi Charles:
It worked! I changed the server setting for both the source and destination
from (local) to ServerName\SQLInstanceName and the DTS package executed as
intented!
Thanks for the quick and accurate reply!
Bruce.
"Charles Kangai" wrote:
> Have you tried changing the server name in the RSExecutionLog_Update.ini
> file? I have never used the package with a non-default instance of SQL
> server, but I assume it should work when you make the appropriate edits in
> the above ini file.
> Charles Kangai, MCT, MCDBA
> "bwschiek@.hotmail.com" wrote:
> > Hi:
> >
> > I am running SRS on a named instance of SQL. When I attempt to run this DTS
> > package, it fails on the five update steps with the error message "Cannot
> > open database requested in login 'ReportServer'. Login fails."
> >
> > How can I point it to the non-default instance of SQL.
> >
> > Thanks in advance.
> >
> > Bruce.

rsErrorOpeningConnection

Hi,
I really really need some help with the problem below. I

am having problems trying to run reports from a VB.Net application. The problem

is as follows:

SQL Server 2005, SQL Server Reporting Services and the VB

.NET application called ‘risk-op’ are on a server.

A user tries to access the application from a remote

computer. The application is displayed and the user is able to do everything.

However when the user tries to click ‘Go’ for one of the reports the following

error is displayed:

error has occurred during processing (rsProcessingAborted)
Cannot

create a connection to data source ‘risk-op’ (rsErrorOpeningConnection)

This error occurs

because the user is not a user on the SQL server database. However if I add the

user to the database the user is able to then view the report.

The

reason for this is because reporting services is configured to use windows

authentication as shown below. As a result when the user presses ‘Go’ to view a

report, reporting services tries to connect to the database using windows authentication

and if that user is not setup as a user on the database the user is then not

able to view the report.

I need to get around this problem. I don’t want to have to

manually add users to the database every time (that maintenance for a couple of

hundred people would be a disaster!)

I believe that a way around this would be to use ‘Credentials

stored securely in the report server’ in SQL Server Reporting Services. Is this

the way to do it and if so, where do I add these credentials to the report

server?

I came across an article that said “Credentials are stored in

reversible encryption in the report server database. You can specify one set of

stored credentials for each data source used in a report. The credentials you

provide retrieve the same data for every user who runs the report.”

How do I add these credentials and is this the answer to my

problem?

Do I have to change something in the RSreportserver.config

file?
Any help would be much appreciated, thanks!
Ian

No you can simply switch that in the data source section by specifying a custom data source for the report. By switching, you will use SQL Server Authentication instead of Windows Authentication.

If you want to do that on a server level and you want to use Windows authentication rather than SQL Server authentication, you could use one Windows User for Reporting Services, enable Anynomous authentication on the Web Server and specify the use under the IIS context for Anonymous Authentication.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de|||

Hi Jens,

Thanks for your reply.
You said,
“No you can simply switch that in the data source section by specifying a custom data source for the report. By switching, you will use SQL Server Authentication instead of Windows Authentication.

Ok so in the web front end of SQL Server Reporting Services I just untick Windows auth and tick SQL Server auth instead? I tried doing this but it didn’t work. (presumably because I hadn’t created the SQL Server user to authenticate? Is it just a case of creating a user on the database?)

You then say “you could use one Windows User for Reporting Service”, how do I do this?

“enable Anynomous authentication on the Web Server” – I have that done in IIS on the web server for the folder ‘risk-op’ which is where my application is but do I actually have to allow anonymous access somewhere else?
Thanks again, your help is much appreciated,
Ian

|||Has there ever been a final resolution to this? I am having a similar problem.

rsErrorOpeningConnection

Hi,
I really really need some help with the problem below. I am having problems trying to run reports from a VB.Net application. The problem is as follows:

SQL Server 2005, SQL Server Reporting Services and the VB .NET application called ‘risk-op’ are on a server.

A user tries to access the application from a remote computer. The application is displayed and the user is able to do everything. However when the user tries to click ‘Go’ for one of the reports the following error is displayed:

An error has occurred during processing (rsProcessingAborted)
Cannot create a connection to data source ‘risk-op’ (rsErrorOpeningConnection)

This error occurs because the user is not a user on the SQL server database. However if I add the user to the database the user is able to then view the report.

The reason for this is because reporting services is configured to use windows authentication as shown below. As a result when the user presses ‘Go’ to view a report, reporting services tries to connect to the database using windows authentication and if that user is not setup as a user on the database the user is then not able to view the report.

I need to get around this problem. I don’t want to have to manually add users to the database every time (that maintenance for a couple of hundred people would be a disaster!)

I believe that a way around this would be to use ‘Credentials stored securely in the report server’ in SQL Server Reporting Services. Is this the way to do it and if so, where do I add these credentials to the report server?

I came across an article that said “Credentials are stored in reversible encryption in the report server database. You can specify one set of stored credentials for each data source used in a report. The credentials you provide retrieve the same data for every user who runs the report.”

How do I add these credentials and is this the answer to my problem?

Do I have to change something in the RSreportserver.config file?
Any help would be much appreciated, thanks!
Ian

No you can simply switch that in the data source section by specifying a custom data source for the report. By switching, you will use SQL Server Authentication instead of Windows Authentication.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de
|||

Hi Jens,

You then say “you could use one Windows User for Reporting Service”, how do I do this?

|||Has there ever been a final resolution to this? I am having a similar problem.sql

RSCONFIG password problems

I need to run RSCONFIG and change the account used for reporting
services. The password I need to use has the character | (it looks like
two sideways minus sings one on top of the other)
When rsconfig runs, I get the error "the rest of the statement is not
recognized" and the text after that character is then displayed.
Can anyone tell me what escape character can I place in front of the |
character so that the command line utility sees that character as part
of the password?Have you tried enclosing the the password and argument in quotes?
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Lou" <lbonnes@.yahoo.com> wrote in message
news:1128000115.956238.154610@.g49g2000cwa.googlegroups.com...
>I need to run RSCONFIG and change the account used for reporting
> services. The password I need to use has the character | (it looks like
> two sideways minus sings one on top of the other)
> When rsconfig runs, I get the error "the rest of the statement is not
> recognized" and the text after that character is then displayed.
> Can anyone tell me what escape character can I place in front of the |
> character so that the command line utility sees that character as part
> of the password?
>|||Hi Lou,
Put quotes around the password and RSConfig should work.
--
| From: "Lou" <lbonnes@.yahoo.com>
| Newsgroups: microsoft.public.sqlserver.reportingsvcs
| Subject: RSCONFIG password problems
| Date: 29 Sep 2005 06:21:56 -0700
| Organization: http://groups.google.com
| Lines: 11
| Message-ID: <1128000115.956238.154610@.g49g2000cwa.googlegroups.com>
| NNTP-Posting-Host: 170.12.43.168
| Mime-Version: 1.0
| Content-Type: text/plain; charset="iso-8859-1"
| X-Trace: posting.google.com 1128000121 8649 127.0.0.1 (29 Sep 2005
13:22:01 GMT)
| X-Complaints-To: groups-abuse@.google.com
| NNTP-Posting-Date: Thu, 29 Sep 2005 13:22:01 +0000 (UTC)
| User-Agent: G2/0.2
| X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1;|||Did not work. I still get the error the rest of the statement is not
| recognized"|||Follow - up
Our password is something like this kl9O7|mi05 The error we were
getting was "the remaining text is not recognized mi05".
Putting quotes around the password did not work. My DBA figured out
that placing a ^ in front of the | character worked.
I now have a different problem, but at least I now know how to pass
oddball charactered passwords (are there really any other type) to the
RSCONFIG utility.

RsConfig -e command for Unattended execution

Hi
When I run the following RsConfig -e command for Unattended execution, I get
the "System.Management.ManagementException: Not found" error. Does anyone
know what the problem is?
C:\Program Files\Microsoft SQL Server\80\Tools\Binn>rsconfig -e -u
Sqlusername -p SqlPassword -t
System.Management.ManagementException: Not found
at
System.Management.ManagementException.ThrowWithExtendedInfo(ManagementStatus
errorCode)
at System.Management.PropertyData.RefreshPropertyInfo()
at System.Management.PropertyDataCollection.get_Item(String propertyName)
at System.Management.ManagementBaseObject.GetPropertyValue(String
propertyName)
at System.Management.ManagementBaseObject.get_Item(String propertyName)
at
Microsoft.ReportingServices.ConfigManagement.ConfigFileApp.ConnectToWmi()
at
Microsoft.ReportingServices.ConfigManagement.ConfigFileApp.InstanceMain()
at Microsoft.ReportingServices.BaseCmdLine.CommandLineMain(String[] args,
BaseCmdLine instance)
Thanks,
MarkCan you try running mofcomp on ReportingServices.mof and see if this fixes
your issue.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"MCC" <cmc_za@.hotmail.com> wrote in message
news:evdrsvWpEHA.2900@.TK2MSFTNGP12.phx.gbl...
> Hi
> When I run the following RsConfig -e command for Unattended execution, I
get
> the "System.Management.ManagementException: Not found" error. Does anyone
> know what the problem is?
> C:\Program Files\Microsoft SQL Server\80\Tools\Binn>rsconfig -e -u
> Sqlusername -p SqlPassword -t
> System.Management.ManagementException: Not found
> at
>
System.Management.ManagementException.ThrowWithExtendedInfo(ManagementStatus
> errorCode)
> at System.Management.PropertyData.RefreshPropertyInfo()
> at System.Management.PropertyDataCollection.get_Item(String
propertyName)
> at System.Management.ManagementBaseObject.GetPropertyValue(String
> propertyName)
> at System.Management.ManagementBaseObject.get_Item(String propertyName)
> at
> Microsoft.ReportingServices.ConfigManagement.ConfigFileApp.ConnectToWmi()
> at
> Microsoft.ReportingServices.ConfigManagement.ConfigFileApp.InstanceMain()
> at Microsoft.ReportingServices.BaseCmdLine.CommandLineMain(String[]
args,
> BaseCmdLine instance)
> Thanks,
> Mark
>|||That worked a treat, thanks.
Mark
"Daniel Reib [MSFT]" <danreib@.online.microsoft.com> wrote in message
news:eegzg5WpEHA.1992@.TK2MSFTNGP09.phx.gbl...
> Can you try running mofcomp on ReportingServices.mof and see if this fixes
> your issue.
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no
rights.
>
> "MCC" <cmc_za@.hotmail.com> wrote in message
> news:evdrsvWpEHA.2900@.TK2MSFTNGP12.phx.gbl...
> > Hi
> >
> > When I run the following RsConfig -e command for Unattended execution, I
> get
> > the "System.Management.ManagementException: Not found" error. Does
anyone
> > know what the problem is?
> >
> > C:\Program Files\Microsoft SQL Server\80\Tools\Binn>rsconfig -e -u
> > Sqlusername -p SqlPassword -t
> >
> > System.Management.ManagementException: Not found
> >
> > at
> >
>
System.Management.ManagementException.ThrowWithExtendedInfo(ManagementStatus
> > errorCode)
> > at System.Management.PropertyData.RefreshPropertyInfo()
> > at System.Management.PropertyDataCollection.get_Item(String
> propertyName)
> > at System.Management.ManagementBaseObject.GetPropertyValue(String
> > propertyName)
> > at System.Management.ManagementBaseObject.get_Item(String
propertyName)
> > at
> >
Microsoft.ReportingServices.ConfigManagement.ConfigFileApp.ConnectToWmi()
> > at
> >
Microsoft.ReportingServices.ConfigManagement.ConfigFileApp.InstanceMain()
> > at Microsoft.ReportingServices.BaseCmdLine.CommandLineMain(String[]
> args,
> > BaseCmdLine instance)
> >
> > Thanks,
> >
> > Mark
> >
> >
>

RSCONFIG did not modify RSReportServer.config all the way

A couple of months ago we changed the username that SQL 2000 reporting
services uses to run. Since then it has been running fine.
Last week I tried to add a new user to the system and I get the error,
The user or group name 'DOMAIN\USERNAME' is not recognized.
The username it is returning is the OLD username that we replaced 2
months ago.
Here is the command line I am using RSCONFIG -c -s antbearxa\sqldev18
-d ReportingServices -a WINDOWS -u <USERNAME> -p <PASSWORD>.
The system runs fine, it is just when I go to add another user that I
get the error pointing to the old login account that is no longer
valid.
--
Leo BonnesIt turned out to be a leftover account instance in Reporting Services.
Thank you Hemant at Microsoft!
The user that I removed as the Reporting Services database login
account was still a user in the Reporting Services database. It was a
domain account and after we changed the account a few weeks later it
was retired. Once I deleted that user, adding a new user worked.
I guess it was in the validation phase after I tried to add a new user
to Reporting Services that it was failing. Now the question remains why
is a domain account that no longer exist in Repoting Services still
showing up?sql

Monday, March 26, 2012

RSClientPrint ActiveX causes client PC to reboot

We have a client PC trying to run a report. When they hit the print button it
first asks them to install a SQL active X control which is RSClientPrint
Class. Once installed they hit the print button on the report which then
loads the active X print dialog - when they hit print their system reboots.
I had this person delete the control and go through the same process with
the same results; they are running Windows XP SP2 with IE6.
Any ideas? Thank You.That is exactly what I am running (XP SP2 IE6).
Are they in the local administrators group on the machine (i.e. do they have
the rights to install the activeX control?)
Do they have any printers connected to their PC? This is printing locally
not at the server.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Dan Zaccarine" <Dan Zaccarine@.discussions.microsoft.com> wrote in message
news:89B4C6AC-14D6-4F05-8915-2892D3AD2DA8@.microsoft.com...
> We have a client PC trying to run a report. When they hit the print button
> it
> first asks them to install a SQL active X control which is RSClientPrint
> Class. Once installed they hit the print button on the report which then
> loads the active X print dialog - when they hit print their system
> reboots.
> I had this person delete the control and go through the same process with
> the same results; they are running Windows XP SP2 with IE6.
> Any ideas? Thank You.
>|||Which version of RS do you use?
I have one computer (WinXP, DELL laptop, 2 years old) with a HP1320 printer
connected. the RS Client print alway causes "blue screen death" when try to
print report. Printing anything else is OK.
However, the printer prints RS report OK when connected to any other
computers. So, I guess it is some sort of hardware issue with that
particular computer/printer combination. The solution is by that user a
different printer. Now the reporting print with that computer is fine and
the previous computer also happily work with other computer when printing RS
report.
So, you may try to update the printer's driver first, and then try to use a
different computer.
Just an experience using RS2000 printing. RS2000 reporitn rendering/printing
horribly bad.
"Dan Zaccarine" <Dan Zaccarine@.discussions.microsoft.com> wrote in message
news:89B4C6AC-14D6-4F05-8915-2892D3AD2DA8@.microsoft.com...
> We have a client PC trying to run a report. When they hit the print button
> it
> first asks them to install a SQL active X control which is RSClientPrint
> Class. Once installed they hit the print button on the report which then
> loads the active X print dialog - when they hit print their system
> reboots.
> I had this person delete the control and go through the same process with
> the same results; they are running Windows XP SP2 with IE6.
> Any ideas? Thank You.
>|||On Nov 28, 11:20 am, "Norman Yuan" <NoAddr...@.NoEmail.fake> wrote:
> Which version of RS do you use?
> I have one computer (WinXP, DELL laptop, 2 years old) with a HP1320 printer
> connected. the RS Client print alway causes "blue screen death" when try to
> print report. Printing anything else is OK.
> However, the printer prints RS report OK when connected to any other
> computers. So, I guess it is some sort of hardware issue with that
> particular computer/printer combination. The solution is by that user a
> different printer. Now the reporting print with that computer is fine and
> the previous computer also happily work with other computer when printing RS
> report.
> So, you may try to update the printer's driver first, and then try to use a
> different computer.
> Just an experience using RS2000 printing. RS2000 reporitn rendering/printing
> horribly bad.
> "Dan Zaccarine" <Dan Zaccar...@.discussions.microsoft.com> wrote in messagenews:89B4C6AC-14D6-4F05-8915-2892D3AD2DA8@.microsoft.com...
>
> > We have a client PC trying to run a report. When they hit the print button
> > it
> > first asks them to install a SQL active X control which is RSClientPrint
> > Class. Once installed they hit the print button on the report which then
> > loads the active X print dialog - when they hit print their system
> > reboots.
> > I had this person delete the control and go through the same process with
> > the same results; they are running Windows XP SP2 with IE6.
> > Any ideas? Thank You.- Hide quoted text -
> - Show quoted text -
I have seen the same issue. However, I only get the reboot when I am
printing a matrix report. All other report types print Ok.|||I am having same problem any idea to solve this issue
"RDV" wrote:
> On Nov 28, 11:20 am, "Norman Yuan" <NoAddr...@.NoEmail.fake> wrote:
> > Which version of RS do you use?
> >
> > I have one computer (WinXP, DELL laptop, 2 years old) with a HP1320 printer
> > connected. the RS Client print alway causes "blue screen death" when try to
> > print report. Printing anything else is OK.
> >
> > However, the printer prints RS report OK when connected to any other
> > computers. So, I guess it is some sort of hardware issue with that
> > particular computer/printer combination. The solution is by that user a
> > different printer. Now the reporting print with that computer is fine and
> > the previous computer also happily work with other computer when printing RS
> > report.
> >
> > So, you may try to update the printer's driver first, and then try to use a
> > different computer.
> >
> > Just an experience using RS2000 printing. RS2000 reporitn rendering/printing
> > horribly bad.
> >
> > "Dan Zaccarine" <Dan Zaccar...@.discussions.microsoft.com> wrote in messagenews:89B4C6AC-14D6-4F05-8915-2892D3AD2DA8@.microsoft.com...
> >
> >
> >
> > > We have a client PC trying to run a report. When they hit the print button
> > > it
> > > first asks them to install a SQL active X control which is RSClientPrint
> > > Class. Once installed they hit the print button on the report which then
> > > loads the active X print dialog - when they hit print their system
> > > reboots.
> >
> > > I had this person delete the control and go through the same process with
> > > the same results; they are running Windows XP SP2 with IE6.
> >
> > > Any ideas? Thank You.- Hide quoted text -
> >
> > - Show quoted text -
> I have seen the same issue. However, I only get the reboot when I am
> printing a matrix report. All other report types print Ok.
>|||I saw this last spring:
>>>>>>>>
> > It only affects printers using the PCL 6 driver. If I print to any of
> > the others using a PCL 5e driver it works. All of our printers are HP.
> > > It doesn't appear to be a general print driver issue. As I said, only
> > > the HP 4250's have this problem.
> > > > It appears to be a print driver issue due to some recent update. If
> > > > you change your print drivers to PCL 5e it won't crash any longer.
>>>>>>>>>>>
Again, I have no real knowledge of this. Hopefully the above will help.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Irfan" <Irfan@.discussions.microsoft.com> wrote in message
news:EBD33316-B4BA-4D9D-819B-33AC540278CB@.microsoft.com...
>I am having same problem any idea to solve this issue
> "RDV" wrote:
>> On Nov 28, 11:20 am, "Norman Yuan" <NoAddr...@.NoEmail.fake> wrote:
>> > Which version of RS do you use?
>> >
>> > I have one computer (WinXP, DELL laptop, 2 years old) with a HP1320
>> > printer
>> > connected. the RS Client print alway causes "blue screen death" when
>> > try to
>> > print report. Printing anything else is OK.
>> >
>> > However, the printer prints RS report OK when connected to any other
>> > computers. So, I guess it is some sort of hardware issue with that
>> > particular computer/printer combination. The solution is by that user a
>> > different printer. Now the reporting print with that computer is fine
>> > and
>> > the previous computer also happily work with other computer when
>> > printing RS
>> > report.
>> >
>> > So, you may try to update the printer's driver first, and then try to
>> > use a
>> > different computer.
>> >
>> > Just an experience using RS2000 printing. RS2000 reporitn
>> > rendering/printing
>> > horribly bad.
>> >
>> > "Dan Zaccarine" <Dan Zaccar...@.discussions.microsoft.com> wrote in
>> > messagenews:89B4C6AC-14D6-4F05-8915-2892D3AD2DA8@.microsoft.com...
>> >
>> >
>> >
>> > > We have a client PC trying to run a report. When they hit the print
>> > > button
>> > > it
>> > > first asks them to install a SQL active X control which is
>> > > RSClientPrint
>> > > Class. Once installed they hit the print button on the report which
>> > > then
>> > > loads the active X print dialog - when they hit print their system
>> > > reboots.
>> >
>> > > I had this person delete the control and go through the same process
>> > > with
>> > > the same results; they are running Windows XP SP2 with IE6.
>> >
>> > > Any ideas? Thank You.- Hide quoted text -
>> >
>> > - Show quoted text -
>> I have seen the same issue. However, I only get the reboot when I am
>> printing a matrix report. All other report types print Ok.|||Hi all !
I found a solution for your problem. You probably installed the hotfix
925902 recently. Its a known issue for Microsoft. Some printers only (until
now : Ricoh LAN Fax Driver, Gestetner P7026n PCL, Ricoh Laser AP2600N PCL,
HP LaserJet 9050, HP LaserJet 4200, HP 4050 PCL6, HP LaserJet 4345 PCL 6 and
Canon Pixma MP170) are impacted.
This problem occurs when a printer driver makes a call that has invalid
parameters to the Win32K.sys component.
The hotfix KB935843 solved the problem on my computer.

RSClientPrint - Error on some clients

I have several new PCs that I am setting up to run an RS ASP.net application. The Dells work fine. The Gateway gives a print error message 'An error occurred during printing (0x80070006)' and then a script error 'the handle is invalid'. I have tried various things, such as, disabling popup blockers, tool bars and changing IE settings. Nothing makes it work. The only difference between the machines is that the Gateway has Norton Anti-Virus loaded. Tried disabling it but still got the error. I have searched the internet and cannot find a similar error. Need help fast, deploying in 2 weeks.

Hi mark,

I've had the same problem at a client. Did you do an upgrade to SQL Server 2005 or installed a service pack for reporting services ?

The problem is that when the user tries to print a reporting services report, an ActiveX is installed on the user's pc (C:\Windows\Downloaded Program Files\RsClientPrint Class).

When upgrading to a new version or installing a service pack, the component needs to be upgraded. Apparently this doesn't always work that well.

When you remove the component (by right clicking it in c:\windows\...) and try to print a page, you will see that a new version will be installed and that you can print again.

I didn't figured out a good way to deploy this yet because user's don't have sufficient rights to install ActiveX components. It might work if you put the site in the Trusted Sites.

Hope this helps !

Geert Verhoeven

rsactivate error - trying to install on 2003 with Sharepoint servi

I am trying to install SQL Reporting Services on a Windows Server 2003 box
that is running Sharepoint Services 2.0.
When you run the install you are warned that you will need to manually
initialize SQL Reporting because of Sharepoint and are referred to the
documentation. In the rssetup.chm there is an article entitled
"Troubleshooting a Side-by-Side Installation of Reporting Services and
Windows SharePoint Services". I followed these instructions, but when I get
to the last step where you run rsactivate, I get an error:
Failure starting the web service:
The service is already activated.
I did have reporting installed on this server once before but it was
uninstalled. I tried uninstalling reporting services when I got this error,
then tried again but I get the same result. I've been deleting the virtual
directories, the program files folder, and the databases before trying again.
I also noticed that two com + packages are left behind. If you don't remove
them the next installation adds two more. I removed all of them and tried
again but still the same result. I don't possess any knowledge of web
services so I'm not sure where to look next.
Can anyone help please?
--
-JeffWhat error message do you see when viewing http://localhost/reportserver?
--
This posting is provided "AS IS" with no warranties, and confers no rights
"Jeffffffffff" <Jeffffffffff@.discussions.microsoft.com> wrote in message
news:9E8E9623-BDA7-469D-AA5B-6CA60C9E91D9@.microsoft.com...
> I am trying to install SQL Reporting Services on a Windows Server 2003 box
> that is running Sharepoint Services 2.0.
> When you run the install you are warned that you will need to manually
> initialize SQL Reporting because of Sharepoint and are referred to the
> documentation. In the rssetup.chm there is an article entitled
> "Troubleshooting a Side-by-Side Installation of Reporting Services and
> Windows SharePoint Services". I followed these instructions, but when I
get
> to the last step where you run rsactivate, I get an error:
> Failure starting the web service:
> The service is already activated.
> I did have reporting installed on this server once before but it was
> uninstalled. I tried uninstalling reporting services when I got this
error,
> then tried again but I get the same result. I've been deleting the
virtual
> directories, the program files folder, and the databases before trying
again.
> I also noticed that two com + packages are left behind. If you don't
remove
> them the next installation adds two more. I removed all of them and tried
> again but still the same result. I don't possess any knowledge of web
> services so I'm not sure where to look next.
> Can anyone help please?
> --
> -Jeff|||Reporting Services Erro
----
The report server cannot decrypt the symmetric key used to access sensitive
or encrypted data in a report server database. You must either restore a
backup key or delete all encrypted content and then restart the service.
Check the documentation for more information. (rsReportServerDisabled) Get
Online Help
Bad Data.
----
Microsoft Reporting Services
"Brian Hartman [MSFT]" wrote:
> What error message do you see when viewing http://localhost/reportserver?
> --
> This posting is provided "AS IS" with no warranties, and confers no rights
> "Jeffffffffff" <Jeffffffffff@.discussions.microsoft.com> wrote in message
> news:9E8E9623-BDA7-469D-AA5B-6CA60C9E91D9@.microsoft.com...
> > I am trying to install SQL Reporting Services on a Windows Server 2003 box
> > that is running Sharepoint Services 2.0.
> >
> > When you run the install you are warned that you will need to manually
> > initialize SQL Reporting because of Sharepoint and are referred to the
> > documentation. In the rssetup.chm there is an article entitled
> > "Troubleshooting a Side-by-Side Installation of Reporting Services and
> > Windows SharePoint Services". I followed these instructions, but when I
> get
> > to the last step where you run rsactivate, I get an error:
> >
> > Failure starting the web service:
> > The service is already activated.
> >
> > I did have reporting installed on this server once before but it was
> > uninstalled. I tried uninstalling reporting services when I got this
> error,
> > then tried again but I get the same result. I've been deleting the
> virtual
> > directories, the program files folder, and the databases before trying
> again.
> > I also noticed that two com + packages are left behind. If you don't
> remove
> > them the next installation adds two more. I removed all of them and tried
> > again but still the same result. I don't possess any knowledge of web
> > services so I'm not sure where to look next.
> >
> > Can anyone help please?
> >
> > --
> > -Jeff
>
>|||Try the following: rsactivate -r -c <config file>
--
This posting is provided "AS IS" with no warranties, and confers no rights
"Jeffffffffff" <Jeffffffffff@.discussions.microsoft.com> wrote in message
news:A621959A-B70F-480C-9E06-7C114758DE57@.microsoft.com...
> Reporting Services Error
> ----
--
> The report server cannot decrypt the symmetric key used to access
sensitive
> or encrypted data in a report server database. You must either restore a
> backup key or delete all encrypted content and then restart the service.
> Check the documentation for more information. (rsReportServerDisabled) Get
> Online Help
> Bad Data.
> ----
--
> Microsoft Reporting Services
>
>
> "Brian Hartman [MSFT]" wrote:
> > What error message do you see when viewing
http://localhost/reportserver?
> >
> > --
> > This posting is provided "AS IS" with no warranties, and confers no
rights
> >
> > "Jeffffffffff" <Jeffffffffff@.discussions.microsoft.com> wrote in message
> > news:9E8E9623-BDA7-469D-AA5B-6CA60C9E91D9@.microsoft.com...
> > > I am trying to install SQL Reporting Services on a Windows Server 2003
box
> > > that is running Sharepoint Services 2.0.
> > >
> > > When you run the install you are warned that you will need to manually
> > > initialize SQL Reporting because of Sharepoint and are referred to the
> > > documentation. In the rssetup.chm there is an article entitled
> > > "Troubleshooting a Side-by-Side Installation of Reporting Services and
> > > Windows SharePoint Services". I followed these instructions, but when
I
> > get
> > > to the last step where you run rsactivate, I get an error:
> > >
> > > Failure starting the web service:
> > > The service is already activated.
> > >
> > > I did have reporting installed on this server once before but it was
> > > uninstalled. I tried uninstalling reporting services when I got this
> > error,
> > > then tried again but I get the same result. I've been deleting the
> > virtual
> > > directories, the program files folder, and the databases before trying
> > again.
> > > I also noticed that two com + packages are left behind. If you don't
> > remove
> > > them the next installation adds two more. I removed all of them and
tried
> > > again but still the same result. I don't possess any knowledge of web
> > > services so I'm not sure where to look next.
> > >
> > > Can anyone help please?
> > >
> > > --
> > > -Jeff
> >
> >
> >|||Excellent!!!! That did it. I could swear I'd already tried that and almost
replied with that, but I thought I should try again. I wonder if I tried
that before I deleted the extra com + packages. Is that possible? Do you
understand what happened here, because it would be nice to be able to explain
it to my co-workers?
Thanks so much,
-Jeff
"Brian Hartman [MSFT]" wrote:
> Try the following: rsactivate -r -c <config file>
> --
> This posting is provided "AS IS" with no warranties, and confers no rights
> "Jeffffffffff" <Jeffffffffff@.discussions.microsoft.com> wrote in message
> news:A621959A-B70F-480C-9E06-7C114758DE57@.microsoft.com...
> > Reporting Services Error
> > ----
> --
> >
> > The report server cannot decrypt the symmetric key used to access
> sensitive
> > or encrypted data in a report server database. You must either restore a
> > backup key or delete all encrypted content and then restart the service.
> > Check the documentation for more information. (rsReportServerDisabled) Get
> > Online Help
> > Bad Data.
> >
> > ----
> --
> > Microsoft Reporting Services
> >
> >
> >
> >
> > "Brian Hartman [MSFT]" wrote:
> >
> > > What error message do you see when viewing
> http://localhost/reportserver?
> > >
> > > --
> > > This posting is provided "AS IS" with no warranties, and confers no
> rights
> > >
> > > "Jeffffffffff" <Jeffffffffff@.discussions.microsoft.com> wrote in message
> > > news:9E8E9623-BDA7-469D-AA5B-6CA60C9E91D9@.microsoft.com...
> > > > I am trying to install SQL Reporting Services on a Windows Server 2003
> box
> > > > that is running Sharepoint Services 2.0.
> > > >
> > > > When you run the install you are warned that you will need to manually
> > > > initialize SQL Reporting because of Sharepoint and are referred to the
> > > > documentation. In the rssetup.chm there is an article entitled
> > > > "Troubleshooting a Side-by-Side Installation of Reporting Services and
> > > > Windows SharePoint Services". I followed these instructions, but when
> I
> > > get
> > > > to the last step where you run rsactivate, I get an error:
> > > >
> > > > Failure starting the web service:
> > > > The service is already activated.
> > > >
> > > > I did have reporting installed on this server once before but it was
> > > > uninstalled. I tried uninstalling reporting services when I got this
> > > error,
> > > > then tried again but I get the same result. I've been deleting the
> > > virtual
> > > > directories, the program files folder, and the databases before trying
> > > again.
> > > > I also noticed that two com + packages are left behind. If you don't
> > > remove
> > > > them the next installation adds two more. I removed all of them and
> tried
> > > > again but still the same result. I don't possess any knowledge of web
> > > > services so I'm not sure where to look next.
> > > >
> > > > Can anyone help please?
> > > >
> > > > --
> > > > -Jeff
> > >
> > >
> > >
>
>|||I don't think the COM+ changes had anything to do with this. At some point,
you ran or installed something that reset the password on your ASPNet
account. Installing a version of the .Net framework will do this. So will
running aspnet_regiis. When the password is reset (reset = changed without
supplying the original one) on an account, the decryption keys associated
with that account are lost. There is probably an event in your windows
event log that indicates this happened.
--
This posting is provided "AS IS" with no warranties, and confers no rights
"Jeffffffffff" <Jeffffffffff@.discussions.microsoft.com> wrote in message
news:61D89FDE-0F89-4319-AB1A-F7D8C1462E07@.microsoft.com...
> Excellent!!!! That did it. I could swear I'd already tried that and
almost
> replied with that, but I thought I should try again. I wonder if I tried
> that before I deleted the extra com + packages. Is that possible? Do you
> understand what happened here, because it would be nice to be able to
explain
> it to my co-workers?
> Thanks so much,
> -Jeff
> "Brian Hartman [MSFT]" wrote:
> > Try the following: rsactivate -r -c <config file>
> >
> > --
> > This posting is provided "AS IS" with no warranties, and confers no
rights
> >
> > "Jeffffffffff" <Jeffffffffff@.discussions.microsoft.com> wrote in message
> > news:A621959A-B70F-480C-9E06-7C114758DE57@.microsoft.com...
> > > Reporting Services Error
> >
> ----
> > --
> > >
> > > The report server cannot decrypt the symmetric key used to access
> > sensitive
> > > or encrypted data in a report server database. You must either restore
a
> > > backup key or delete all encrypted content and then restart the
service.
> > > Check the documentation for more information. (rsReportServerDisabled)
Get
> > > Online Help
> > > Bad Data.
> > >
> >
> ----
> > --
> > > Microsoft Reporting Services
> > >
> > >
> > >
> > >
> > > "Brian Hartman [MSFT]" wrote:
> > >
> > > > What error message do you see when viewing
> > http://localhost/reportserver?
> > > >
> > > > --
> > > > This posting is provided "AS IS" with no warranties, and confers no
> > rights
> > > >
> > > > "Jeffffffffff" <Jeffffffffff@.discussions.microsoft.com> wrote in
message
> > > > news:9E8E9623-BDA7-469D-AA5B-6CA60C9E91D9@.microsoft.com...
> > > > > I am trying to install SQL Reporting Services on a Windows Server
2003
> > box
> > > > > that is running Sharepoint Services 2.0.
> > > > >
> > > > > When you run the install you are warned that you will need to
manually
> > > > > initialize SQL Reporting because of Sharepoint and are referred to
the
> > > > > documentation. In the rssetup.chm there is an article entitled
> > > > > "Troubleshooting a Side-by-Side Installation of Reporting Services
and
> > > > > Windows SharePoint Services". I followed these instructions, but
when
> > I
> > > > get
> > > > > to the last step where you run rsactivate, I get an error:
> > > > >
> > > > > Failure starting the web service:
> > > > > The service is already activated.
> > > > >
> > > > > I did have reporting installed on this server once before but it
was
> > > > > uninstalled. I tried uninstalling reporting services when I got
this
> > > > error,
> > > > > then tried again but I get the same result. I've been deleting
the
> > > > virtual
> > > > > directories, the program files folder, and the databases before
trying
> > > > again.
> > > > > I also noticed that two com + packages are left behind. If you
don't
> > > > remove
> > > > > them the next installation adds two more. I removed all of them
and
> > tried
> > > > > again but still the same result. I don't possess any knowledge of
web
> > > > > services so I'm not sure where to look next.
> > > > >
> > > > > Can anyone help please?
> > > > >
> > > > > --
> > > > > -Jeff
> > > >
> > > >
> > > >
> >
> >
> >|||On the start menu go to microsoft sqlserver then to reporting services
and open the help. click in installing notification services and you
will find the pathes there.

RSActivate Error

I am getting the following error when attempting to run RSActivate to add a
server to a web farm:
Failure starting the web service:
The local NT service is not activated
The log file contains the following entries:
w3wp!crypto!7c8!08/17/2004-10:30:11:: i INFO: Initializing crypto as user:
NT AUTHORITY\NETWORK SERVICE
w3wp!crypto!7c8!08/17/2004-10:30:11:: i INFO: Exporting public key
w3wp!crypto!7c8!08/17/2004-10:30:11:: w WARN: Web Service not activated
w3wp!crypto!7c8!08/17/2004-10:30:11:: i INFO: Client is a local admin.
Activating web service via RPC.
w3wp!library!7c8!08/17/2004-10:30:11:: e ERROR: Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerNotActivatedEx
ception: The report server installation is not initialized. Check the
documentation for more information., ;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerNotActivatedEx
ception: The report server installation is not initialized. Check the
documentation for more information. -->
System.Runtime.InteropServices.COMException (0x80004005): -2147159550
at RSRemoteRpcClient.RemoteLogon.ThrowFriendlyRpcError(Int32 mainError,
Int32 extendedError)
at RSRemoteRpcClient.RemoteLogon.ActivateService(String instanceID, Int32
clientType)
at
Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
-- End of inner exception stack trace --
w3wp!webserver!7c8!08/17/2004-10:30:15:: e ERROR: Reporting Services error
Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerNotActivatedEx
ception: The report server installation is not initialized. Check the
documentation for more information. -->
System.Runtime.InteropServices.COMException (0x80004005): -2147159550
at RSRemoteRpcClient.RemoteLogon.ThrowFriendlyRpcError(Int32 mainError,
Int32 extendedError)
at RSRemoteRpcClient.RemoteLogon.ActivateService(String instanceID, Int32
clientType)
at
Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
-- End of inner exception stack trace --
at
Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
at Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
at
Microsoft.ReportingServices.Library.ConnectionManager.VerifyConnection()
at Microsoft.ReportingServices.Library.ConnectionManager.get_Connection()
at Microsoft.ReportingServices.Library.Storage.get_Connection()
at
Microsoft.ReportingServices.Library.Storage.NewStandardSqlCommand(String
storedProcedureName)
at
Microsoft.ReportingServices.Library.DBInterface.GetOneConfigurationInfo(Stri
ng key)
at
Microsoft.ReportingServices.Library.CachedSystemProperties.GetSystemProperty
(String name)
at Microsoft.ReportingServices.Library.CachedSystemProperties.Get(String
name)
at
Microsoft.ReportingServices.Library.CachedSystemProperties.GetParameter(Stri
ng name)
at Microsoft.ReportingServices.Library.RSService.get_MyReportsEnabled()
at Microsoft.ReportingServices.Library.RSService.PathToInternal(String
source)
at
Microsoft.ReportingServices.Diagnostics.CatalogItemContext.SetPath(String
path, Boolean validate, Boolean convert, Boolean translate)
at
Microsoft.ReportingServices.Diagnostics.CatalogItemContext.SetPath(String
path)
at
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPageCon
tent()
at
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPage()What error do you see in the Windows service log file?
--
This posting is provided "AS IS" with no warranties, and confers no rights
"Jason Nissen" <Jason.Nissen@.cunamutual.com> wrote in message
news:%23b86E%23GhEHA.2812@.tk2msftngp13.phx.gbl...
> I am getting the following error when attempting to run RSActivate to add
a
> server to a web farm:
> Failure starting the web service:
> The local NT service is not activated
> The log file contains the following entries:
> w3wp!crypto!7c8!08/17/2004-10:30:11:: i INFO: Initializing crypto as user:
> NT AUTHORITY\NETWORK SERVICE
> w3wp!crypto!7c8!08/17/2004-10:30:11:: i INFO: Exporting public key
> w3wp!crypto!7c8!08/17/2004-10:30:11:: w WARN: Web Service not activated
> w3wp!crypto!7c8!08/17/2004-10:30:11:: i INFO: Client is a local admin.
> Activating web service via RPC.
> w3wp!library!7c8!08/17/2004-10:30:11:: e ERROR: Throwing
>
Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerNotActivatedEx
> ception: The report server installation is not initialized. Check the
> documentation for more information., ;
> Info:
>
Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerNotActivatedEx
> ception: The report server installation is not initialized. Check the
> documentation for more information. -->
> System.Runtime.InteropServices.COMException (0x80004005): -2147159550
> at RSRemoteRpcClient.RemoteLogon.ThrowFriendlyRpcError(Int32 mainError,
> Int32 extendedError)
> at RSRemoteRpcClient.RemoteLogon.ActivateService(String instanceID,
Int32
> clientType)
> at
> Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
> -- End of inner exception stack trace --
> w3wp!webserver!7c8!08/17/2004-10:30:15:: e ERROR: Reporting Services error
>
Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerNotActivatedEx
> ception: The report server installation is not initialized. Check the
> documentation for more information. -->
> System.Runtime.InteropServices.COMException (0x80004005): -2147159550
> at RSRemoteRpcClient.RemoteLogon.ThrowFriendlyRpcError(Int32 mainError,
> Int32 extendedError)
> at RSRemoteRpcClient.RemoteLogon.ActivateService(String instanceID,
Int32
> clientType)
> at
> Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
> -- End of inner exception stack trace --
> at
> Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
> at
Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
> at
> Microsoft.ReportingServices.Library.ConnectionManager.VerifyConnection()
> at
Microsoft.ReportingServices.Library.ConnectionManager.get_Connection()
> at Microsoft.ReportingServices.Library.Storage.get_Connection()
> at
> Microsoft.ReportingServices.Library.Storage.NewStandardSqlCommand(String
> storedProcedureName)
> at
>
Microsoft.ReportingServices.Library.DBInterface.GetOneConfigurationInfo(Stri
> ng key)
> at
>
Microsoft.ReportingServices.Library.CachedSystemProperties.GetSystemProperty
> (String name)
> at
Microsoft.ReportingServices.Library.CachedSystemProperties.Get(String
> name)
> at
>
Microsoft.ReportingServices.Library.CachedSystemProperties.GetParameter(Stri
> ng name)
> at Microsoft.ReportingServices.Library.RSService.get_MyReportsEnabled()
> at Microsoft.ReportingServices.Library.RSService.PathToInternal(String
> source)
> at
> Microsoft.ReportingServices.Diagnostics.CatalogItemContext.SetPath(String
> path, Boolean validate, Boolean convert, Boolean translate)
> at
> Microsoft.ReportingServices.Diagnostics.CatalogItemContext.SetPath(String
> path)
> at
>
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPageCon
> tent()
> at
>
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPage()
>|||Here is what I see in the Windows service log file:
ReportingServicesService!crypto!764!8/17/2004-10:29:51:: i INFO: Exporting
public key
ReportingServicesService!crypto!764!8/17/2004-10:29:51:: i INFO: NT Service
not activated
ReportingServicesService!library!764!8/17/2004-10:29:51:: e ERROR: Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerNotActivatedEx
ception: The report server installation is not initialized. Check the
documentation for more information., ;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerNotActivatedEx
ception: The report server installation is not initialized. Check the
documentation for more information.
ReportingServicesService!library!764!8/17/2004-10:29:51:: Exception caught
while starting service. Error:
Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerNotActivatedEx
ception: The report server installation is not initialized. Check the
documentation for more information.
at Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
at Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
at Microsoft.ReportingServices.Library.ConnectionManager.VerifyConnection()
at
Microsoft.ReportingServices.Library.ServiceController.ServiceStartThread()
ReportingServicesService!library!764!8/17/2004-10:29:51:: Attempting to
start service again...
"Brian Hartman [MSFT]" <brianhartman@.hotmail.com> wrote in message
news:O0xHpDIhEHA.3540@.TK2MSFTNGP10.phx.gbl...
> What error do you see in the Windows service log file?
> --
> This posting is provided "AS IS" with no warranties, and confers no rights
> "Jason Nissen" <Jason.Nissen@.cunamutual.com> wrote in message
> news:%23b86E%23GhEHA.2812@.tk2msftngp13.phx.gbl...
> > I am getting the following error when attempting to run RSActivate to
add
> a
> > server to a web farm:
> >
> > Failure starting the web service:
> > The local NT service is not activated
> >
> > The log file contains the following entries:
> >
> > w3wp!crypto!7c8!08/17/2004-10:30:11:: i INFO: Initializing crypto as
user:
> > NT AUTHORITY\NETWORK SERVICE
> > w3wp!crypto!7c8!08/17/2004-10:30:11:: i INFO: Exporting public key
> > w3wp!crypto!7c8!08/17/2004-10:30:11:: w WARN: Web Service not activated
> > w3wp!crypto!7c8!08/17/2004-10:30:11:: i INFO: Client is a local admin.
> > Activating web service via RPC.
> > w3wp!library!7c8!08/17/2004-10:30:11:: e ERROR: Throwing
> >
>
Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerNotActivatedEx
> > ception: The report server installation is not initialized. Check the
> > documentation for more information., ;
> > Info:
> >
>
Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerNotActivatedEx
> > ception: The report server installation is not initialized. Check the
> > documentation for more information. -->
> > System.Runtime.InteropServices.COMException (0x80004005): -2147159550
> > at RSRemoteRpcClient.RemoteLogon.ThrowFriendlyRpcError(Int32
mainError,
> > Int32 extendedError)
> > at RSRemoteRpcClient.RemoteLogon.ActivateService(String instanceID,
> Int32
> > clientType)
> > at
> > Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
> > -- End of inner exception stack trace --
> > w3wp!webserver!7c8!08/17/2004-10:30:15:: e ERROR: Reporting Services
error
> >
>
Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerNotActivatedEx
> > ception: The report server installation is not initialized. Check the
> > documentation for more information. -->
> > System.Runtime.InteropServices.COMException (0x80004005): -2147159550
> > at RSRemoteRpcClient.RemoteLogon.ThrowFriendlyRpcError(Int32
mainError,
> > Int32 extendedError)
> > at RSRemoteRpcClient.RemoteLogon.ActivateService(String instanceID,
> Int32
> > clientType)
> > at
> > Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
> > -- End of inner exception stack trace --
> > at
> > Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
> > at
> Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
> > at
> > Microsoft.ReportingServices.Library.ConnectionManager.VerifyConnection()
> > at
> Microsoft.ReportingServices.Library.ConnectionManager.get_Connection()
> > at Microsoft.ReportingServices.Library.Storage.get_Connection()
> > at
> > Microsoft.ReportingServices.Library.Storage.NewStandardSqlCommand(String
> > storedProcedureName)
> > at
> >
>
Microsoft.ReportingServices.Library.DBInterface.GetOneConfigurationInfo(Stri
> > ng key)
> > at
> >
>
Microsoft.ReportingServices.Library.CachedSystemProperties.GetSystemProperty
> > (String name)
> > at
> Microsoft.ReportingServices.Library.CachedSystemProperties.Get(String
> > name)
> > at
> >
>
Microsoft.ReportingServices.Library.CachedSystemProperties.GetParameter(Stri
> > ng name)
> > at
Microsoft.ReportingServices.Library.RSService.get_MyReportsEnabled()
> > at
Microsoft.ReportingServices.Library.RSService.PathToInternal(String
> > source)
> > at
> >
Microsoft.ReportingServices.Diagnostics.CatalogItemContext.SetPath(String
> > path, Boolean validate, Boolean convert, Boolean translate)
> > at
> >
Microsoft.ReportingServices.Diagnostics.CatalogItemContext.SetPath(String
> > path)
> > at
> >
>
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPageCon
> > tent()
> > at
> >
>
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPage()
> >
> >
>|||Are you reusing a database from a previous installation? It looks like the
windows service is not activating automatically because it thinks another
report server is using the database. If this is not the case, you can clear
out the old entries by running rskeymgmt -d, then restart the windows and
web service.
--
This posting is provided "AS IS" with no warranties, and confers no rights
"Jason Nissen" <Jason.Nissen@.cunamutual.com> wrote in message
news:upNDrRJhEHA.3980@.TK2MSFTNGP12.phx.gbl...
> Here is what I see in the Windows service log file:
> ReportingServicesService!crypto!764!8/17/2004-10:29:51:: i INFO: Exporting
> public key
> ReportingServicesService!crypto!764!8/17/2004-10:29:51:: i INFO: NT
Service
> not activated
> ReportingServicesService!library!764!8/17/2004-10:29:51:: e ERROR:
Throwing
>
Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerNotActivatedEx
> ception: The report server installation is not initialized. Check the
> documentation for more information., ;
> Info:
>
Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerNotActivatedEx
> ception: The report server installation is not initialized. Check the
> documentation for more information.
> ReportingServicesService!library!764!8/17/2004-10:29:51:: Exception caught
> while starting service. Error:
>
Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerNotActivatedEx
> ception: The report server installation is not initialized. Check the
> documentation for more information.
> at
Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
> at Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
> at
Microsoft.ReportingServices.Library.ConnectionManager.VerifyConnection()
> at
> Microsoft.ReportingServices.Library.ServiceController.ServiceStartThread()
> ReportingServicesService!library!764!8/17/2004-10:29:51:: Attempting to
> start service again...
>
> "Brian Hartman [MSFT]" <brianhartman@.hotmail.com> wrote in message
> news:O0xHpDIhEHA.3540@.TK2MSFTNGP10.phx.gbl...
> > What error do you see in the Windows service log file?
> >
> > --
> > This posting is provided "AS IS" with no warranties, and confers no
rights
> >
> > "Jason Nissen" <Jason.Nissen@.cunamutual.com> wrote in message
> > news:%23b86E%23GhEHA.2812@.tk2msftngp13.phx.gbl...
> > > I am getting the following error when attempting to run RSActivate to
> add
> > a
> > > server to a web farm:
> > >
> > > Failure starting the web service:
> > > The local NT service is not activated
> > >
> > > The log file contains the following entries:
> > >
> > > w3wp!crypto!7c8!08/17/2004-10:30:11:: i INFO: Initializing crypto as
> user:
> > > NT AUTHORITY\NETWORK SERVICE
> > > w3wp!crypto!7c8!08/17/2004-10:30:11:: i INFO: Exporting public key
> > > w3wp!crypto!7c8!08/17/2004-10:30:11:: w WARN: Web Service not
activated
> > > w3wp!crypto!7c8!08/17/2004-10:30:11:: i INFO: Client is a local admin.
> > > Activating web service via RPC.
> > > w3wp!library!7c8!08/17/2004-10:30:11:: e ERROR: Throwing
> > >
> >
>
Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerNotActivatedEx
> > > ception: The report server installation is not initialized. Check the
> > > documentation for more information., ;
> > > Info:
> > >
> >
>
Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerNotActivatedEx
> > > ception: The report server installation is not initialized. Check the
> > > documentation for more information. -->
> > > System.Runtime.InteropServices.COMException (0x80004005): -2147159550
> > > at RSRemoteRpcClient.RemoteLogon.ThrowFriendlyRpcError(Int32
> mainError,
> > > Int32 extendedError)
> > > at RSRemoteRpcClient.RemoteLogon.ActivateService(String instanceID,
> > Int32
> > > clientType)
> > > at
> > >
Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
> > > -- End of inner exception stack trace --
> > > w3wp!webserver!7c8!08/17/2004-10:30:15:: e ERROR: Reporting Services
> error
> > >
> >
>
Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerNotActivatedEx
> > > ception: The report server installation is not initialized. Check the
> > > documentation for more information. -->
> > > System.Runtime.InteropServices.COMException (0x80004005): -2147159550
> > > at RSRemoteRpcClient.RemoteLogon.ThrowFriendlyRpcError(Int32
> mainError,
> > > Int32 extendedError)
> > > at RSRemoteRpcClient.RemoteLogon.ActivateService(String instanceID,
> > Int32
> > > clientType)
> > > at
> > >
Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
> > > -- End of inner exception stack trace --
> > > at
> > >
Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
> > > at
> > Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
> > > at
> > >
Microsoft.ReportingServices.Library.ConnectionManager.VerifyConnection()
> > > at
> > Microsoft.ReportingServices.Library.ConnectionManager.get_Connection()
> > > at Microsoft.ReportingServices.Library.Storage.get_Connection()
> > > at
> > >
Microsoft.ReportingServices.Library.Storage.NewStandardSqlCommand(String
> > > storedProcedureName)
> > > at
> > >
> >
>
Microsoft.ReportingServices.Library.DBInterface.GetOneConfigurationInfo(Stri
> > > ng key)
> > > at
> > >
> >
>
Microsoft.ReportingServices.Library.CachedSystemProperties.GetSystemProperty
> > > (String name)
> > > at
> > Microsoft.ReportingServices.Library.CachedSystemProperties.Get(String
> > > name)
> > > at
> > >
> >
>
Microsoft.ReportingServices.Library.CachedSystemProperties.GetParameter(Stri
> > > ng name)
> > > at
> Microsoft.ReportingServices.Library.RSService.get_MyReportsEnabled()
> > > at
> Microsoft.ReportingServices.Library.RSService.PathToInternal(String
> > > source)
> > > at
> > >
> Microsoft.ReportingServices.Diagnostics.CatalogItemContext.SetPath(String
> > > path, Boolean validate, Boolean convert, Boolean translate)
> > > at
> > >
> Microsoft.ReportingServices.Diagnostics.CatalogItemContext.SetPath(String
> > > path)
> > > at
> > >
> >
>
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPageCon
> > > tent()
> > > at
> > >
> >
>
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPage()
> > >
> > >
> >
> >
>

rsactivate error

I tray of run the rsactivate, show me the error.
*******************************************************
C:\>rsactivate -c "C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
Services\ReportServer\rsreportserver.config"
Failure starting the web service:
The local NT Service is not activated 0x800a0bcd
*******************************************************
I followed the installation instruction and the proccess that I attached
below.
*******************************************************
" Customer gave full permissions to IUSR, IWAM, and ASPNET users on the
following key using regedt32 and reinstalled SQL Server Reporting
Services successfully.
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Eventlog\Application"
Another case, the solution was:
"Since my default port does not use port 80, I had to change both the
server.config and rswebapplication.config files to use a different port. I
then ran the rsactivate command and all is now well."
I hope one of these will resolve your issue too.
From your descriptions, I understood that you cannot access Report server
and Report Manager via the web. Have I understood you? Correct me if I was
wrong.
First of all, what the error message from setup application. Was it "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."?
Secondly, please make sure that your Reporting Services Startup Account was
main account and it is also a part of the Local Admins group on the machine.
Based on my scope, it seems like something was wrong with the event source
Report Manager from log files and it likes an permission issue. Please take
the steps below and tell me what happened
1. go to http://localhost/ReportServer What's the error message? I expected
it to be "Event source: Report Manager does not exist"
2. run C:\WINDOWS\Microsoft.NET\Framework\v1.1.4322\aspnet_regiis.exe -i
assuming .net was installed in C:\WINDOWS\Microsoft.NET\)
3. open C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
Services\ReportServer\RSReportServer.config file. Search for this tag,
<InstallationID> and take the GUID (For example, the GUID for me is
{93850a3c-a856-4ce9-af25-6b3cdaa98dd8})
4. Use the GUID that we got before and try to remove the keys in the table
like this
RSKEYMGMT -R "{<guid>}"
5. Then run RSACTIVATE -C "C:\Program Files\Microsoft SQL
Server\MSSQL\Reporting Services\ReportServer\RSReportServer.config" > (make
sure the path is the one you installed Reporting Services)
If there is any error message shows here, please let me know and it is very
importantHi Antonio,
Sorry for the delay.
1. Run rskeymgmt with the -d argument to delete all encrypted content. You
can type rskeymgmt -? to get help about specific arguments.
2. Run rsconfig utility to specify report server connection information
(you must specify these arguments: -s, -d, -a, -u, -p). You can type
rsconfig -? to get help about specific arguments.
3. Restart both IIS and the ReportServer Windows service.
4. Run rsactivate utility to activate the server (you must specify these
arguments: -c, -u, -p). For argument -c, enclose the path information in
double-quotation marks. You can type rsactivate -? to get more help about
specific arguments.
Additionally, is it possible for you to reinstall the Reporting Services?
Sincerely yours,
Michael Cheng
Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
---
Get Secure! - http://www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!sql

RSActivate - how do I run it successfuly?

I am getting an error...
"The report server installation is not initialized. Check the documentation
for more information. (rsReportServerNotActivated)"
I went to the MSDN site to find a fix...
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsuiref/htm/cpu_rsconfig_v1_6yqq.asp
When I use rsactivate regardless of the switch I get...
Either the WMI provider or the path to the local config file must be specified
I have used the path to the BINN and the path to the rs config files, none
work.
Can you please send me the correct syntax and/ro path and/or utility?
Sincerelly and crossing my fingers that you will respond,
Vic ZDid you find a solution for your problem? I have a similar problem and havnt
found any good answers...
"DragonVic" wrote:
> I am getting an error...
> "The report server installation is not initialized. Check the documentation
> for more information. (rsReportServerNotActivated)"
> I went to the MSDN site to find a fix...
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsuiref/htm/cpu_rsconfig_v1_6yqq.asp
> When I use rsactivate regardless of the switch I get...
> Either the WMI provider or the path to the local config file must be specified
> I have used the path to the BINN and the path to the rs config files, none
> work.
> Can you please send me the correct syntax and/ro path and/or utility?
> Sincerelly and crossing my fingers that you will respond,
> Vic Z

rsAcessDenied when running the report

I got this error "

The permissions granted to user 'DomainName\UserName' are insufficient for performing this operation. (rsAccessDenied) " when I run the report. Somebody help me.

Manao

Check out the security permissions the folder where the report reisdes in and ensure that the userid or the group the user belongs to has at least browser access.

HTH

rsAccessDenied

I have a reportViewer control on a webform. In my partial class I set the report path, server and parameters in the Page_Load. When I run the report I get this error:

The permissions granted to user 'NT AUTHORITY\NETWORK SERVICE' are insufficient for performing this operation. (rsAccessDenied)

Here is my code:

Dim u As New UriTypeConverter
Dim ReportParameters(0) As ReportParameter

ReportParameters(0) = New ReportParameter("ProjectKey", 262)
rv.ShowParameterPrompts = False
rv.ServerReport.ReportServerUrl = u.ConvertFromString("http://localhost/ReportServer/")
rv.ServerReport.ReportPath = "/Test/Duplicate_MIU_Report"
rv.ServerReport.SetParameters(ReportParameters)

Have you properly granted permission for your web user? Go to the configuration tool, and look for any red X on the left hand side. Open the "Web service identity" and make sure your web user is 'NT AUTHORITY\NETWORK SERVICE". Then go to "Database Setup" panel. I think you are using "Service Credentials". Reapply the settings may fix your problem.|||

I have NT AUTHORITY\NetworkService as the service account (it is grayed out so it is not possible to change), and I have Service Credentials as the credentials type in the database setup. There are no red X's. Still get the same error.

In addition, I get this DCOM error in the system log:

The application-specific permission settings do not grant Local Activation permission for the COM Server application with CLSID

{BA126AD1-2166-11D1-B1D0-00805FC1270E}

to the user NT AUTHORITY\NETWORK SERVICE SID (S-1-5-20). This security permission can be modified using the Component Services administrative tool.

I'm not exactly sure what and how to do in Component Services admin tool.

|||

This thread may help you with the DCOM error:

http://forums.microsoft.com/MSDN/showpost.aspx?postid=258889&siteid=1

|||Netman has both local activation AND execution|||Do you see Network Services part of RSExec role in your report server catalog db and temp db?|||Yes|||Yes, Network Services is RSExec role in report server catalog db and temp db.|||It looks like Network Service account is not allowed to set parameters. I am not sure what is the mininum permission set. Can you try adding the account as a content manager to the home folder?|||If I right-click in design view in VS2005, the report runs fine. It doesn't work when I try to run in a browser and is being served up by my dev IIS server.|||I have added the NetworkService as administrator and still no go.|||That did it. Was confused in the ReportManager. Simple fix. Seems like lots of people having same problem. Thank you for your help|||Sorry--Don't follow what the fix was. What did it?|||

Went into Report Manager and gave NT Authority\NetworkService the necessary role assignments.

|||Thanks--got past that one, now I get to deal with the database access permissions lol...

rsAccessDenied

I have a reportViewer control on a webform. In my partial class I set the report path, server and parameters in the Page_Load. When I run the report I get this error:

The permissions granted to user 'NT AUTHORITY\NETWORK SERVICE' are insufficient for performing this operation. (rsAccessDenied)

Here is my code:

Dim u As New UriTypeConverter
Dim ReportParameters(0) As ReportParameter

In addition, I get this DCOM error in the system log:

The application-specific permission settings do not grant Local Activation permission for the COM Server application with CLSID

{BA126AD1-2166-11D1-B1D0-00805FC1270E}

to the user NT AUTHORITY\NETWORK SERVICE SID (S-1-5-20). This security permission can be modified using the Component Services administrative tool.

I'm not exactly sure what and how to do in Component Services admin tool.

|||

This thread may help you with the DCOM error:

http://forums.microsoft.com/MSDN/showpost.aspx?postid=258889&siteid=1

Went into Report Manager and gave NT Authority\NetworkService the necessary role assignments.

|||Thanks--got past that one, now I get to deal with the database access permissions lol...

Friday, March 30, 2012

rsInternalError (RSClientCOnnection.GetProperties)

rsInternalError

Wednesday, March 28, 2012

RSExecutionLog_Update.dtsx error!!

RSExecutionLog_Update.dtsx error!!

RSExecutionLog_Update.dts fails for named SQL Instance

rsErrorOpeningConnection

rsErrorOpeningConnection

RSCONFIG password problems

RsConfig -e command for Unattended execution

RSCONFIG did not modify RSReportServer.config all the way

Monday, March 26, 2012

RSClientPrint ActiveX causes client PC to reboot

RSClientPrint - Error on some clients

rsactivate error - trying to install on 2003 with Sharepoint servi

RSActivate Error

rsactivate error

RSActivate - how do I run it successfuly?

rsAcessDenied when running the report

rsAccessDenied

rsAccessDenied

RS and HTTPS

Blog Archive

About Me