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 Server

We are running Analysis Server on Windows 2000 and it's running under local system account,but most of the time we are getting the following error 'Error = -2147221455 (80040031) Error string: Unable to connect to the registry on the server ,or you are not a member of the OLAP Administrators group on this server.'This happens when we try to refresh the cube and the only thing that makes it work again is to go to the Services under the control panel and stop and restart the OLAP services.I wonder why??By refresh, do you mean re-process the cube?

An issue with ReplicationUser

I have set-up a Replication on a SQL 2005 Cluster. I used a domain account to setup the replication. This domain account is also present in the local administrator group of both nodes of cluster. However my subscriptions fail with a message "Executed as user domain\user. A required privilege is not held by the client. The step failed." I am not sure what privilege the domain user should have.

Any tips on what kind of user account I should be using? Thanks.

This is not an issue any more.

An internal error occurred on the report server

When deploying to a local report manager i.e. http://localhost/reportserver
i get this error
An internal error occurred on the report server. See the error log for more
details. (rsInternalError) Get Online Help
Could not load type Microsoft.ReportingServices.Interfaces.IRenderStream
from assembly Microsoft.ReportingServices.Interfaces, Version=8.0.242.0,
Culture=neutral, PublicKeyToken=89845dcd8080cc91.
Anyway know a quick fix? Please put answers in lamens terms just so i
actually understand it.
cheers in advanceHello,
I am also having the same problem. Did you find out how to fix this?
Thanks
Chieko
"bobfoc" wrote:
> When deploying to a local report manager i.e. http://localhost/reportserver
> i get this error
> An internal error occurred on the report server. See the error log for more
> details. (rsInternalError) Get Online Help
> Could not load type Microsoft.ReportingServices.Interfaces.IRenderStream
> from assembly Microsoft.ReportingServices.Interfaces, Version=8.0.242.0,
> Culture=neutral, PublicKeyToken=89845dcd8080cc91.
> Anyway know a quick fix? Please put answers in lamens terms just so i
> actually understand it.
> cheers in advance

An internal consistency error occurred..

Hi all,
i have copied out the database backup from development center to my local machine,it is having approx.8GB in size and when
i m trying to restote this database backup in SQL Server 2000 it is showing me error.
An internal consistency error occurred. Contact Technical Support for assistance.
RESTORE DATABASE is terminating abnormally.
Plz. anyone can help me..

mukul:confused:Run RESTORE VERIFYONLY to ensure the backup is valid, and KBA http://support.microsoft.com/kb/268481 for further information. Try getting another set of backup to assure the source database server hardware is intact.|||Hi Satya,
i have run RESTORE VERIFYONLY command and after this is showing following msg-
Server: Msg 3242, Level 16, State 2, Line 1
The file on device 'g:\backup\projectServer\ProjectServer_db_20070709 0000.bak' is not a valid Microsoft Tape Format backup set.Server: Msg 3013, Level 16, State 1, Line 1
VERIFY DATABASE is terminating abnormally.
then what is this mean?
plz. help me out..

An error occurred while trying to access the database information. The msdb database could not b

I'am doing functionality test on DTS packages and saving my DTS packages to meta data services instead of saving them as local packages. We would like to see what information would be provided by saving them this way, but when we try to open the meta data browser (the 3rd icon under DTS) we get the following error:

An error occurred while trying to access the database information. The msdb database could not be opened.

You might want to try asking this in the DTS group: http://groups.google.com/group/microsoft.public.sqlserver.dts?lnk=srg

An error occurred during local report processing.

Occasionally when we are running reports in our web application we are
getting this error. It seems random and occurs even if a report has
just been run with the same criteria. Sometimes the error occurs a
couple of times in a row and then it will run after that fine.
An error occurred during local report processing.
An unexpected error occurred in Report Processing.
Object reference not set to an instance of an object.On Dec 6, 6:12 pm, lachlan.h...@.gmail.com wrote:
> Occasionally when we are running reports in our web application we are
> getting this error. It seems random and occurs even if a report has
> just been run with the same criteria. Sometimes the error occurs a
> couple of times in a row and then it will run after that fine.
> An error occurred during local report processing.
> An unexpected error occurred in Report Processing.
> Object reference not set to an instance of an object.
Sounds like on occasion there is an issue with the cached data for the
report. If you are caching the report data, I would suggest removing
the cache data setting. Also, you might want to delete the rdl.data
file in the interim. Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant|||On Dec 7, 12:18 pm, EMartinez <emartinez...@.gmail.com> wrote:
> On Dec 6, 6:12 pm, lachlan.h...@.gmail.com wrote:
> > Occasionally when we are running reports in our web application we are
> > getting this error. It seems random and occurs even if a report has
> > just been run with the same criteria. Sometimes the error occurs a
> > couple of times in a row and then it will run after that fine.
> > An error occurred during local report processing.
> > An unexpected error occurred in Report Processing.
> > Object reference not set to an instance of an object.
> Sounds like on occasion there is an issue with the cached data for the
> report. If you are caching the report data, I would suggest removing
> the cache data setting. Also, you might want to delete the rdl.data
> file in the interim. Hope this helps.
> Regards,
> Enrique Martinez
> Sr. Software Consultant
Thanks Enrique. I was starting to suspect it was something to do with
caching. Do you know how I can remove the cache data setting? I did a
search for rdl.data files on the server and it couldn't find any.|||I've managed to fix it by stopping stopping the W3SVC (WWW Publisher
Service) and deleting all the files in
C:/Windows/Microsoft.NET/Framework/v2.0.50527/Temporary ASP.NET Files/|||On Dec 6, 7:56 pm, lachlan.h...@.gmail.com wrote:
> On Dec 7, 12:18 pm, EMartinez <emartinez...@.gmail.com> wrote:
>
> > On Dec 6, 6:12 pm, lachlan.h...@.gmail.com wrote:
> > > Occasionally when we are running reports in our web application we are
> > > getting this error. It seems random and occurs even if a report has
> > > just been run with the same criteria. Sometimes the error occurs a
> > > couple of times in a row and then it will run after that fine.
> > > An error occurred during local report processing.
> > > An unexpected error occurred in Report Processing.
> > > Object reference not set to an instance of an object.
> > Sounds like on occasion there is an issue with the cached data for the
> > report. If you are caching the report data, I would suggest removing
> > the cache data setting. Also, you might want to delete the rdl.data
> > file in the interim. Hope this helps.
> > Regards,
> > Enrique Martinez
> > Sr. Software Consultant
> Thanks Enrique. I was starting to suspect it was something to do with
> caching. Do you know how I can remove the cache data setting? I did a
> search for rdl.data files on the server and it couldn't find any.
You're welcome. Thanks for posting your resolution; that might help
someone in the future with a similar situation.
Regards,
Enrique Martinez
Sr. Software Consultant

An error has occurred while establishing a connection to the server

Hi I have just reinstalled .Net and SqlServer2005. I am running my application from local machine and sqlserver is also install local machine. but when I run application. Get follwing Error Message

An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)

What was the application trying to do when you got this message? It may be that the connection string is not correct, it may be that the server is setup for only windows authentication.

|||

Hi

From your description, it seems that you met error when you are trying to connect to your SQLServer,right?

An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)

For this kind of issue, we should use the following steps to diagnose the problem.

First, you also should make sure that if 1433 port has been enabled on your server, which is the default port for SQLServer remote connections.

Generally, you can try the following ways to handle your problem.

1. Enable remote connections for SQL Server 2005 Express or SQL Server 2005 Developer Edition
2. Enable the SQL Server Browser service
3. Create exceptions in Windows Firewall
4. Create an exception for SQL Server 2005 in Windows Firewall
5. Create an exception for the SQL Server Browser service in Windows Firewall

More details for each step, you may see the following link:

http://support.microsoft.com/default.aspx?scid=kb;EN-US;914277

Thanks.

AMO: No mapping between account names and security IDs was done for local users

Hi,

Analysis Services 2005 and SQL Server 2005

Using AMO I'm trying to add a local user to an Analysis Services database Role that I created but I keep getting the error "No mapping between account names and security IDs was done". I can add the user to the Role with no problem using SQL Server Management studio, but if I try to add the user using AMO I get that error.

The local user that I'm trying to add belongs to both the local User and Administrator groups. I've added a logon for this local user to the corresponding SQL Server database that the Analysis Services database datasource points to, but still no luck.

Am I missing something? I've been doing this for the last three months with network users without a problem so this is completely frustrating me. Especially the fact that I can add them using the SQL Server Management Studio GUI.

Here's the basic code that I'm doing. Pretty straightforward.

private bool AddUserToAnalysisServicesRole(Role role)

{

string user = @."pdxvincentm02\testuser";

RoleMember rm = new RoleMember(user);

role.Members.Add(new RoleMember(user)); // e.g. redmond\johndoe

role.Update(); // << KABOOM!!! No mapping between ......

Help. Thanks

I have not had a chance to try this in C# yet, but I did a quick test in powershell using the following pattern and it worked.

role.Members.add("pdxvincentm02\testuser")

role.Update()

It's possible that the role.Members.Add() function has another overload that works a bit differently. But another though also occurred to me. Where is this code being executed from? Is it possibly running under an account that does not have permission to verify the account? (eg. is it running from an ASP.NET app running as local system?)

Always fails on Login

I don't get it. I'm trying to use Reporting Services to deploy my reports.
They always "forget" the datasource. I can run it on my local machine but
when I move it up to the co-lo it will work for a while and then it will just
fart.
and forget the datasource I try to set it through the admin and it dies
EVERY time.
I
BryanYou could try the following :
Go to the Report project properties by right clicking on
your Report Project in the IDE and selecting properties.
Out here set OverRideDataSource property to true. Then try
to deploy the reports.
>--Original Message--
>I don't get it. I'm trying to use Reporting Services to
deploy my reports.
>They always "forget" the datasource. I can run it on my
local machine but
>when I move it up to the co-lo it will work for a while
and then it will just
>fart.
>and forget the datasource I try to set it through the
admin and it dies
>EVERY time.
>I
>Bryan
>.
>

Alternative to Creating View with Union in two databases?

I attempted to create a view in SQL Server 2000 that Unions two
queries. The first part of the query gets data from the local server,
the second part gets info from a linked server. (The query works fine
in Query Analyzer.)

I received this error when I tried to save the query:

ODBC error: [Microsoft][ODBC SQL Server Driver] The operation could
not be performed because the OLE DB provider 'SQLOLEDB' was unable to
begin a distributed transaction.

[Microsft][ODBC SQL Server Driver][SQL Server][OLE/DB provider
returned message: New transaction cannot enlist in the specified
transaction coordinator.]

After a little reading I discovered the "Database limitation":
"A view can be created on a table only in the database the view
creator is accessing".

That's my problem... is there a simple solution or alternative to
creating a view?

Thanks,
Mattmattd@.semiconductor.com (Matt D) wrote in news:7bd0381c.0310070503.4d416d94@.posting.google.c om:

> That's my problem... is there a simple solution or alternative to
> creating a view?

A stored procedure will likely do the trick.

--
Ross Presser -- rpresser AT imtek DOT com
... seeking a new quote ...|||Matt D (mattd@.semiconductor.com) writes:
> I attempted to create a view in SQL Server 2000 that Unions two
> queries. The first part of the query gets data from the local server,
> the second part gets info from a linked server. (The query works fine
> in Query Analyzer.)
> I received this error when I tried to save the query:

I had no problems to create a view spanning two servers.

Since you talk about saving query, I get the idea that you might
be using Enterprise Manager for the task. Try running the CREATE VIEW
statement from Query Analyzer instead.

--
Erland Sommarskog, SQL Server MVP, sommar@.algonet.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp