I actually gave up the excel solution.

I switched to .csv and altering the package a bit made it work immediately. 🙂

I gave up finding a solution for the excel.

Unfortunately, that's not the case. My server is 32bit and the 64bit Runtime value is already set to false.

Any other solutions?

I am running on Windows 2003 R2 Standard (x86) and SQL Server 2005 SP2 (9.00.4053)

Hello Rick,

I finally found out what was wrong. There was a deleted user as a member in the Role. After removing him the solution was deployed successfully!

regards,

Theo

It is a virtual machine so I can just snapshot it (I have done this already).

I thought of doing this as well. In fact I did it yesterday but it...

it's the only one..

Thanks for the reply Rick!

Well I tried with my AD username (which by the way was created later than the Cube) and it failed in the rebeuild process reporting:

Error1Access to...

My system is a Windows 2008 x64 SP2 Standard and the SQL Server is 2008 SP1 x64.

Well here is my problem.

A consultant built up a Cube for my company some...

Did it work after all?

I face a similar problem!

Any updates?

For your information, in case anybody is interested, here is the solution:

http://erikasblog.datainspirations.com/?p=26

The actual problem is that any domain user that is assigned to the local administrators (either directly or via a group) can not be granted the Connect to database engine...

Well, I ended up removing the sysadmin role and dyning the permission to connect to database engine for BUILTIN\Administrators group (since the login is not possible to be disabled). But...

Well what does it make this safer than just removing all the roles?

What if I need to create this account in the future? It is a system account and I...

I tried it but it does report the error message that I mentioned:

Msg 15151, Level 16, State 1, Line 1

Cannot alter the login 'BUILTIN\Administrators', because it does not exist or...