OLAP Connectivity

Hello all,

We have Analysis Services 2000 with an OLAP cube. The cube has a role allowing access to all Windows domain users. From my development workstation we can connect to the cube, using Excel or a HTML page with the Office Web component, logged on as any user. However, from any other computer in the domain, and logged on with the same users, we cannot create a connection; the OLAP server is not visible!

The client computers are all the same: Windows 2000 Pro and the users all belong to the domain.

Why can we not connect? Has anybody ever experienced this sort of problem? We need to solve this by Monday, our deadline to show our OLAP application to the users. I would really appreciate somebody's help.

Thanks in advance,

Jerome Smith

Have all other workstations pivot table services installed, that is the local client that SSAS 2000 requires? It muste be the same version(service pack) as the server.

It is not sufficient with Excel installed on each client, you also need pivot table services.

You can download this add in for Excel: http://www.microsoft.com/downloads/details.aspx?FamilyId=DAE82128-9F21-475D-88A4-4B6E6C069FF0&displaylang=en

HTH

Thomas Ivarsson

|||

Hello Thomas,

I thought that PTS was included in Office. At least that's what the manual for the MS-2074 course says, and I have always been able to connect to Analysis Servers from Excel and FrontPage, and in different companies.

The download you referred me to is actually not PTS but the Excel Add-In for Analysis Services, which affords enhanced functionality but does not solve the problem.

What I really need to do is connect to the OLAP cube from a HTML page with the OLAP web component, included in Office and also in FrontPage.

Thank you for your time.

Regards,

Jerome Smith

|||

Like I have told you earlier, PTS is not installed by default. Install it on the machines that do not work and see if this helps.

The download of the Excel add in will include PTS.

If you are trying to do a http-connection then it is a different story. Office web components are ActiveX and do not use http by default.

Regards

Thomas Ivarsson

|||

OK Thomas,

I'll try this.

Thanks,

Jerome

|||

Good luck. If this is not the problem return with more information and we can continue with other causes.

Regards

Thomas Ivarsson

|||

Hi Thomas,

Well, actually I managed to deploy the application on almost all client PCs WITHOUT installing PTS. Just as I thought, PTS comes included with Office, so it is almost never necessary to install PTS.

The problem was never solved on some developer's notebooks in the IT department; we couldn't connect to the AS Server, no matter what we did (including installing the Add-In from the link you gave me).

It beats me why. I wish I knew. Any ideas?

Jerome

sql

OLAP Administrators issue

Hi,

I moved my AS 2000 olap database to new hardware also new OS WS 2003 32 bit to 64 bit.

I added domain/loging ID of sql server/job server to "OLAP Administrators" user group

which runs the DTS package to process cubes. This was fine in my old server OS WS 2003 32 bit.

But in new server WS 2003 64 bit cube process failed because job server was not able to connect to AS server.

I had to add job server's domain\login ID to "Administrators" user group in new server and then I was able to process the cube.

I don't want to give administrator access to job server to my olap server is this some thing I can do or missing?

Thank you - Ashok

Here is some information for you from http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/anservog.mspx

Take a look at the Administrator Security section there.

In general, DSO that client application like Analysis Manager, or DTS task based upon tries couple of things.

One, it remotely accesses registry on server machine and reads RemoteRepositoryConnectionString http://support.microsoft.com/kb/330244

Then it uses it to open AS2000 repository.

Try and see at what point DSO running under user account with fewer privileges fails to acces information it needs.

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

of any concern??

This is a reoccurring error in one of our Domain Controllers event logs…

Event Type: Error
Event Source: KDC
Event Category: None
Event ID: 11
Date: 7/24/2007
Time: 6:23:05 AM
User: N/A
Computer: DC2
Description:
There are multiple accounts with name MSSQLSvc/dbsrvr-02.olntv.local:1433 of type DS_SERVICE_PRINCIPAL_NAME.

the Server dbsrvr-02 (sql server 2000 standard edition sp3a) has a default instance and it looksl ike 2 named instances installed that we are not using. Ive searched this error and cannot find a thing.. should this concern me? anyone ?Fyi http://www.eventid.net/display.asp?eventid=11&eventno=569&source=KDC&phase=1 and also if you areusing active directory, i t means there are duplicate entries in Active Directory for this service principal name. A directory administrator can use ldp.exe to search for the duplicates and either ldp.exe again or adsiedit.msc to delete the duplicates.