Re: OLAP Linked Server Problem

Tech-Archive recommends: Fix windows errors by optimizing your registry

I know this works from the AS Operations
Guidehttp://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/anservog.mspxIf
you are still having problems then it might be a two-hop NTLM credentials
problem.Remember that with NTLM you only get one hop (from client to server)
you cannotdelegate further (i.e. to a 3rd AS server).USE master
GO
/* Additional examples are available at: */
/* http://support.microsoft.com/default.aspx?scid=kb;enus;218592 */
/* --------------------------------------------------------------*/
/* Remove any previous references to the linked server */
EXEC sp_dropserver 'LINKED_OLAP'
EXEC sp_addlinkedserver
@server='LINKED_OLAP', -- local SQL name given to the linked server
@srvproduct='', -- not used
@provider='MSOLAP.2', -- OLE DB provider
(the .2 means the SQL2K version)
@datasrc='localhost', -- analysis server name (machine name)
@catalog='Foodmart 2000' -- default catalog/database
select * from openquery
( LINKED_OLAP, 'Select {[Measures].[Unit Sales]}
on columns from [Sales] ')
select * from openquery
( LINKED_OLAP, ' with member [Measures].[Store Profit Rate]
as ''([Measures].[Store Sales]-[Measures].[Store
Cost])/[Measures].[Store Cost]'', format = ''#.00%''
select {[Measures].[Store Cost],[Measures].[Store
Sales],[Measures].[Store Profit Rate]} on columns,
Order([Product].[Product Department].members,
[Measures].[Store Profit Rate], BDESC) on rows
from Sales where ([Time].[1997]) ')
select * from sysobjects order by name

--
Dave Wickert [MSFT]
dwickert@xxxxxxxxxxxxxxxxxxxx
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.


"Kris" <Kris@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:A8987716-724A-42CF-A689-A5EE946AB22C@xxxxxxxxxxxxxxxx
> Is this really working ?
> here is the error message I am getting, I have this 'FoodMart 2000' DB
> on
> OLAP Server
> OLE DB provider 'MSOLAP' reported an error.
> [OLE/DB provider returned message: Database 'FoodMart 2000' does not
> exist.]
> OLE DB error trace [OLE/DB Provider 'MSOLAP' IDBInitialize::Initialize
> returned 0x80004005: ].
>
> EXEC sp_addlinkedserver
> @server='olap_server',
> @srvproduct='',
> @provider='MSOLAP',
> @datasrc='OLAPServer',
> @catalog='foodmart 2000'
>
> go
>
> -- MDX in OPENQUERY --
>
> SELECT * FROM OPENQUERY(olap_server,
> 'SELECT
> { Time.Year.[1997] } ON COLUMNS,
> NON EMPTY Store.MEMBERS ON ROWS
> FROM Sales
> WHERE ( Product.[Product Category].[Dairy])' )


.