Analysis Services - Step by Step: Errors related to feature availability and configuration

On page 56 of SQL Server 2005 Analysis Services Step by Step, I tried to DEPLOY the project, and it failed with this msg:

Errors related to feature availability and configuration: The 'Measure expressions' feature is not included in the 'Standard Edition' SKU.

Is it because of my Standard Edition? If it is, could I change the 'Measure expressions' some how to get by this msg and go on with the book?

Yes, you are running into this situation because you working against Standard edition of SQL Server Analysis Services.

You can install free trial edition from http://www.microsoft.com/sql/downloads/trial-software.mspx. It has full set of features for you to comlete any tutorial.

As for the steps described in the book, or how to work around them. You should point your questions to the authors of the book.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

|||

Thanks Edward. I'll try with the trial edition.

I was also trying to post the question to the authors, but I could not find the link to it.

|||

Hi mate

I have the same problem. Could you tell me how to fix this issue please. I'm using SQL 2005 standand version. Does it cause the problem? Please tell me as soon as possible.

thank you in adv

Wen Ou

|||I have the same problem. I am also interested in a fix, not the trial version. Could someone please let me know how to change the configuration of the cube.sql

Analysis Services - Step by Step: Errors related to feature availability and configuration

On page 56 of SQL Server 2005 Analysis Services Step by Step, I tried to DEPLOY the project, and it failed with this msg:

Errors related to feature availability and configuration: The 'Measure expressions' feature is not included in the 'Standard Edition' SKU.

Is it because of my Standard Edition? If it is, could I change the 'Measure expressions' some how to get by this msg and go on with the book?

Yes, you are running into this situation because you working against Standard edition of SQL Server Analysis Services.

You can install free trial edition from http://www.microsoft.com/sql/downloads/trial-software.mspx. It has full set of features for you to comlete any tutorial.

As for the steps described in the book, or how to work around them. You should point your questions to the authors of the book.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

|||

Thanks Edward. I'll try with the trial edition.

I was also trying to post the question to the authors, but I could not find the link to it.

|||

Hi mate

I have the same problem. Could you tell me how to fix this issue please. I'm using SQL 2005 standand version. Does it cause the problem? Please tell me as soon as possible.

thank you in adv

Wen Ou

|||I have the same problem. I am also interested in a fix, not the trial version. Could someone please let me know how to change the configuration of the cube.

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 instance of the SQL Server Reconciler error object cannot be created

I've got the following server configuration.

Database Server

- Windows 2003 Standard

- MSSQL 2000 sp4

Web Server

- Windows 2003 Standard

- SQL 2000 sp4 replication components

- SQL Mobile 2005 Server tools

The database server published out the snapshot to a share on the web server. This bit is working file, I can see the snapshot contents etc. When I connect from my own pc using SQL Management Studio and attempt to set up a subscription to a Mobile database, I get the following error.

TITLE: Microsoft SQL Server Management Studio

An instance of the SQL Server Reconciler error object cannot be created. Try reinstalling the replication components.
HRESULT 0x8007007E (28010)

BUTTONS:

OK

I've also accessed the Url using diagnostics and get the following output:

 SQL Server Mobile Server Agent Diagnostics

 2006/01/13 10:09:10

*General Information*Item Value
Server Name bundy
URL /services/taskmobileserversync/sqlcesa30.dll
Authentication Type Anonymous
Server Port 80
HTTPS off
Server Software Microsoft-IIS/6.0
Replication Allowed
RDA Allowed
Logging Level 1

*Impersonation and Access Tests* Action Status ErrorCode
Impersonate User SUCCESS 0x0
ReadWriteDeleteMessageFile SUCCESS 0x0

*SQL Server Mobile Modules Test*Module Status ErrorCode Version
SQLCERP30.DLL SUCCESS 0x0 3.0.5206.0
SQLCESA30.DLL SUCCESS 0x0 3.0.5206.0

*Reconciler Test* Reconciler Status ErrorCode
9.0 Database Reconciler FAILURE 0x80040154
8.0 Database Reconciler FAILURE 0x8007007E

*SQL Server Module Versions* Module Version
sqloledb.dll 2000.85.1022.0
8.0 replrec.dll 2000.80.2038.0
8.0 replprov.dll 2000.80.2038.0
8.0 msgprox.dll 2000.80.2038.0

Any suggestions? I've reinstalled the various components on the Web Server quite a few times by now...

thanks

// charlie

Search for REPLERRX.DLL and register using regsvr32. And then try. If the registration fails for this DLL, just check whether you have all the dependant DLLs. There are tools to find out the dependant DLLs of a particular binary. Most probably you may need to have MSVCR71.DLL and MSVCP71.DLL. However these two DLLs are already packaged in the 'SQL Server 2000 SP4 Replication Components' setup package. There is some problem in the installation I believe. If you could register REPLERRX.DLL, then you should be able to sync.

Thanks,

Laxmi NRO, MSFT, SQL Mobile, Microsoft Corporation

|||To fix this, I installed the SQL Server 2000 client tools. This resolved the problem.|||

Thanks for letting us know the information.

Thanks,

Laxmi Narsimha Rao ORUGANTI, MSFT, SQL Mobile, Microsoft Corporation