OLAP Analysis Services: Errors in Encryption Library

Hi!

I am trying to process a cube in analysis services of visual studio
2005, with sql server 2005. The error is:

"Errors in the encryption library: Failed to encrypt sensitive data.
Possibly the encryption key is inaccessible because of improper service
account change."

Thanks in advance,

--Dimitris Doukas

You might have changed the account for your Analysis Server service.

To solve this problem you will have to stop Analysis Server. Remove all the files from the Data folder ( located under installation folder) and then start Analysis Server again.

Create a backup for your existing databases before doing that in case you cannot re-process them.

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

|||

It worked. Thanks a lot.

--Dimitris

ODBC wire encryption

Is there a method to enable an ODBC client to encrypt all communications
between the client and the server?
I have a client that is having a cow about data moving over the network via
an ODBC driver to DBMS server unencrypted.
I haven't seen or heard of an option like this before but thought I would
ask.
Our application communicates with SQL Server and Oracle 9i via the vendors
native ODBC drivers.
Tony
ODBC is just an API. It's up to the individual drivers/DBMSes to perform
any encryption.
I'm not familiar with Oracle, but SQL Server supports encryption between
client and server.
If I remember correctly, there are two methods of encryption with SQL
Server. In one method, you install an SSL certificate on the server. This
enables encryption, and REQUIRES that all client connections to the server
use encryption. The other method involves installing a certificate on the
client. This allows single clients to use encryption, without requiring
encryption across-the-board, but has the downside that you can't require
encryption in situations that you WANT it.
My understanding is that the first method is MUCH easier to setup. There
are some gotchas though. If the server is configured with a certificate,
and there is something wrong with the certificate, then the server will fail
to start.
There should be plenty of documentation on this on the web.
Brannon
"Tony" <tonyng2@.spacecommand.net> wrote in message
news:#D9JqJumEHA.2948@.TK2MSFTNGP11.phx.gbl...
> Is there a method to enable an ODBC client to encrypt all communications
> between the client and the server?
> I have a client that is having a cow about data moving over the network
via
> an ODBC driver to DBMS server unencrypted.
> I haven't seen or heard of an option like this before but thought I would
> ask.
> Our application communicates with SQL Server and Oracle 9i via the vendors
> native ODBC drivers.
> Tony
>