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