Prev: Install RS failed, message said "sufficient privileges"
Next: How to suppress a field if it is null
From: Tony Bravo on 22 Jan 2006 18:28
Does anyone know why attempting to connect to Reporting Servies via SQL
Server 2005 Management Studio or the Configuration tool raises this error?

Here's the text of the error message:

TITLE: Connect to Server
------------------------------

Cannot connect to HPNOTEBOOK01.

------------------------------
ADDITIONAL INFORMATION:

Provider load failure (System.Management)

------------------------------
BUTTONS:

OK
------------------------------

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

Provider load failure (System.Management)

------------------------------
Program Location:

at
System.Management.ManagementException.ThrowWithExtendedInfo(ManagementStatus
errorCode)
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()

Thanks
Tony

From: geoff on 23 Jan 2006 00:13
I don't know why you are receiving this, but I am receiving the same message
and error detail. Stumbled on the problem trying to troubleshoot e-mail
subscription problem that I have been battling since moving from 2000 to
2005. Hope to see some help on this.

"Tony Bravo" wrote:

> Does anyone know why attempting to connect to Reporting Servies via SQL
> Server 2005 Management Studio or the Configuration tool raises this error?
>
> Here's the text of the error message:
>
> TITLE: Connect to Server
> ------------------------------
>
> Cannot connect to HPNOTEBOOK01.
>
> ------------------------------
> ADDITIONAL INFORMATION:
>
> Provider load failure (System.Management)
>
> ------------------------------
> BUTTONS:
>
> OK
> ------------------------------
>
> ===================================
>
> Provider load failure (System.Management)
>
> ------------------------------
> Program Location:
>
> at
> System.Management.ManagementException.ThrowWithExtendedInfo(ManagementStatus
> errorCode)
> 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()
>
> Thanks
> Tony
>
From: Lianghong on 15 Feb 2006 15:18
I got the same error. I installed the SQL Server 2005 side by side with my
SQL Server 2000 at first, and I got the error. I then uninstalled both SQL
server 2000 and 2005 and reinstalled SQL server 2005, now I still get the
same error. Any one has any idea? Thanks.

"geoff" wrote:

> I don't know why you are receiving this, but I am receiving the same message
> and error detail. Stumbled on the problem trying to troubleshoot e-mail
> subscription problem that I have been battling since moving from 2000 to
> 2005. Hope to see some help on this.
>
> "Tony Bravo" wrote:
>
> > Does anyone know why attempting to connect to Reporting Servies via SQL
> > Server 2005 Management Studio or the Configuration tool raises this error?
> >
> > Here's the text of the error message:
> >
> > TITLE: Connect to Server
> > ------------------------------
> >
> > Cannot connect to HPNOTEBOOK01.
> >
> > ------------------------------
> > ADDITIONAL INFORMATION:
> >
> > Provider load failure (System.Management)
> >
> > ------------------------------
> > BUTTONS:
> >
> > OK
> > ------------------------------
> >
> > ===================================
> >
> > Provider load failure (System.Management)
> >
> > ------------------------------
> > Program Location:
> >
> > at
> > System.Management.ManagementException.ThrowWithExtendedInfo(ManagementStatus
> > errorCode)
> > 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()
> >
> > Thanks
> > Tony
> >
From: Melissa on 23 Feb 2006 16:28
Did anyone ever find a solution to this? We have a similar problem.

Thanks!
Melissa

From: Ganesh on 2 Mar 2006 21:18
Hi,
I'm also having the same problem. Not able to connect to Reporting
Services via Management studio.
Actually I was able to connect earlier. Then sometime back, I renamed
my local website in IIS and I got hell lot of problems. So I renamed it
back to the old name. Now, I'm not able to connect? Does anyone has the
solution?

In another post, someone was asking to change URLScan.ini file to allow
POST verb? I don't know what it means. Can anyone please tell me where
can I find this URLScan.ini file and wat it means?

Thanks!

 | 
Pages: 1
Prev: Install RS failed, message said "sufficient privileges"
Next: How to suppress a field if it is null