Report Services Question

Hi all,
I wanted to be able to log on to Report Services from another computer (remotely), how can I go about doing that setup from either fresh installation or after installation? Or can anyone guide me to on where am I suppose to post this question in? Any help from anyone is appreciated.
Thanks in advance.
Daren

Daren,

I'm going to move your thread to the Reporting Services forum. They should be able to help you there.

-Jeffrey

|||ok,
thanks Jeffrey.
Daren
|||

Can you give more details about your problem? Are you talking about setting up Reporting Services from scratch on a remote machine or configuring RS after setup. All of the configuration tools that ship with Reporting Services can be used with remote machines.

-Albert

|||Hi Albert,
I will try to explain it as clearly as I possible can. To log into Reporting Services on local machine, we would use SQL Server Management Studio and select Reporting Services under Server Type section in Connect to server dialog. But now if I want to setup the server together with the Reporting Services on a server somewhere remotely (lets say on pc1). Can I remotely connect to the Reporting Services using the same way as above but try to connect using another machine (lets say pc2)?
If possible, what do I have to do to the current setup to achieve that? Or do I have to do a fresh installation with setup being done there to achieve the same result?
Hope this can explain clear enough for my question. Thank you for reading my questions and trying to answer it.
Daren
|||

Yes, you can connect to a Report Server on a remote computer using SQL Management Studio. You can install Reporting Services on pc1 and SQL Management Studio on pc2.

-Albert

|||Hi Albert,
Can you lead me on how can I do that? I tried connecting to the Server name on pc1 and it says cannot connect to server. How can I go about making the connection possible? Please help me on this. Thanks in advance.
Daren
|||

On the error message box, click the "show techincal details" button to display more information about the error. Could you please post the error details?

-Albert

|||Here is the error message: (I changed the ip to xxx.xxx.xxx.xxx)
===================================

Cannot connect to xxx.xxx.xxx.xxx.

===================================

The machine could not be found (Microsoft.SqlServer.Management.UI.RSClient)


Program Location:

at Microsoft.SqlServer.Management.UI.RSClient.RSConnectionInfo.ParseServerName(String serverName)
at Microsoft.SqlServer.Management.UI.RSClient.RSConnectionInfo.RSTypeImpl.CreateSqlOlapConnectionInfoBase(UIConnectionInfo ci)
at Microsoft.SqlServer.Management.UI.RSClient.RSConnectionInfo.RSTypeImpl.GetConnectionObject(UIConnectionInfo ci)
at Microsoft.SqlServer.Management.UI.ConnectionDlg.RSType.GetConnectionObject(UIConnectionInfo ci)
at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.ObjectExplorer.ValidateConnection(UIConnectionInfo ci, IServerType server)
at Microsoft.SqlServer.Management.UI.ConnectionDlg.Connector.ConnectionThreadUser()

Daren
|||

The error indicates that there's a problem connecting to the WMI service on the remote machine. You can verify WMI connectivity using the System Information tool. Run WinMSD.exe and select "Remote Computer" from the View menu. Enter the name of the remote computer. Does this work?

-Albert

|||Hi Albert,
I managed to run WinMSD.exe but I couldn't find any "Remote Computer" from the View menu, is it possible that I am using Windows 2000 Pro with SP4 that they do not have that funciton available?
I tried right clicking the "System Information" and select Properties, a "Select Computer" screen came up, I chose "Another computer" option and type in either the IP address or the computer name of the remote computer, the following error came out:

System Information
Access denied to Windows Management Instrumentation server on \\XXX. Have an administrator run WMI Control (WBEMCNTL.exe) and change your access permissions.
XXX is either the IP address or the remote computer name. But when I try to run WBEMCNTL.exe on remote computer, the file could not be found there. My remote computer is running the same OS (Windows 2000 Pro SP4).
Any idea how can I go about solving it? Thanks for helping me Albert.
Daren
|||

I think on Windows 2000, the WMI management tool is called WMIMGMT.MSC. See this article for troubleshooting WMI problems: http://www.microsoft.com/technet/scriptcenter/topics/help/wmi.mspx.

-Albert

|||Ok sorry to bother you again Albert,
I managed to get into my remote computer using WMI management tool and see the namespace for ReportServer under Security tab in "WMI Control (Remote computer name) Properties". But I still have the same problem connecting to remote computer Reporting Services in SQL Server Management Studio. How can I resolve it?
Thank you Albert for helping me up till now.
Daren
|||

Can you connect to the remote computer with WinMSD.exe?

-Albert

|||No I still cannot connect to the remote computer with WinMSD.exe, it still gives me the access denied error.
Daren

Report Server Password

I am in a panic right about now. We had to change the Admin (server) password and it is working fine to log on to Windows, but when I click on IE and navigate to the report server, it is asking me for the old password still. I am new to SRS, so I am learning as I go. I found some threads on using the rsconfig.exe and I fiddled around in it and now (in addition to requesting the old password to log on to the report server) all of the reports I created have a user name and password field that requires the SA password for connecting to the data source.

Is there any way I can fix this or do I just need to uninstall SRS from the server and re-install it? I found the following thread, but am a little skiddish about doing anything else in light of the current state I put the report server in.

https://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1031391&SiteID=1

Any suggestions?I got it, amd it was actually pretty simple. I just had to delete the folders from the Report Server (the ones you see when you go to the http://) and then re-build them.

Report Server Issue Object reference not set to an instance of an object

Hi all,

I'm getting this problem 'Object reference not set to an instance of an object.' whenever I try to review a report and I checked the log file and this is what it had

w3wp!ui!1!11/14/2006-10:54:20:: Unhandled exception: System.NullReferenceException: Object reference not set to an instance of an object.
at Microsoft.Reporting.WebForms.WebRequestHelper.GetExceptionForMoreInformationNode(XmlNode moreInfo, XmlNamespaceManager namespaces)
at Microsoft.Reporting.WebForms.WebRequestHelper.ExceptionFromWebResponse(Exception e)
at Microsoft.Reporting.WebForms.ServerReport.ServerUrlRequest(Boolean isAbortable, String url, Stream outputStream, String& mimeType, String& fileNameExtension)
at Microsoft.Reporting.WebForms.ServerReport.GetStyleSheet(String styleSheetName)
at Microsoft.Reporting.WebForms.ReportServerStyleSheetOperation.PerformOperation(NameValueCollection urlQuery, HttpResponse response)
at Microsoft.Reporting.WebForms.HttpHandler.ProcessRequest(HttpContext context)
at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)

Some previous forums stated checking the webconfig file but the web config file look okay. Is there another way to fix this.

Much Thanks,

Carl

All,

I forgot to mention that I can view the report okay in my local SQL development - When I deploy my reports to the Report Server I can not view the same reports in the Report Manager.

I get the ''Object reference not set to an instance of an object' where my report should be - Also I get this recorded in the log file:

Event Type: Warning
Event Source: ASP.NET 2.0.50727.0
Event Category: Web Event
Event ID: 1309
Date: 11/14/2006
Time: 1:39:03 PM
User: N/A
Computer: BOPIISDEV
Description:
Event code: 3005
Event message: An unhandled exception has occurred.

Event time: 11/14/2006 1:39:03 PM
Event time (UTC): 11/14/2006 7:39:03 PM

Event ID: 8dc01000f90d4cc39638a5abca4af97c
Event sequence: 16

Event occurrence: 1

Event detail code: 0

Application information:

Application domain: /LM/W3SVC/1/root/Reports-1-128080066085671029

Trust level: RosettaMgr

Application Virtual Path: /Reports

Application Path: C:\Program Files\Microsoft SQL Server\MSSQL.1\Reporting Services\ReportManager\

Machine name: BOPIISDEV
Process information:

Process ID: 5928

Process name: w3wp.exe

Account name: NT AUTHORITY\NETWORK SERVICE

Exception information:

Exception type: NullReferenceException

Exception message: Object reference not set to an instance of an object.
Request information:

Request URL: http://bopiisdev/Reports/Reserved.ReportViewerWebControl.axd?OpType=StyleSheet&Version=2005.090.1399.00

Request path: /Reports/Reserved.ReportViewerWebControl.axd

User host address: XXX.168.93.50

User: XXXX\cevans

Is authenticated: True

Authentication Type: Negotiate

Thread account name: NT AUTHORITY\NETWORK SERVICE

Thread information:

Thread ID: 1

Thread account name: NT AUTHORITY\NETWORK SERVICE

Is impersonating: True

Stack trace: at Microsoft.Reporting.WebForms.WebRequestHelper.GetExceptionForMoreInformationNode(XmlNode moreInfo, XmlNamespaceManager namespaces)
at Microsoft.Reporting.WebForms.WebRequestHelper.ExceptionFromWebResponse(Exception e)
at Microsoft.Reporting.WebForms.ServerReport.ServerUrlRequest(Boolean isAbortable, String url, Stream outputStream, String& mimeType, String& fileNameExtension)
at Microsoft.Reporting.WebForms.ServerReport.GetStyleSheet(String styleSheetName)
at Microsoft.Reporting.WebForms.ReportServerStyleSheetOperation.PerformOperation(NameValueCollection urlQuery, HttpResponse response)
at Microsoft.Reporting.WebForms.HttpHandler.ProcessRequest(HttpContext context)
at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)

|||

Hi Carl,

Did you ever solve this issue? I'm getting the same error.

Thanks,

Rob

Report Server Issue Object reference not set to an instance of an object

Hi all,

I'm getting this problem 'Object reference not set to an instance of an object.' whenever I try to review a report and I checked the log file and this is what it had

w3wp!ui!1!11/14/2006-10:54:20:: Unhandled exception: System.NullReferenceException: Object reference not set to an instance of an object.
at Microsoft.Reporting.WebForms.WebRequestHelper.GetExceptionForMoreInformationNode(XmlNode moreInfo, XmlNamespaceManager namespaces)
at Microsoft.Reporting.WebForms.WebRequestHelper.ExceptionFromWebResponse(Exception e)
at Microsoft.Reporting.WebForms.ServerReport.ServerUrlRequest(Boolean isAbortable, String url, Stream outputStream, String& mimeType, String& fileNameExtension)
at Microsoft.Reporting.WebForms.ServerReport.GetStyleSheet(String styleSheetName)
at Microsoft.Reporting.WebForms.ReportServerStyleSheetOperation.PerformOperation(NameValueCollection urlQuery, HttpResponse response)
at Microsoft.Reporting.WebForms.HttpHandler.ProcessRequest(HttpContext context)
at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)

Some previous forums stated checking the webconfig file but the web config file look okay. Is there another way to fix this.

Much Thanks,

Carl

All,

I forgot to mention that I can view the report okay in my local SQL development - When I deploy my reports to the Report Server I can not view the same reports in the Report Manager.

I get the ''Object reference not set to an instance of an object' where my report should be - Also I get this recorded in the log file:

Event Type: Warning
Event Source: ASP.NET 2.0.50727.0
Event Category: Web Event
Event ID: 1309
Date: 11/14/2006
Time: 1:39:03 PM
User: N/A
Computer: BOPIISDEV
Description:
Event code: 3005
Event message: An unhandled exception has occurred.

Event time: 11/14/2006 1:39:03 PM
Event time (UTC): 11/14/2006 7:39:03 PM

Event ID: 8dc01000f90d4cc39638a5abca4af97c
Event sequence: 16

Event occurrence: 1

Event detail code: 0

Application information:

Application domain: /LM/W3SVC/1/root/Reports-1-128080066085671029

Trust level: RosettaMgr

Application Virtual Path: /Reports

Application Path: C:\Program Files\Microsoft SQL Server\MSSQL.1\Reporting Services\ReportManager\

Machine name: BOPIISDEV
Process information:

Process ID: 5928

Process name: w3wp.exe

Account name: NT AUTHORITY\NETWORK SERVICE

Exception information:

Exception type: NullReferenceException

Exception message: Object reference not set to an instance of an object.
Request information:

Request URL: http://bopiisdev/Reports/Reserved.ReportViewerWebControl.axd?OpType=StyleSheet&Version=2005.090.1399.00

Request path: /Reports/Reserved.ReportViewerWebControl.axd

User host address: XXX.168.93.50

User: XXXX\cevans

Is authenticated: True

Authentication Type: Negotiate

Thread account name: NT AUTHORITY\NETWORK SERVICE

Thread information:

Thread ID: 1

Thread account name: NT AUTHORITY\NETWORK SERVICE

Is impersonating: True

Stack trace: at Microsoft.Reporting.WebForms.WebRequestHelper.GetExceptionForMoreInformationNode(XmlNode moreInfo, XmlNamespaceManager namespaces)
at Microsoft.Reporting.WebForms.WebRequestHelper.ExceptionFromWebResponse(Exception e)
at Microsoft.Reporting.WebForms.ServerReport.ServerUrlRequest(Boolean isAbortable, String url, Stream outputStream, String& mimeType, String& fileNameExtension)
at Microsoft.Reporting.WebForms.ServerReport.GetStyleSheet(String styleSheetName)
at Microsoft.Reporting.WebForms.ReportServerStyleSheetOperation.PerformOperation(NameValueCollection urlQuery, HttpResponse response)
at Microsoft.Reporting.WebForms.HttpHandler.ProcessRequest(HttpContext context)
at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)

|||

Hi Carl,

Did you ever solve this issue? I'm getting the same error.

Thanks,

Rob

Report Server Execution Log (Retrieve, Process, Render

The online help states under ther Report Server Execution Log the following
description for the Retrieve, Process, Render counters:
"Percentage of time spent retrieving the data, processing the report, and
rendering the report."
Shouldn't the three numbers added together match to 100%? What units are
these values depicted in?
In order to calculate duration in seconds I have taken the datediff in
seconds between starttime and endtime. I would assume there is a way to
calculate percent of time for retrieval, processing and rendering from this
value. Is this correct?
--
Thanks in Advance,
John KThis is a bug in the documentation. Thanks for pointing this out.
The values represent milli seconds and not percentage.
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"John K" <JohnK@.discussions.microsoft.com> wrote in message
news:2CF19C95-BCCA-454D-BF31-F624215B4A6D@.microsoft.com...
> The online help states under ther Report Server Execution Log the
> following
> description for the Retrieve, Process, Render counters:
> "Percentage of time spent retrieving the data, processing the report, and
> rendering the report."
> Shouldn't the three numbers added together match to 100%? What units are
> these values depicted in?
> In order to calculate duration in seconds I have taken the datediff in
> seconds between starttime and endtime. I would assume there is a way to
> calculate percent of time for retrieval, processing and rendering from
> this
> value. Is this correct?
>
> --
> Thanks in Advance,
> John K

Report Server Execution Log

Hi
Can enabling the Report Server Execution Log from the Site Settings affect the performance of the reports ?
Thanks
of course, but from what I've see, the act of logging is really invisible as far as a slowdown goes.|||

Also, you have the option to remove logs older than X days

not that it affects the performance really

We also have a SQL job that runs nightly, calling the SSIS package

C:\Program Files\Microsoft SQL Server\90\Samples\Reporting Services\Report Samples\Server Management Sample Reports\Execution Log Sample Reports\RSExecutionLog_Update.dtsx

I think it's from the RS template to display the RS Execution Log in graphs

report renders manually; subscription doesn't work

I can manually render and view a report, but my subscription to the same
report fails with this error in the log file:
ReportingServicesService!library!1210!07/19/2005-15:20:55:: e ERROR:
Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException:
The Report Server has encountered a configuration error; more details in the
log files, AuthzInitializeContextFromSid: Win32 error: 1355;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException:
The Report Server has encountered a configuration error; more details in the
log files
ReportingServicesService!library!1210!07/19/2005-15:20:55:: i INFO:
Initializing EnableExecutionLogging to 'True' as specified in Server system
properties.
ReportingServicesService!emailextension!1210!07/19/2005-15:20:55:: Error
sending email. Microsoft.ReportingServices.Diagnostics.Utilities.RSException:
The Report Server has encountered a configuration error; more details in the
log files -->
Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException:
The Report Server has encountered a configuration error; more details in the
log files
at
Microsoft.ReportingServices.Authorization.Native.GetAuthzContextForUser(IntPtr userSid)
at Microsoft.ReportingServices.Authorization.Native.IsAdmin(String
userName)
at
Microsoft.ReportingServices.Authorization.WindowsAuthorization.IsAdmin(String
userName, IntPtr userToken)
at
Microsoft.ReportingServices.Authorization.WindowsAuthorization.CheckAccess(String
userName, IntPtr userToken, Byte[] secDesc, ReportOperation requiredOperation)
at Microsoft.ReportingServices.Library.Security.CheckAccess(ItemType
catItemType, Byte[] secDesc, ReportOperation rptOper)
at
Microsoft.ReportingServices.Library.RSService._GetReportParameterDefinitionFromCatalog(CatalogItemContext
reportContext, String historyID, Boolean forRendering, Guid& reportID, Int32&
executionOption, String& savedParametersXml, ReportSnapshot&
compiledDefinition, ReportSnapshot& snapshotData, Guid& linkID, DateTime&
historyDate)
at
Microsoft.ReportingServices.Library.RSService._GetReportParameters(String
report, String historyID, Boolean forRendering, NameValueCollection values,
DatasourceCredentialsCollection credentials)
at
Microsoft.ReportingServices.Library.RSService.RenderAsLiveOrSnapshot(CatalogItemContext
reportContext, ClientRequest session, Warning[]& warnings,
ParameterInfoCollection& effectiveParameters)
at
Microsoft.ReportingServices.Library.RSService.RenderFirst(CatalogItemContext
reportContext, ClientRequest session, Warning[]& warnings,
ParameterInfoCollection& effectiveParameters, String[]& secondaryStreamNames)
at Microsoft.ReportingServices.Library.RenderFirstCancelableStep.Execute()
at
Microsoft.ReportingServices.Diagnostics.CancelablePhaseBase.ExecuteWrapper()
-- End of inner exception stack trace --
at
Microsoft.ReportingServices.Diagnostics.CancelablePhaseBase.ExecuteWrapper()
at
Microsoft.ReportingServices.Library.RenderFirstCancelableStep.RenderFirst(RSService
rs, CatalogItemContext reportContext, ClientRequest session, JobTypeEnum
type, Warning[]& warnings, ParameterInfoCollection& effectiveParameters,
String[]& secondaryStreamNames)
at Microsoft.ReportingServices.Library.ReportImpl.Render(String
renderFormat, String deviceInfo)
at
Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.ConstructMessageBody(IMessage message, Notification notification, SubscriptionData data)
at
Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.CreateMessage(Notification notification)
at
Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.Deliver(Notification notification)
ReportingServicesService!notification!1210!07/19/2005-15:20:55::
Notification e07ed229-a912-4843-b66f-fb15c2af2596 completed. Success: False,
Status: Failure sending mail: The Report Server has encountered a
configuration error; more details in the log files, DeliveryExtension: Report
Server Email, Report: <report name>, Attempt 0
I have verified that the SMTP service is working, and there is no
undelivered mail in the mailroot.
Any ideas?
--
Berry Morgan
JSOHi Berry,
Based on my experience, the KB article 834859 probably applies to the issue
related to email delivery on your computer. As mentioined in the KB 834859,
there is a known issue that AuthzInitializeContextFromSid function passes a
non-null-terminated string to the DsGetDcName function. Apparently this
issue potentially cause problems when Reporting Services tries to use this
function.
To resolve this problem immediately, please contact Microsoft Product
Support Services to obtain the hotfix. For a complete list of Microsoft
Product Support Services phone numbers and information about support costs,
visit the following Microsoft Web site:
http://support.microsoft.com/default.aspx?scid=fh;[LN];CNTACTMS
Note In special cases, charges that are ordinarily incurred for support
calls may be canceled if a Microsoft Support Professional determines that a
specific update will resolve your problem. The usual support costs will
apply to additional support questions and issues that do not qualify for
the specific update in question.
You may also want to apply Windows 2003 SP1 which includes this hotfix.
If the issue persists, I suggest that you refer to the following article to
troubleshoot the issue:
842423 A call to the AuthzInitializeContextFromSid API function may fail
during
http://support.microsoft.com/?id=842423
If anything is unclear, feel free to let us know.
Sincerely,
William Wang
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================
Business-Critical Phone Support (BCPS) provides you with technical phone
support at no charge during critical LAN outages or "business down"
situations. This benefit is available 24 hours a day, 7 days a week to all
Microsoft technology partners in the United States and Canada.
This and other support options are available here:
BCPS:
https://partner.microsoft.com/US/technicalsupport/supportoverview/40010469
Others: https://partner.microsoft.com/US/technicalsupport/supportoverview/
If you are outside the United States, please visit our International
Support page:
http://support.microsoft.com/default.aspx?scid=%2finternational.aspx.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.