Re: Facing problem in accessing analysis service 2005 database from other machine

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

You need to install the 9.0 OLE DB provider on the client machine. It can be
downloaded and installed from here:

http://www.microsoft.com/downloads/details.aspx?FamilyID=d09c1d60-a13c-4479-9b91-9e8b9d835cdc&DisplayLang=en

"Feature Pack for Microsoft SQL Server 2005 - November 2005"

Microsoft SQL Server 2005 Analysis Services 9.0 OLE DB Provider

Thanks,
Akshai

--
--
This posting is provided "AS IS" with no warranties, and confers no rights
Please do not send email directly to this alias. This alias is for newsgroup
purposes only.

"RICKY" <vinayusa@xxxxxxxxx> wrote in message
news:1140213565.329896.148000@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Dear All,

I am using sqlserver analysis services 2005. I have installed this on
my local machine with window authentication.
I have create some cubes in analysis services 2005 on my local machine

When I try to connect to cube through excel from my local machine, it
give me 2 options
1. Microsoft OLE DB provider for olap services 8.0
2. Microsoft OLE DB provider for Analysis services 9.0

If I used 2 option i am able to access the cube
when i used 1st option, it gives me the follwoing error:
"Unable to open the connection . cannot connect to the server
'wit-ws2', the server is either not started or too busy"

When I try to connect to cube through excel from any other machine
it give me 1 option
Microsoft OLE DB provider for olap services 8.0

I am getting the follwoing error:
"Unable to open the connection . cannot connect to the server
'wit-ws2', the server is either not started or too busy".
I think i am doing some silly mistake.

Please help in that

Thanks
Vinay



.

Relevant Pages

  • adsi linked servers
    ... I'm following the directions for the OLE DB Directory ... I add the linked server with this TSQL ... from OLE DB provider 'ADSDSOObject'". ... If I execute an openquery command from query analyzer I ...
    (microsoft.public.sqlserver.security)
  • Re: non-sa users get access denied in OLE DB query
    ... Ad hoc access to OLE DB provider 'IBMDADB2' has been denied. ... access this provider through a linked server. ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ...
    (microsoft.public.sqlserver.security)
  • Re: miising oracle odbc data provider
    ... available 64bit Microsoft OLE DB Provider. ... this provider will be available to a Service Pack 3 to its Windows ... Windows Server 2008. ...
    (microsoft.public.sqlserver.odbc)
  • Using old Excel Pivot against new version of OLAP.
    ... We have been using Excel to read PivotTable Services 8.0 is the OLE DB ... Now we upgradet to SQL Server 2005 and SQL ... Server 2005 Analysis Services. ... installed the Analysis Services 9.0 OLE DB Provider but get some ...
    (microsoft.public.sqlserver.olap)
  • Re: error 80004005 Database provincia does not exist.
    ... came with the Service Pack that you currently have on your AS server. ... This file contains the latest OLEDB provider for Analysis Services. ... When i try to establish the connection with Database FoodMart 2000 I ...
    (microsoft.public.sqlserver.olap)