Analysis Services - Provider cannot be found

I've got a big problem with the Analysis Services.
I have a SQL Server 2000 SP3 and the Analysis Services SP3 running. The SQL Server has no problems.
When I try to browse the Data of any cube, the following error message occurs:
"Provider cannot be found. It may not be properly installed." When I try to browse other cubes after this, the error message "unknown error" occurs.
The databases, on which the cubes are based are both Access2k and SQL Server 2k. The error even appears at the test cubes from Microsoft, so it cannot be simply a problem of the database.

Much thx for your answers.Try to restart the services on the machine.|||That would be an easy solution. I tried it at first. :-)
It didn't change anything.|||Are you trying to browse from WINXP? If so, you'll need to install sp3 for analysis services on the client.|||I could solve the problem. I had an error when installing sp3 for analysis services on the server. I didn't take notice of it. Later I checked the Version number and recognized, that sp3 was not installed. I installed sp3 again and then it works.

greets,
Stefan

Analysis manager cube processing error

I am trying to process a cube and during processing I get a message that " Data source provider error :[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified..." I set up my data connections and everything else as it appeared in the tutorial. I am running XP Professional and MS Server 2000.To validate your connection create a file on your desktop with UDL extension. Double-click on it and fill in the blanks. Once done, - rename the file to .TXT and open it in notepad. Modify as needed and use it.|||I did all this and still I don't get the cubes to process. Do I need to rename the file to UDL after everything? When I process now I get the message "Data Source Provider Error:[Microsoft][ODBC Driver Manager]Driver's SQLSetConnectAttr failed;IM006..." What should the provider name be in the UDL file? Mine says MSDASQL.1|||As an example, here is what I have in notepad after I create a connection:

[oledb]
; Everything after this line is an OLE DB initstring
Provider=MSDASQL.1;Persist Security Info=False;Extended Properties="driver={sql server};server=l6064909;database=master;trusted_co nnection=true"|||I got the cube to process, now when I click on browse data I get a message that states "Unable to browse the cube 'Sales'. Unspecified error." Is this because of the service pack?

An unknown error occurred in the WMI provider. Error Code 8000000A

Hi,

I just installed SQL Server 2005 on Windows Vista.
I am getting an error "An unknown error occurred in the WMI
provider. Error Code 8000000A" when connecting to a web server. The
reporting services is running. Is there any other installation that is
missing. Please help.

Reporting Services is not supported on Windows Vista until SP2 of SQL Server 2005 is available. It is due out early next year. If you are an SP2 preview customer, you can try it before then. You can find out about this program at: http://www.microsoft.com/sql/ctp.mspx

|||Hi,
I have just received the same error message when opening then Reporting Services configuration tool. The server is running MS Windows Server 2003 Standard Edition with Service Pack 1 and SQL Server 2005 Standard Edition with Service Pack 1. I don't have local administrator rights, but I am an administrator for SQL Server and I am in the system administrator group for Reporting Services.
I have already made done some web research, but all I have found was related to Windows Vista only.
Thanx for any help and best regards,
Gerald|||I am having the same problem as described for Server 2003. Do we just need to try SP2?

An unknown error occurred in the WMI provider. Error Code 8000000A

Hi,

I just installed SQL Server 2005 on Windows Vista.
I am getting an error "An unknown error occurred in the WMI
provider. Error Code 8000000A" when connecting to a web server. The
reporting services is running. Is there any other installation that is
missing. Please help.

Reporting Services is not supported on Windows Vista until SP2 of SQL Server 2005 is available. It is due out early next year. If you are an SP2 preview customer, you can try it before then. You can find out about this program at: http://www.microsoft.com/sql/ctp.mspx

|||Hi,
I have just received the same error message when opening then Reporting Services configuration tool. The server is running MS Windows Server 2003 Standard Edition with Service Pack 1 and SQL Server 2005 Standard Edition with Service Pack 1. I don't have local administrator rights, but I am an administrator for SQL Server and I am in the system administrator group for Reporting Services.
I have already made done some web research, but all I have found was related to Windows Vista only.
Thanx for any help and best regards,
Gerald

|||I am having the same problem as described for Server 2003. Do we just need to try SP2?

An Unknown error has occured in WMI provider

Hi All,

I am new to sql server 2005.

I tried to connect to reporting services configuration manager.

it gives an error

An Unknown error has occured in WMI provider.

error code 80040219.

so please help me out regarding this issue.

Hi sandy_patil,
I encounter the same error as well. Did you manage to fix this error?

Daren|||I have the same error.

Uninstalled SQL Server 2005 Express and installed SQL Server 2005 Standard edition. Go to configure the "Report Service" and got the same error. Uninstalled 2005 many times and still not working.

Henry|||

I had the same problem, accompanied by the following error in the event log:

The description for Event ID ( 133 ) in Source ( Report Server ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following information is part of the event: C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer\RSReportServer.config.

Since the system seemed to be looking for
C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer\RSReportServer.config
I tried copying another of the MSSQL.x directories (containing Reporting Services) to
C:\Program Files\Microsoft SQL Server\MSSQL.3

I'm not sure if this is a complete solution, but it resolved the 8004219 error. It will be interesting to see if it causes any other problems.

|||

I eventually realized that the MSSQL.3 reference was related to an instance called "SQL2005" that was left over from a previous install of an SQL Server evaluation copy. The mysterious "SQL2005" instance kept reappearing so many times that I started thinking it was supposed to be there. After finally getting rid of it (not fun), I think the 80040219 error might be solved correctly now.

Here are some links about manually removing a stubborn instance:
http://support.microsoft.com/kb/909967
http://blogs.msdn.com/astebner/archive/2005/09/13/465401.aspx
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=354408&SiteID=1

Neither msiexec nor msizap were very effective for me. I eventually found myself deleting files and registry entries manually, with my fingers crossed ...

|||Thanks for the tips. I eventaully uninstall sql server 2005 and followed this simple steps http://blogs.msdn.com/astebner/archive/2005/12/08/501885.aspx
to remove old instance. It works now.sql

An Unknown error has occured in WMI provider

Hi All,

I am new to sql server 2005.

I tried to connect to reporting services configuration manager.

it gives an error

An Unknown error has occured in WMI provider.

error code 80040219.

so please help me out regarding this issue.

Hi sandy_patil,
I encounter the same error as well. Did you manage to fix this error?

Daren|||I have the same error.

Uninstalled SQL Server 2005 Express and installed SQL Server 2005 Standard edition. Go to configure the "Report Service" and got the same error. Uninstalled 2005 many times and still not working.

Henry|||

I had the same problem, accompanied by the following error in the event log:

The description for Event ID ( 133 ) in Source ( Report Server ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following information is part of the event: C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer\RSReportServer.config.

Since the system seemed to be looking for
C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer\RSReportServer.config
I tried copying another of the MSSQL.x directories (containing Reporting Services) to
C:\Program Files\Microsoft SQL Server\MSSQL.3

I'm not sure if this is a complete solution, but it resolved the 8004219 error. It will be interesting to see if it causes any other problems.

|||

I eventually realized that the MSSQL.3 reference was related to an instance called "SQL2005" that was left over from a previous install of an SQL Server evaluation copy. The mysterious "SQL2005" instance kept reappearing so many times that I started thinking it was supposed to be there. After finally getting rid of it (not fun), I think the 80040219 error might be solved correctly now.

Here are some links about manually removing a stubborn instance:
http://support.microsoft.com/kb/909967
http://blogs.msdn.com/astebner/archive/2005/09/13/465401.aspx
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=354408&SiteID=1

Neither msiexec nor msizap were very effective for me. I eventually found myself deleting files and registry entries manually, with my fingers crossed ...

|||Thanks for the tips. I eventaully uninstall sql server 2005 and followed this simple steps http://blogs.msdn.com/astebner/archive/2005/12/08/501885.aspx
to remove old instance. It works now.

An error about & quot;[dbnmpntw]ConnectionOpen(CreateFile())".

Hi:
When I tried to connect SQL Server Databse which was on another machine,
using Microsoft OLEDB Provider for SQL Server, error 0x80040005 was
returned, and the error message was
"& #91;dbnmpntw]ConnectionOpen(CreateFile()
)".Hi,
Use the SQL Client Configuration utility (from the machine u are connecting)
to create alias server name for the sql server using the TCP/IP protocol
specifying IP and port number.
And use this Alias name to connect to SQL server using TCP/IP
Thanks
Hari
MCDBA
"arxing" <cjx@.nbdx.cn> wrote in message
news:eAfe$8PWEHA.4092@.TK2MSFTNGP11.phx.gbl...
> Hi:
> When I tried to connect SQL Server Databse which was on another
machine,
> using Microsoft OLEDB Provider for SQL Server, error 0x80040005 was
> returned, and the error message was
> "& #91;dbnmpntw]ConnectionOpen(CreateFile()
)".
>|||But if I don't installed SQL Client on the machine I am connecting, what can
I do?
thanks.
"Hari" <hari_prasad_k@.hotmail.com> д?
news:elatIOQWEHA.1128@.TK2MSFTNGP10.phx.gbl...
> Hi,
> Use the SQL Client Configuration utility (from the machine u are
connecting)
> to create alias server name for the sql server using the TCP/IP protocol
> specifying IP and port number.
> And use this Alias name to connect to SQL server using TCP/IP
> --
> Thanks
> Hari
> MCDBA
> "arxing" <cjx@.nbdx.cn> wrote in message
> news:eAfe$8PWEHA.4092@.TK2MSFTNGP11.phx.gbl...
> machine,
>|||You can also do this using the wizard to set up an ODBC=20
data source. Use the Client Configuration button.

>--Original Message--
>But if I don't installed SQL Client on the machine I am=20
connecting, what can
>I do?
>thanks.
>
>"Hari" <hari_prasad_k@.hotmail.com> =D0=B4=C8=EB=D3=CA=BC=FE
>news:elatIOQWEHA.1128@.TK2MSFTNGP10.phx.gbl...
machine u are[vbcol=seagreen]
>connecting)
the TCP/IP protocol[vbcol=seagreen]
TCP/IP[vbcol=seagreen]
was on another[vbcol=seagreen]
0x80040005 was[vbcol=seagreen]
>
>.
>|||You can also do this when you set up the ODBC data source.=20
Use the Client Configuration button in the wizard.

>--Original Message--
>But if I don't installed SQL Client on the machine I am=20
connecting, what can
>I do?
>thanks.
>
>"Hari" <hari_prasad_k@.hotmail.com> =D0=B4=C8=EB=D3=CA=BC=FE
>news:elatIOQWEHA.1128@.TK2MSFTNGP10.phx.gbl...
machine u are[vbcol=seagreen]
>connecting)
the TCP/IP protocol[vbcol=seagreen]
TCP/IP[vbcol=seagreen]
was on another[vbcol=seagreen]
0x80040005 was[vbcol=seagreen]
>
>.
>|||This utility is available even if you didn't install the SQL Client tools -
start -> run -> Cliconfg.exe.
Richard Waymire, MCSE, MCDBA
This posting is provided "AS IS" with no warranties, and confers no rights.
"arxing" <cjx@.nbdx.cn> wrote in message
news:O3sk4WSWEHA.4048@.TK2MSFTNGP12.phx.gbl...
> But if I don't installed SQL Client on the machine I am connecting, what
> can
> I do?
> thanks.
>
> "Hari" <hari_prasad_k@.hotmail.com> д?
> news:elatIOQWEHA.1128@.TK2MSFTNGP10.phx.gbl...
> connecting)
>

An attempt has been made to use a data extension 'DLLName' that is not registered for this

Hello,

I've created my own data extension which uses ADODB.NET (OleDB Provider) and connects to the named SQL instance. During the development phase of the report I can connect to my data source, retrieve data from it and display it in the report preview with no problems. But as soon as I want to deploy this report and my data source I get the message: “An attempt has been made to use a data extension 'DLLName' that is not registered for this report server.". I went thru all *.config files and set up them up as per instructions how to. I can see my extension in the combo box during designing my report which tells me that this is done correctly. I can create the report in the preview as well. But whatever I do, when I want to deploy it I'm always getting this message.

I've come across one post where it says that Reporting Services are limited to the default, unnamed instance of SQL Server (local). I don't think it should matter to me in this case because I'm using my OleDB Provider to connect to the database. Report doesn't know anything about it. It gets data from my extension, not directly from the database. But I've tried switching from my named instance to (local) just to see if it is going to work, but no luck.

I'd appreciate somebody giving me some suggestions on this issue.

Thanks...

did you update rssrvpolicy.config to grant fulltrust to your extension? Usually this error message appears when report server gets an exception when loading the extension, and this usually happens when extension is not trusted or it fails in constructor. The fact that it works in report designer (which runs everything in fulltrust by default) most likely means that extension is not getting fulltrust when loaded on server.|||

Yes I did. Here is the code from the rssrvpolicy.config:

<CodeGroup class="UnionCodeGroup" version="1" PermissionSetName="FullTrust" Name="MyCodeGroup" Description="Code group My data processing extension">

<IMembershipCondition class="UrlMembershipCondition" version="1" Url="C:\Program Files\Microsoft SQL Server\MSSQL.4\Reporting Services\ReportServer\bin\My.dll"/>

</CodeGroup>

But it still doens't work. I still am getting the same message when I try to deploy my report.

Any suggestions would be appreciated.

Thanks...