cannot rename instance of analysis server.missing reg key

when i use the rename instance tool i get this error saying it cannot find the regestry key

hkey_local_Machine\wow6432Node\Microsoft\Microsoft Sql Server\90

When i look for this key, it doesnt exist. My installation went perfectly. what is going wrong

There are 2 versions of ASInstanceRename utility. Make sure you use one that is installed with 64bit version of Analysis Server.

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

|||but i am using the 32 bit version of sql server 2005, and its on a 32 bit pc. theres no way i can install the 64 bit version as my machine wont even run the setup file|||

You should use 64 bit version of asinstancerename utility on 64 bit machine to rename 32bit instances. It is intended to be able to handle 32bit instances.

To get 64bit version of asinstancerename, uninstall 32bit version SQL Tools from your machine and install them back using 64ibt CD.

That should get you going.

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

Cannot REinstall SQL2000 SP3 After Install MSAS

My development machine has win 2000 SP4, SQL server dev 2000 with SP3
and vs2003 etc. I installed Analysis services on my dev machine but
MSAS does not work (try to browse FoodMart2000 any cube gives error
"Unable to browse the cube 'Budget' Unspecified Error" ). Found an
article said to fix MSAS by reinstalling SQL2000 SP3. On another
machine, I re-installed Sp3 after MSAS then MSAS worked. Here is the
error from my Dev machine SP3 reinstall. I uninstalled MSAS,
reinstalled MSAS then tried SQL2000SP3 but still get the same error.
Any IDeas?
MSSQLSERVER has a newer version of Service pack installed. Setup will
now exit.
@.@.VERSION from machine that will not let me re-install SQL2000 SP3.
Microsoft SQL Server 2000 - 8.00.760 (Intel X86)
Dec 17 2002 14:22:05
Copyright (c) 1988-2003 Microsoft Corporation
Developer Edition on Windows NT 5.0 (Build 2195: Service Pack 4)
Hi,
First install SQL server without SP,
then install AS without SP,
Install SQL server SP3,
Install AS SP3
Funny, but will work
Regards,
Daniel
<abefuzzleduser2@.yahoo.com> wrote in message
news:1106922902.619763.105470@.c13g2000cwb.googlegr oups.com...
> My development machine has win 2000 SP4, SQL server dev 2000 with SP3
> and vs2003 etc. I installed Analysis services on my dev machine but
> MSAS does not work (try to browse FoodMart2000 any cube gives error
> "Unable to browse the cube 'Budget' Unspecified Error" ). Found an
> article said to fix MSAS by reinstalling SQL2000 SP3. On another
> machine, I re-installed Sp3 after MSAS then MSAS worked. Here is the
> error from my Dev machine SP3 reinstall. I uninstalled MSAS,
> reinstalled MSAS then tried SQL2000SP3 but still get the same error.
> Any IDeas?
> MSSQLSERVER has a newer version of Service pack installed. Setup will
> now exit.
> @.@.VERSION from machine that will not let me re-install SQL2000 SP3.
> Microsoft SQL Server 2000 - 8.00.760 (Intel X86)
> Dec 17 2002 14:22:05
> Copyright (c) 1988-2003 Microsoft Corporation
> Developer Edition on Windows NT 5.0 (Build 2195: Service Pack 4)
>
|||Thanks Daniel,
That is what I was afraid of, since there is no easy way to roll back
SP3.
I will work on reinstallation.
Paul
sql

Cannot REinstall SQL2000 SP3 After Install MSAS

My development machine has win 2000 SP4, SQL server dev 2000 with SP3
and vs2003 etc. I installed Analysis services on my dev machine but
MSAS does not work (try to browse FoodMart2000 any cube gives error
"Unable to browse the cube 'Budget' Unspecified Error" ). Found an
article said to fix MSAS by reinstalling SQL2000 SP3. On another
machine, I re-installed Sp3 after MSAS then MSAS worked. Here is the
error from my Dev machine SP3 reinstall. I uninstalled MSAS,
reinstalled MSAS then tried SQL2000SP3 but still get the same error.
Any IDeas?
MSSQLSERVER has a newer version of Service pack installed. Setup will
now exit.
@.@.VERSION from machine that will not let me re-install SQL2000 SP3.
Microsoft SQL Server 2000 - 8.00.760 (Intel X86)
Dec 17 2002 14:22:05
Copyright (c) 1988-2003 Microsoft Corporation
Developer Edition on Windows NT 5.0 (Build 2195: Service Pack 4)Hi,
First install SQL server without SP,
then install AS without SP,
Install SQL server SP3,
Install AS SP3
Funny, but will work
Regards,
Daniel
<abefuzzleduser2@.yahoo.com> wrote in message
news:1106922902.619763.105470@.c13g2000cwb.googlegroups.com...
> My development machine has win 2000 SP4, SQL server dev 2000 with SP3
> and vs2003 etc. I installed Analysis services on my dev machine but
> MSAS does not work (try to browse FoodMart2000 any cube gives error
> "Unable to browse the cube 'Budget' Unspecified Error" ). Found an
> article said to fix MSAS by reinstalling SQL2000 SP3. On another
> machine, I re-installed Sp3 after MSAS then MSAS worked. Here is the
> error from my Dev machine SP3 reinstall. I uninstalled MSAS,
> reinstalled MSAS then tried SQL2000SP3 but still get the same error.
> Any IDeas?
> MSSQLSERVER has a newer version of Service pack installed. Setup will
> now exit.
> @.@.VERSION from machine that will not let me re-install SQL2000 SP3.
> Microsoft SQL Server 2000 - 8.00.760 (Intel X86)
> Dec 17 2002 14:22:05
> Copyright (c) 1988-2003 Microsoft Corporation
> Developer Edition on Windows NT 5.0 (Build 2195: Service Pack 4)
>|||Thanks Daniel,
That is what I was afraid of, since there is no easy way to roll back
SP3.
I will work on reinstallation.
Paul

Cannot REinstall SQL2000 SP3 After Install MSAS

My development machine has win 2000 SP4, SQL server dev 2000 with SP3
and vs2003 etc. I installed Analysis services on my dev machine but
MSAS does not work (try to browse FoodMart2000 any cube gives error
"Unable to browse the cube 'Budget' Unspecified Error" ). Found an
article said to fix MSAS by reinstalling SQL2000 SP3. On another
machine, I re-installed Sp3 after MSAS then MSAS worked. Here is the
error from my Dev machine SP3 reinstall. I uninstalled MSAS,
reinstalled MSAS then tried SQL2000SP3 but still get the same error.
Any IDeas?
MSSQLSERVER has a newer version of Service pack installed. Setup will
now exit.
@.@.VERSION from machine that will not let me re-install SQL2000 SP3.
Microsoft SQL Server 2000 - 8.00.760 (Intel X86)
Dec 17 2002 14:22:05
Copyright (c) 1988-2003 Microsoft Corporation
Developer Edition on Windows NT 5.0 (Build 2195: Service Pack 4)Hi,
First install SQL server without SP,
then install AS without SP,
Install SQL server SP3,
Install AS SP3
Funny, but will work
Regards,
Daniel
<abefuzzleduser2@.yahoo.com> wrote in message
news:1106922902.619763.105470@.c13g2000cwb.googlegroups.com...
> My development machine has win 2000 SP4, SQL server dev 2000 with SP3
> and vs2003 etc. I installed Analysis services on my dev machine but
> MSAS does not work (try to browse FoodMart2000 any cube gives error
> "Unable to browse the cube 'Budget' Unspecified Error" ). Found an
> article said to fix MSAS by reinstalling SQL2000 SP3. On another
> machine, I re-installed Sp3 after MSAS then MSAS worked. Here is the
> error from my Dev machine SP3 reinstall. I uninstalled MSAS,
> reinstalled MSAS then tried SQL2000SP3 but still get the same error.
> Any IDeas?
> MSSQLSERVER has a newer version of Service pack installed. Setup will
> now exit.
> @.@.VERSION from machine that will not let me re-install SQL2000 SP3.
> Microsoft SQL Server 2000 - 8.00.760 (Intel X86)
> Dec 17 2002 14:22:05
> Copyright (c) 1988-2003 Microsoft Corporation
> Developer Edition on Windows NT 5.0 (Build 2195: Service Pack 4)
>|||Thanks Daniel,
That is what I was afraid of, since there is no easy way to roll back
SP3.
I will work on reinstallation.
Paul

cannot find dsn

Hello everyone,

This must be too simple to be true but im trying to set up the tutorial cube that comes with analysis manager and ive set up the cube and its dimensions but i cant progress beyond the storage design wizard as it gives me the following error when i try to process it:

[Microsoft][ODBC Driver Manager]Data source name is not found and no default driver specified

why is it that i am able to use this dsn to create the cube but not to process it or create the aggregations in the cube?
Ive set up the dsn exactly as described in the setup dsn pages (Tutorial/setup_sys_datasource.htm) and it has been working fine till this, i can even add further dimensions to the cube, just not process it, whats going on?

with much thanks, in advance, for any input

Amit

further to the above,

after going over my data source information again in analysis manager and starting up the i am now getting the following error message

error (-2147221411)Process operation faile;Time....

again im not sure whats changed or why this is different from the above or even if its closer to normal than the above but again any help will be gratefully appreciated.

Amit

|||

I sorted this by rebuilding the dsn and the cube from scratch, evidently there was something wrong somewhere along the line and it was good practice.

Amit