analysis services 2000 error "cannot access registry on server(servername) or you are not a

I recently had to reinstall AS2000. Since then , if i dont run the service under the local account i get a "could not access registry on (localserver) or analysis you are not part of Olap administrators group on this server" error.

I am in the sql server admins group, and the olap admins group, as is the service account I want to run AS2000 under. I have granted admin access explicitly to the Hikey_local_machine\ software\microsoft\olap server registry entries, to the service account and my account.

I have installed AS2000 SP3a and rebooted the machine. I am still stuck with the error. When i check the "actual permissions" of my account, and the service account to run the AS service under, they have full admin permission to the machine.

If i run it under "local System Account" it works, but i need to run it under the service account.

All google tells me is to install sp 3a, which i have done twice, to no avail.

Has anyone solved this bug, or do they know the reason for it?

Hello! If you have AS2000 on a separate server and the administration console on another workstation you can check that they have the same service pack installed.

I also know, from experience, that this problem problem can appear if the pasword for the service account have extended its time limit.

Any firewalls between workstations and the server?

HTH

Thomas Ivarsson

|||hi. thanks for replying. Im working exclusively off the server, not connecting from another pc. no firewalls in use in the domain either.

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 service: pb when archiving/restoring from 1 machine to another

I have to install cubes on another machine (not on the same site/NT domain).
I have archived the OLAP db and generated a .cab file.

I have retored on the destination server.
It works fine in Analysis Manager console (I can process and lokk at the data).
But when I want to access the cube from Excel using OLAP cube, I have an error msg.

Is there something I need to do on the distination server ?
Langage, SP, role, version of SQLServer/Analysis services ...

ThanksWhat is the error message that you get?|||In Excel: (translated from French)
"OLAP cube not found
OLAP database ha been modified or you do not have necessary authorisation to connect to the cube
Contact your database admin"

It has something to do wuth SSPI authentication ?|||It could have something to do with the access rights...
I once saw something similar to this, and then the problem was solved by adding the user account to the OLAP admin group.

Analysis Service: how can I process cubes?

how can I process and update cubes automaticly every night ?
ThanksThere is a task in DTS for processign cubes and other Analysis Services tasks. Create a package and just schedule it

Analysis service: how can I change the name of the data source ?

I want the change the name of the Data source (see attached gif picture)
ThanksThis is from Step By Step: Microsoft SQL Server 2000 Analysis Services.

When you copy an object - such as a data source, a database, a cube, or a dimension - and attempt to paste the object back into the same container, Analysis Manager prompts for a new name. This is the only way to "rename" an object. Once you've copied and pasted the object, you can delete the original. If you want to "rename" a data source, you must do so before using it as the source for a cube or dimension.sql

Analysis Service: filter fact table ?

I have a big table with several types of transsactions: PO (Puchase Orders, SO,( Sales orders), INV (Invoices) ...
I want to create cubes with only one type of transactions (1 cube for PO,...)
Where and how can I filter the rows I want to use in my cube ?
Thankscreate view, and for fact table in AS point at the view.|||create view, and for fact table in AS point at the view.

Analysis Service stops soon after starting

Hi all,

I'm quite new to MS SQL server. I downloaded the Evaluation version of 2005 recently. I tried installing it. Partially I succed. I'm able to get all other services running but for the "Analysis service" when I try to start it from control pannel, It starts and stops immedieatly with a message "It started and stopped immedieatly.....". I'm not able to figure it out why.

I've Vista Business edition and I've installed the SP2 for the SQL 2005 as well. Any directions would be helpful

Best regards,

Markish

Hello. When you start Management Studio or BI_Dev Studio you can right click on them and choose "Run as administrator", provided that you are an administrator on you machine.

Vista also requires SP1 for Visual Studio and an additional update. From my memory I also think that you will need SQL Server SP2. Have you installed these updates?

HTH

Thomas Ivarsson

|||

Hi,

Thanks for the reply. I've installed SQL SP2. I doubt If I have the SP1 for the Visual Studio. (I'll install it today anyhow...) I'm running as an administrator only. I'll update you on the status.

Best regards,

Markish

|||

Hi Markish, Were you able to solve this problem? If so, pls let know how it happenned. I face the same issue, posted here:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=2113409&SiteID=1

regards

Analysis Service stops soon after starting

Hi all,

I'm quite new to MS SQL server. I downloaded the Evaluation version of 2005 recently. I tried installing it. Partially I succed. I'm able to get all other services running but for the "Analysis service" when I try to start it from control pannel, It starts and stops immedieatly with a message "It started and stopped immedieatly.....". I'm not able to figure it out why.

I've Vista Business edition and I've installed the SP2 for the SQL 2005 as well. Any directions would be helpful

Best regards,

Markish

Hello. When you start Management Studio or BI_Dev Studio you can right click on them and choose "Run as administrator", provided that you are an administrator on you machine.

Vista also requires SP1 for Visual Studio and an additional update. From my memory I also think that you will need SQL Server SP2. Have you installed these updates?

HTH

Thomas Ivarsson

|||

Hi,

Thanks for the reply. I've installed SQL SP2. I doubt If I have the SP1 for the Visual Studio. (I'll install it today anyhow...) I'm running as an administrator only. I'll update you on the status.

Best regards,

Markish

|||

Hi Markish, Were you able to solve this problem? If so, pls let know how it happenned. I face the same issue, posted here:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=2113409&SiteID=1

regards

Analysis Service SP3

Where to download SQL Server 2000 Analysis Service SP3?
Does it include inside SQL Server 2000 SP3?
Thanks.
-Where to download SQL Server 2000 Analysis Service SP3?
http://www.microsoft.com/sql/downloads/2000/sp3.asp
-Does it include inside SQL Server 2000 SP3?
No you have to install it seperately. Sql2kasp3.exe only contains analysis
issues.
a.. Sql2ksp3.exe. Updates for database components.
a.. Sql2kasp3.exe. Updates for Analysis Services components.
a.. Sql2kdesksp3.exe. Updates for Microsoft SQL Server 2000 Desktop Engine
(MSDE 2000).
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
"Joe" <Joe@.discussions.microsoft.com> schrieb im Newsbeitrag
news:49C8FD2F-CBC4-48B6-BDC2-F2BC9C49071D@.microsoft.com...
> Where to download SQL Server 2000 Analysis Service SP3?
> Does it include inside SQL Server 2000 SP3?
> Thanks.

Analysis Service SP3

Where to download SQL Server 2000 Analysis Service SP3?
Does it include inside SQL Server 2000 SP3?
Thanks.-Where to download SQL Server 2000 Analysis Service SP3?
http://www.microsoft.com/sql/downloads/2000/sp3.asp
-Does it include inside SQL Server 2000 SP3?
No you have to install it seperately. Sql2kasp3.exe only contains analysis
issues.
a.. Sql2ksp3.exe. Updates for database components.
a.. Sql2kasp3.exe. Updates for Analysis Services components.
a.. Sql2kdesksp3.exe. Updates for Microsoft SQL Server 2000 Desktop Engine
(MSDE 2000).
HTH, Jens Suessmeyer.
--
http://www.sqlserver2005.de
--
"Joe" <Joe@.discussions.microsoft.com> schrieb im Newsbeitrag
news:49C8FD2F-CBC4-48B6-BDC2-F2BC9C49071D@.microsoft.com...
> Where to download SQL Server 2000 Analysis Service SP3?
> Does it include inside SQL Server 2000 SP3?
> Thanks.sql

Analysis Service SP3

Where to download SQL Server 2000 Analysis Service SP3?
Does it include inside SQL Server 2000 SP3?
Thanks.-Where to download SQL Server 2000 Analysis Service SP3?
http://www.microsoft.com/sql/downloads/2000/sp3.asp
-Does it include inside SQL Server 2000 SP3?
No you have to install it seperately. Sql2kasp3.exe only contains analysis
issues.
a.. Sql2ksp3.exe. Updates for database components.
a.. Sql2kasp3.exe. Updates for Analysis Services components.
a.. Sql2kdesksp3.exe. Updates for Microsoft SQL Server 2000 Desktop Engine
(MSDE 2000).
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
--
"Joe" <Joe@.discussions.microsoft.com> schrieb im Newsbeitrag
news:49C8FD2F-CBC4-48B6-BDC2-F2BC9C49071D@.microsoft.com...
> Where to download SQL Server 2000 Analysis Service SP3?
> Does it include inside SQL Server 2000 SP3?
> Thanks.

Analysis Service Ports

SQL 2005 AS installed on a Cluster.
We are using a named instance and only one currently exists. MS White paper
reads: The default instance listens on port 2383, while named instances are
dynamically allocated. This behavior can be changed by explicitly assigning a
port to either the default or named instance of SSAS. If the value for Port
is 0, the default behavior described above is achieved. Otherwise, the value
is treated as an absolute (static) port number to use for the specified
instance.
I have modifed the Server PORT property, on the named instance (a default
instance does not exist) to listen on port 2382 and have added a rule to our
firewall to allow this traffic. However, AS continues to listen on port 2383.
Does anyone have any experience on this and how to change it.
Is there a range of ports I can tell our network team to open?
I am not sure on SQL 2005 but in SQL 2000 you need to start the service
again to take the effect of new port numbers...
Zaki.
"FredG" <FredG@.discussions.microsoft.com> wrote in message
news:6A9E45E1-E591-4086-B8A3-A5A1556BFFDC@.microsoft.com...
> SQL 2005 AS installed on a Cluster.
> We are using a named instance and only one currently exists. MS White
paper
> reads: The default instance listens on port 2383, while named instances
are
> dynamically allocated. This behavior can be changed by explicitly
assigning a
> port to either the default or named instance of SSAS. If the value for
Port
> is 0, the default behavior described above is achieved. Otherwise, the
value
> is treated as an absolute (static) port number to use for the specified
> instance.
> I have modifed the Server PORT property, on the named instance (a default
> instance does not exist) to listen on port 2382 and have added a rule to
our
> firewall to allow this traffic. However, AS continues to listen on port
2383.
> Does anyone have any experience on this and how to change it.
> Is there a range of ports I can tell our network team to open?
|||I have restarted the service multiple times and it continues to listen on
this port.
"Zakiuddin Mohammed" wrote:

> I am not sure on SQL 2005 but in SQL 2000 you need to start the service
> again to take the effect of new port numbers...
> Zaki.
> "FredG" <FredG@.discussions.microsoft.com> wrote in message
> news:6A9E45E1-E591-4086-B8A3-A5A1556BFFDC@.microsoft.com...
> paper
> are
> assigning a
> Port
> value
> our
> 2383.
>
>

analysis service package question

I'm working on a new analysis package using VS 2005, I am able to create the package and cube, etc, but when I go to the Calculation tab for the cube I'm getting the following error message "Unexpected Error occurred: 'Error in application' "

now I uninstalled and reinstalled VS .NET 05 twice, and even uninstalled and reinstalled SQL Server on my box and I'm still getting the error message.

What is causing this error and how can I fix it?

Have you got Office 2007 installed? See:

http://geekswithblogs.net/darrengosbell/archive/2006/11/17/97367.aspx

HTH,

Chris

|||No i don't, I have office 03 installed|||

Hmm, possibly something else has caused the same problem. I'd still go through the steps described to see if it stops the error if I were you...

Chris

|||

I'm getting ready to go through them now actually.

I'll post how it turns out.

Analysis Service on 2005

I'm trying to create a Cube on analysis services, but do not see any
realtions in the diagram between my selected tables. The tables use indexes
rather than primary keys. Do you have any suggestions about how I can specify
the relations from Analysis Services.
Thanksdo you talk about the DSV (data source view) schema?
the system can detect relationships based on column names, you have an
option which allow you to change the way visual studio will detect the
relationship between the tables.
but this works BEFORE you add tables in the DSV
after this you have to manually create the links in the DSV. (its a simple
drag&drop)
"dbach" <dbach@.discussions.microsoft.com> wrote in message
news:E0F20189-17FC-443D-8348-2CC63172F0FD@.microsoft.com...
> I'm trying to create a Cube on analysis services, but do not see any
> realtions in the diagram between my selected tables. The tables use
> indexes
> rather than primary keys. Do you have any suggestions about how I can
> specify
> the relations from Analysis Services.
> Thanks

Analysis Service Manager

I give up, how do you start the Analysis Manager? SSAS is installed and running, but I just can't seem to find the button/shortcut/whatever to start the manager.

If you are using SSAS 2005, you should use SQL Server Management Studio and connect to Analysis Services to view server objects

For development, you will have to use BIDS (BI development studio - Visual studio 2005)

|||Thanks, but how do I get to a 2K database?|||If u r using AS 2000, then I guess it would be better to use Analysis Manager. It should be under Programs ==> Microsoft SQL Server.|||I have to support both 2000 (legacy) and 2005 AS. However, I can't have both Services installed at the same time, which is why I'm trying to use SSAS 2005.|||

You can have both services installed at the same time.

You have to install AS2k as the default (unnamed instance) as it does not support named instances.

You then install AS2k5 as a named instance, on my machine I have it setup as localhost\SQL05. But you still need both sets of admin tools Analysis Manager for AS2k and Management Studio and BI Dev Studio for AS2k5. You cannot administer both versions from a single tool.

sql

Analysis Service is slowing down the server

Hi,

I am facing the following problem on SQL2K.

When I start the service the server slows down and users start complaining that generation of reports based on system (i.e. databases) that are hosted on the same server have REALLY slowed down... and thus I have to stop the service...

Can some please guide me regarding how to solve this problem and how I can be able to use the Analysis service.

Many thanks in advance for you kind help.Howdy

It would make sense to :

(1) Ensure the tables Analysis Services are querying have good indexes on them - use profiler & Index Tuner wizrd to check

(2) RUn the queries after hours to reduce competion on resources

(3) Check perfmon and see if the box is under powered for what you are trying to do

(4) Maybe find another server and copy the database to it & run analysis services on that - that way no-one will ever complain and it may be quicker for oyu.

Cheers,

SG.

Analysis Service in cluster

Hi
I have 2-node active/active cluster. I have installed 2 SQL instances (one
per node).
Now I want to install Analysis service in cluster for datawarehouse . I have
some questions regarding this.
1. Should I have seperate cluster group to be created for this? if so, how
many disk drives would be required for that group (recommendations).
2. Should I give different instance name for analysis serviceor I can be
same instance name as SQL instance.
Thanks and Regards,
Vijay
Vijay
1. Create a separate cluster groups and add Disk to it ... I would start
with one disk or more depending on how you have laid out the DW
2. For the instance - I would recommend a different name
Thanks
"Vijay" <Vijay@.discussions.microsoft.com> wrote in message
news:16D83565-9F15-4A5D-A745-B2C47EE0BF5F@.microsoft.com...
> Hi
> I have 2-node active/active cluster. I have installed 2 SQL instances (one
> per node).
> Now I want to install Analysis service in cluster for datawarehouse . I
> have
> some questions regarding this.
> 1. Should I have seperate cluster group to be created for this? if so,
> how
> many disk drives would be required for that group (recommendations).
> 2. Should I give different instance name for analysis serviceor I can be
> same instance name as SQL instance.
> Thanks and Regards,
> Vijay
>
|||Thanks for your help
"Seme Rollansa" wrote:

> Vijay
> 1. Create a separate cluster groups and add Disk to it ... I would start
> with one disk or more depending on how you have laid out the DW
> 2. For the instance - I would recommend a different name
> Thanks
>
> "Vijay" <Vijay@.discussions.microsoft.com> wrote in message
> news:16D83565-9F15-4A5D-A745-B2C47EE0BF5F@.microsoft.com...
>
>

analysis service DTS keeps failing . ERRORSOURCE = DSO

i have an analysis services dts job on an old sql server 2000 box. i have never used analysis services before, and am a bit stuck. the job used to run and succeed all the time, but now it fails most of the time. this is the error that goes with the failure. someone suggested that its because more than 1 cube processing jobs were running at the same time, but i dont know how i would sort that out as they have to be run at the times they are scheduled for.

ERROR:

Executed as user: REDMOND\osqlli01. ...
tart: DTSStep_DTSExecuteSQLTask_4
DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_4
DTSRun OnStart: DTSStep_DTSDynamicPropertiesTask_1
DTSRun OnFinish: DTSStep_DTSDynamicPropertiesTask_1
DTSRun OnStart: DTSStep_DTSOlapProcess.Task_1
DTSRun OnError: DTSStep_DTSOlapProcess.Task_1, Error = -2146828197 (800A005B)
Error string: Object variable or With block variable not set
Error source: DSO Help file:
Help context: 1000091
Error Detail Records: Error: 0 (0);
Provider Error: 0 (0)
Error string: Object variable or With block variable not set
Error source: DSO Help file:
Help context: 1000091
DTSRun OnFinish: DTSStep_DTSOlapProcess.Task_1
DTSRun OnStart: DTSStep_DTSExecuteSQLTask_10
DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_10
DTSRun OnStart: DTSStep_DTSExecuteSQLTask_7
DTSRun OnError: DTSStep_DTSExecuteSQLTask_7, Error = -2147220421 (8004043B... Process Exit Code 2. The step failed.

Maybe you have to turn on the 'execute on main thread' option !
You can find it on the workflow properties in your DTS-Package !

|||i just checked. it is set to run on the main process. that box is checked.|||

Winston,

Were you able to find a solution or the cause to this problem? This error has started to occur when I try to process a cube on Analysis Services 2000.

Thanks,

Jake

|||

In the past, I got the same kind of error !

My error occured because my 'Navision-odbc-driver' did NOT support multithreading ! In other words, executing tasks simultaneously caused my error !

To solve that error: On every workflow, I turned on the 'execute on main thread' option !

Kind regards,

Geert G.

analysis service DTS keeps failing . ERRORSOURCE = DSO

i have an analysis services dts job on an old sql server 2000 box. i have never used analysis services before, and am a bit stuck. the job used to run and succeed all the time, but now it fails most of the time. this is the error that goes with the failure. someone suggested that its because more than 1 cube processing jobs were running at the same time, but i dont know how i would sort that out as they have to be run at the times they are scheduled for.

ERROR:

Executed as user: REDMOND\osqlli01. ...
tart: DTSStep_DTSExecuteSQLTask_4
DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_4
DTSRun OnStart: DTSStep_DTSDynamicPropertiesTask_1
DTSRun OnFinish: DTSStep_DTSDynamicPropertiesTask_1
DTSRun OnStart: DTSStep_DTSOlapProcess.Task_1
DTSRun OnError: DTSStep_DTSOlapProcess.Task_1, Error = -2146828197 (800A005B)
Error string: Object variable or With block variable not set
Error source: DSO Help file:
Help context: 1000091
Error Detail Records: Error: 0 (0);
Provider Error: 0 (0)
Error string: Object variable or With block variable not set
Error source: DSO Help file:
Help context: 1000091
DTSRun OnFinish: DTSStep_DTSOlapProcess.Task_1
DTSRun OnStart: DTSStep_DTSExecuteSQLTask_10
DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_10
DTSRun OnStart: DTSStep_DTSExecuteSQLTask_7
DTSRun OnError: DTSStep_DTSExecuteSQLTask_7, Error = -2147220421 (8004043B... Process Exit Code 2. The step failed.

Maybe you have to turn on the 'execute on main thread' option !
You can find it on the workflow properties in your DTS-Package !

|||i just checked. it is set to run on the main process. that box is checked.|||

Winston,

Were you able to find a solution or the cause to this problem? This error has started to occur when I try to process a cube on Analysis Services 2000.

Thanks,

Jake

|||

In the past, I got the same kind of error !

My error occured because my 'Navision-odbc-driver' did NOT support multithreading ! In other words, executing tasks simultaneously caused my error !

To solve that error: On every workflow, I turned on the 'execute on main thread' option !

Kind regards,

Geert G.