Analysis Services

Question. I installed SQL Analysis services, applied the service pack 3 for analysis services, re-applied service pack 3a for SQL. I'm getting an error stating: 'Unable to connect to the registry on the server, or you are not a member of OLAP Admininstrat
ors group on this server'. I verified that the username I'm using does have permissions to the registry and is a member of the OLAP Admin Group. Help!!
Can someone please help me with this question. I have a Win 2003 server with SQL 2000 Enterprise edition. I installed analysis services, applied the sp3 for analysis services and I got the message listed below. I tried re-applying both the SQL sp3a and th
e analysis services sp3 and I still get the error. When I take the same steps on my local machine with Win xp and SQL 2000 client it works fine. What am I doing wrong?
"nupee" wrote:

> Question. I installed SQL Analysis services, applied the service pack 3 for analysis services, re-applied service pack 3a for SQL. I'm getting an error stating: 'Unable to connect to the registry on the server, or you are not a member of OLAP Admininstr
ators group on this server'. I verified that the username I'm using does have permissions to the registry and is a member of the OLAP Admin Group. Help!!
>
sql

Analysis Services

Question. I installed SQL Analysis services, applied the service pack 3 for
analysis services, re-applied service pack 3a for SQL. I'm getting an error
stating: 'Unable to connect to the registry on the server, or you are not a
member of OLAP Admininstrat
ors group on this server'. I verified that the username I'm using does have
permissions to the registry and is a member of the OLAP Admin Group. Help!!Can someone please help me with this question. I have a Win 2003 server with
SQL 2000 Enterprise edition. I installed analysis services, applied the sp3
for analysis services and I got the message listed below. I tried re-applyi
ng both the SQL sp3a and th
e analysis services sp3 and I still get the error. When I take the same step
s on my local machine with Win xp and SQL 2000 client it works fine. What am
I doing wrong'
"nupee" wrote:

> Question. I installed SQL Analysis services, applied the service pack 3 for analys
is services, re-applied service pack 3a for SQL. I'm getting an error stating: 'Unab
le to connect to the registry on the server, or you are not a member of OLAP Adminin
str
ators group on this server'. I verified that the username I'm using does have permissions to
the registry and is a member of the OLAP Admin Group. Help!!
>

Analysis Server Service Pack

How can I check to see if Service Pack 3a is loaded on my Analysis Server? I thought that the Analysis Server used the same service pack because it is all SQL Server?
Rich,
[vbcol=seagreen]
Server?
Refer the below snippet from sp3a readme.txt
(http://support.microsoft.com/support.../SP3ReadMe.asp)
<begin quote>
Analysis Services
To identify which version of Analysis Services you have installed, follow
these steps:
1.. From the Start menu, point to Program Files, point to SQL Server 2000,
point to Analysis Services, and then click Analysis Manager.
2.. In the Analysis Manager tree, right-click the Analysis Servers node,
and then click About Analysis Services.
3.. Use the following table to determine which version of Analysis
Services you have.
Analysis Services version Build Number in Help About
SQL Server 2000 Analysis Services Original Release 8.0.194
Analysis Services SP1 8.0.382
Analysis Services SP2 8.0.534
Analysis Services SP3 or SP3a 8.0.760
<end quote>
[vbcol=seagreen]
is all SQL Server?
No.You will find more info in the above url.
Dinesh
SQL Server MVP
--
SQL Server FAQ at
http://www.tkdinesh.com
"rich" <anonymous@.discussions.microsoft.com> wrote in message
news:B2D5E832-2263-42A1-A6F4-92E81284D255@.microsoft.com...
> How can I check to see if Service Pack 3a is loaded on my Analysis Server?
I thought that the Analysis Server used the same service pack because it is
all SQL Server?
|||To get the actual build number (including any hotfixes, and information on
where they came from), scroll down http://www.aspfaq.com/2160
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"rich" <anonymous@.discussions.microsoft.com> wrote in message
news:B2D5E832-2263-42A1-A6F4-92E81284D255@.microsoft.com...
> How can I check to see if Service Pack 3a is loaded on my Analysis Server?
I thought that the Analysis Server used the same service pack because it is
all SQL Server?

Analysis Server Service Pack

How can I check to see if Service Pack 3a is loaded on my Analysis Server? I thought that the Analysis Server used the same service pack because it is all SQL Server?Rich,
>> How can I check to see if Service Pack 3a is loaded on my Analysis
Server?
Refer the below snippet from sp3a readme.txt
(http://support.microsoft.com/support/servicepacks/SQL/2000/SP3ReadMe.asp)
<begin quote>
Analysis Services
To identify which version of Analysis Services you have installed, follow
these steps:
1.. From the Start menu, point to Program Files, point to SQL Server 2000,
point to Analysis Services, and then click Analysis Manager.
2.. In the Analysis Manager tree, right-click the Analysis Servers node,
and then click About Analysis Services.
3.. Use the following table to determine which version of Analysis
Services you have.
Analysis Services version Build Number in Help About
SQL Server 2000 Analysis Services Original Release 8.0.194
Analysis Services SP1 8.0.382
Analysis Services SP2 8.0.534
Analysis Services SP3 or SP3a 8.0.760
<end quote>
>>I thought that the Analysis Server used the same service pack because it
is all SQL Server?
No.You will find more info in the above url.
Dinesh
SQL Server MVP
--
--
SQL Server FAQ at
http://www.tkdinesh.com
"rich" <anonymous@.discussions.microsoft.com> wrote in message
news:B2D5E832-2263-42A1-A6F4-92E81284D255@.microsoft.com...
> How can I check to see if Service Pack 3a is loaded on my Analysis Server?
I thought that the Analysis Server used the same service pack because it is
all SQL Server?|||To get the actual build number (including any hotfixes, and information on
where they came from), scroll down http://www.aspfaq.com/2160
--
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"rich" <anonymous@.discussions.microsoft.com> wrote in message
news:B2D5E832-2263-42A1-A6F4-92E81284D255@.microsoft.com...
> How can I check to see if Service Pack 3a is loaded on my Analysis Server?
I thought that the Analysis Server used the same service pack because it is
all SQL Server?

Analysis Server Service Pack

How can I check to see if Service Pack 3a is loaded on my Analysis Server?
I thought that the Analysis Server used the same service pack because it is
all SQL Server?Rich,

Server?
Refer the below snippet from sp3a readme.txt
(http://support.microsoft.com/suppor...0/SP3ReadMe.asp)
<begin quote>
Analysis Services
To identify which version of Analysis Services you have installed, follow
these steps:
1.. From the Start menu, point to Program Files, point to SQL Server 2000,
point to Analysis Services, and then click Analysis Manager.
2.. In the Analysis Manager tree, right-click the Analysis Servers node,
and then click About Analysis Services.
3.. Use the following table to determine which version of Analysis
Services you have.
Analysis Services version Build Number in Help About
SQL Server 2000 Analysis Services Original Release 8.0.194
Analysis Services SP1 8.0.382
Analysis Services SP2 8.0.534
Analysis Services SP3 or SP3a 8.0.760
<end quote>
[vbcol=seagreen]
is all SQL Server?
No.You will find more info in the above url.
Dinesh
SQL Server MVP
--
--
SQL Server FAQ at
http://www.tkdinesh.com
"rich" <anonymous@.discussions.microsoft.com> wrote in message
news:B2D5E832-2263-42A1-A6F4-92E81284D255@.microsoft.com...[vbcol=seagreen]
> How can I check to see if Service Pack 3a is loaded on my Analysis Server?
I thought that the Analysis Server used the same service pack because it is
all SQL Server?|||To get the actual build number (including any hotfixes, and information on
where they came from), scroll down http://www.aspfaq.com/2160
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"rich" <anonymous@.discussions.microsoft.com> wrote in message
news:B2D5E832-2263-42A1-A6F4-92E81284D255@.microsoft.com...
> How can I check to see if Service Pack 3a is loaded on my Analysis Server?
I thought that the Analysis Server used the same service pack because it is
all SQL Server?sql

Analysis Manager

I have some questions please help me:

1. Well,i have tried to download sql server 2000 and analysis manager service pack 4.But i didn't success yet.I don't know the reason why.When i download,there's a mesage that the download's success but when i tried to install or update using the download file there's a message that some file corrupt.Any suggestion for this?

2. I want to create relational data mining model using DSO and VB.Automatically i use relational table. My question is should i make a cube first in analysis manager instead of using dso in vb?

Thank you so much

For question 1, I would first try to reinstall SQL 2000 and then apply the SP - let me know if that works for you.

For #2, no, there is no need to create a cube to do data mining. Most data mining questions are answered the best through a relational source.

An error occurred during the move data process: -132

Hi friend,
I'm getting the following error message when applying Service Pack 2 for Analysis Services 2000 (SQL Server):
An error occurred during the move data process: -132
Anybody can help me?
Tks,
Alex BerenguerI had the same problem. To get around it, I had to shut down nearly every service on the Win2K server (with BackOffice 2000) I was installing to. After I shut down all the services I could, the installation seemed to work correctly.

Originally posted by alexberenguer
Hi friend,

I'm getting the following error message when applying Service Pack 2 for Analysis Services 2000 (SQL Server):

An error occurred during the move data process: -132

Anybody can help me?

Tks,
Alex Berenguer