Showing posts with label sql2000. Show all posts
Showing posts with label sql2000. Show all posts

Monday, February 13, 2012

Analysis Services on SQL2000 SP4

"unable to browse the dimension [dimension name].

Provider cannot be found. or Unknown Error.

Everything else looks good, like processsing, looking at the tables,fields, datasource is connected.


Dear,

Did u used a shared dimension in the cube.

from

sufian

|||

I tried both, shared and not shared. Input is from Access db. It fails already in the Create Dimension Wizard screen. Data should be populated on the screen

|||

Can you please describe your situation in bit more details.

What version of Analysis Services you are using?
What relational database are you using?
What OLEDB provider ?
What is the exact error message you are getting and at what stage?

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

|||

Analysis Services Version 8.0.194

Input Database MS Access2000

Provider = MS Jet 4.0 OLE DB Provider

OS = Windows 2000 Professional with SP4

Error appears already on the Finish the Dimension Wizard Screen

"Unable to browse the dimension [dimension name]. Unspecified Error.

I have processed the cube and the dimension. I get the count on all records processed.

Also if I try to browse data on individual dimension(s)I get ;

"Unable to browse the dimension [dimension name]. Provider not found or not properly installed" however testing the database connection works fine.

|||

What happens if you try to browse your cube after your processed it? Do you see dimensions and measures?

I suspect you just having problem browsing dimension. Is that so?

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

|||

FYI - I am using Professional SQL Server 2000 Programming by Robert Vieira (WROX) See page 920 top(data is already displayable for the Customer Dimension at creation time. I fail right there.

To answer your questions: I cannot browse the cube after processing - Same error "Unable to browse the cube - unspecified error".

Same applies to the dimensions.

Validate dimension, Count Dimension members and metadata all check out. Processing is going to normal end for both cube and individual dimensions and I get the correct number of members that I am supposed to get with no errors in processing.

|||

It is possible that you got some client components installation corrupted.

Try installing "Microsoft SQL Server 2000 PivotTable Services " from http://www.microsoft.com/downloads/details.aspx?familyid=d09c1d60-a13c-4479-9b91-9e8b9d835cdc&displaylang=en

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

|||

Thanks again, but no cigar. To install pivot tables I had to de-install Analysis Services, Install the pivot tables and re-install the Analysis. However I can't browse the results and/or the cube.

I went a step further installing SQL Server 2000 and Analysis Services on a different PC, using Windows XP with the same negative results.

Unable to browse the Cube [cube name] or

Unable to browse the dimension [dimension name]

Unspecified error. It will help how to find and read the OLAP server error logs or dump for a better understanding of what is wrong.

Since I am using the same version of the SQL Server (developer edition 8.00.760(SP3) from Microosoft) on both PC's I tend to believe there is a limitation on it. I have no other logical explanation.

|||

Are you talking about SP3 or SP4? The title suggests you'd like to install SP4.

Is that so?

Please make sure your run the same service pack version of the server and client.

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

|||

Veo,

Is the Access database stored on a network drive? The Analysis Services service would normally be installed to run as a system account which would not have access to network resources.

|||

I am the administrator of my PC. Acces is installed on the same PC with the SQL Server.

Operating system Windows2000 has SP4 applied and SQL Server has SP3 applied.

My next step will be to import Access data base into SQL 2000 to see if that makes a difference

|||

I think you should be better off with keeping your database in SQL Server.

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

Sunday, February 12, 2012

Analysis Services Deployment Security Issue

We have been working on moving our database from SQL2000 to 2003 the last couple of months. We are now working on our cube migration and have attempted a few deployments. The problem is, every time we try to process the deployed cube it gives us the following error:

The following system error occurred: Logon failure: unknown user name or bad password.

We only have one connection in this deployment and have tried with various cubes all the way down to one dimension.

Our connection always tests successfully on the dialog box itself, we have attempted both, windows and SQL authentication, and both always yield the same error.

Up to this point we have not able to process any cube we have attempted.

As far as I can tell our SQL and Analysis services both are set to the same instance name, but I’m thinking this may be a configuration issue, since it seems that internally Analysis services just cant contact SQL services.

Anyone has an idea of what may be wrong with the configuration?

Have you tried setting the Impersonation Information to Default, and including the user name and password in the connect string?|||Hmm, I had not tried that. Attempted it now and it worked.

This solves my problem but now I question why would the other settings not work?

Analysis Services Cube using SQL2000 database

Hi All
I'm trying to build my first Analysis Services (2005) cube based on fact and
dimension tables on a SQL200 database on a different server.
I'm having problems setting up the data sources - I'm assuming I need two:
one for the source SQL2000 tables and one for the target SQL2005 cube. I've
done this but when it comes to deploying the cube it looks like it's
expecting the source tables on my SQL2005 data source
I think I'm missing something fundamental. Any help or suggestions most
welcome.
Thanks
PeterHello Peter,
If I understand you correctly, you have two data sources in the data
source folder in your Analysis Services project. Can you confirm that
the data for your cube is only based on the SQL2000 data source?
If this is the case, then you should delete SQL2005 data source, as you
do not need a connection to your SQL server 2005. Make sure the data
source view is only base on the SQL2000 connection.
To deploy your cube to Analysis services you only need to set up the
deployment location in the project. This most like will be already
setup for you if you are working with everything on one PC.
Hope this helps,
Myles Matheson
Data Warehouse Architect
http://bi-on-sql-server.blogspot.com/