I'm trying to deploy a solution from Analysis services tutorial (the
one corresponding to Lesson 4).

I'm getting the following error:
Error 1 Errors in the encryption library: Failed to encrypt sensitive
data. Possibly the encryption key is inaccessible because of improper
service account change. 0 0

All SQL server services are running as Local System.

The Tools\Samples\Adventure Works.sln deploys fine.

(Using June CTP on Win2k3)

What's the fix?

Thanks,
Hari Donthi

Deleting all the files in :\Program Files\Microsoft SQL
Server\MSSQL.2\OLAP\Data (as Raman Iyer had suggested for another
issue) got rid of the problem.

Can I employ this as a general trick on a production system ?

What's in the OLAP/data directory? Is this easily regenerated?

Thanks,
Hari Donthi

The Data directory is the storage location where Analysis Server persists
all its database files, including your processed cubes/models. In general,
you should delete the folder only as a last resort in a production system
because you will need to re-deploy all your projects to recreate your
databases.

Encryption errors like the one you reported earlier are mostly due to a
change in the domain account you run the Analysis Server under, since we
encrypt the data using those credentials. The askeymgmt.exe utility can help
you with such account changes.

--
-Raman Iyer
SQL Server Data Mining
[This posting is provided "AS IS" with no warranties, and confers no
rights.]

"Hari Donthi" <hari.donthi (AT) gmail (DOT) com> wrote

I am getting this exact same message in trying to use the Analysis Services
Migration Wizard during the *** Migrating databases *** step (preparing went
with no major issues).

We did respecify the account under which Analysis Services runs since we
initially installed A/S April CTP, NOT using SQL Server Management Studio
(but rather using Service Control Manager). We did not backup the instance
encryption key. The user account under which A/S was initially installed is
no longer available (little bit of a long story). But now I am
wondering...whither the way out?

Am looking for more insights re use of utility you mention below and/or any
other insights that might help. The "-r" option with askeymgmt.exe returned
the same error message once more and the "-e -i" option just hangs.

Any tips would be appreciated! As we are trying to migrate in an existing
A/S 2000 database, perhaps the wiping of the Data directory as mentioned
before...this is not a production system.

TIA,
Christian Herman
CJH Solutions

"Raman Iyer [MS]" <ramaniy (AT) online (DOT) microsoft.com> wrote

I checked on this issue and found that we made design changes in the June
CTP to remove the dependence on account information. As a result, the
askeymgt utility is no longer supported.

Unfortunately, in your case, you will need to re-deploy and re-process your
database after deleting the contents of your Data folder.

--
-Raman Iyer
SQL Server Data Mining
[This posting is provided "AS IS" with no warranties, and confers no
rights.]

"Christian Herman" <cjh (AT) cjhsolutions (DOT) com> wrote

Ok. Thanks.
I did just finish deleting everything from April CTP, installing June CTP
(specified correct credentials from the get-go) and all is well.

Thanks for your help.
Christian
"Raman Iyer [MS]" <ramaniy (AT) online (DOT) microsoft.com> wrote

I just downloaded the June CTP onto a new laptop running Windows XP. I am
working through the Analysis Services tutorial with the AdventureWorks
database, and everything was going well until I attempted to deploy the cube
in step 4. Deployment fails with numerous errors, starting with this one:
"The specified domain either does not exist or could not be contacted."

I wonder whether I have the wrong Server in the Deployment Properties window
for the Project Analysis Services Tutorial, but I have tried all the
variations that I can think of, since I am only running one server, which is
my local laptop. I started with what the tutorial showed, which is Server =
localhost and Database = Analysis Services Tutorial. That produced this
error, so I change Server to = ELEMENT1 (which is the name of my laptop and
the name that shows in the list of connected servers in SQL Server). That
produced the error too. Then I changed the Database to = AdventureWorks, but
that didn't work either.

Can you tell me how to get this working so that I can proceed with the
tutorial? Thank you!

--
Peter


"Raman Iyer [MS]" wrote:

Have you tried "Data Source=localhost" ?

--

-Jamie MacLennan
SQL Server Data Mining
This posting is provided "AS IS" with no warranties, and confers no rights.
"Peter" <Peter (AT) discussions (DOT) microsoft.com> wrote