We have a user in the System Administrator and System User roles of
2005 SSRS. He is able to connect to the website
(http://<servername>/Reports) and do whatever he needs to do.
But, when he tries to connect to Reporting Services in Management
Studio, he receives the following error:
===================================
Cannot connect to <servername>.
===================================
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()
I added him to the Distributed COM Users group, in DCOM security I
added him to the Default Launch and Activation Permissions (Local
Launch, Remote Launch, Local Activation, Remote Activation), I gave him
all permissions to the root namespace (and sub-namespaces) in wmi.
After giving him these permissions, the error message changes slightly
(no longer does he get 'the machine name cannot be found'):
Program
Location:
at
System.Runtime.InteropServices.Marshal.ThrowExceptionForHRInternal(Int32
errorCode, IntPtr errorInfo)
at
System.Management.ManagementObjectCollection.ManagementObjectEnumerator.MoveNext()
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()
If
I add him to the local administrators group, he can connect using
Management Studio. But, that is not what we want to do. And, in fact,
we want to revoke any of these extra permissions that we have assigned
in order to try to get this working. Does anyone know what permissions
a person needs (likely in the OS) for connecting to Reporting Services
in Management Studio?
Thanks,
Michelle
Try granting permissions on \root\Microsoft\SqlServer\ReportServer\v9 namespace to Everyone.
As a workaround you can type in the url to report server instead of machine name. This will cause management studio to not go through the WMI code path to resolve report server url.
|||Thanks! The workaround worked. The dba usedhttp://<servername>/reportserver for the server name in
Management Studio and is able to connect to Reporting Services.
Michelle
No comments:
Post a Comment