gary_jos... (AT) hotmail (DOT) com Apr 7, 8:51 am show options

Newsgroups: microsoft.public.sqlserver.connect
From: gary_jos... (AT) hotmail (DOT) com - Find messages by this author
Date: 7 Apr 2005 08:51:02 -0700
Local: Thurs, Apr 7 2005 8:51 am
Subject: OpenRowSet Connect to OLAP Problems
Reply | Reply to Author | Forward | Print | Individual Message | Show
original | Remove | Report Abuse

I am having trouble connecting to an OLAP server from MS Query
Analyzer. I can connect from my laptop (nbjgary02) and it works fine.
If I open another window that connects to any other server and run the
same query, the result is the following error:


Server: Msg 7399, Level 16, State 1, Line 1
OLE DB provider 'MSOLAP' reported an error.
[OLE/DB provider returned message: Database 'TxnDetail' does not
exist.]
OLE DB error trace [OLE/DB Provider 'MSOLAP' IDBInitialize::Initialize
returned 0x80004005: ].


How can the TxnDetail database not exist if my laptop was able to
successfully connect to it?


Here's the query I'm running.


SELECT a.* FROM OpenRowset('MSOLAP','DATASOURC*E=dlrymagnetsqlp1; USER

ID=*; PASSWORD=*;Initial Catalog=TxnDetail;',
'SELECT Measures.members ON ROWS,
[IssueYear].members ON COLUMNS
FROM [wholesaler_diff]') as a


Any ideas are greatly appreciated.

don't know if this will help you or not, but i was having same error. I
resolved this by creating the linked olap server by using the
sp_addlinkedserver stored procedure and NOT creating it using Enterprise
Manager. See BOL for an example of creating the linked server using the sp.
I was able to successfully query the cube using query analyzer.

"gary_joshua (AT) hotmail (DOT) com" wrote:

Yup. See Appendix F in the AS Operations Guide:
http://www.microsoft.com/technet/pro.../anservog.mspx
--
Dave Wickert [MSFT]
dwickert (AT) online (DOT) microsoft.com
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.

"mike" <mike (AT) discussions (DOT) microsoft.com> wrote

I am having the same problem. Have you been able to figure out a
solution yet? I have tried the same query using a linked server and get
the same error message. I have even tried the examples that use
FoodMart 2000 and get the same error message.

If I connect in Query Analyzer to the SQL server on the same machine as
the AS server, I run the query without error. If I connect to any other
server, I get this error.

I hope there is some way to figure out what is happening.

I contacted Microsoft and figured out what my problem was. My
configuration had Server A with Analysis/SQL Server, Server B with SQL
Server, and my client machine. If I connected Query Analyzer from my
Client to Server A then OPENROWSET worked fine. If I connected my
Client to Server B and called Analysis server on Server A, I got the
[OLE/DB provider returned message: Database 'ABC' does not exist.].

If you have more than one hop in your connection, your login does not
propagate. The propagate user is NT AUTHORITY\ANONYMOUS LOGON. To
enable more than one hop, you must implement Kerberos. There are two
articles about this.
1) 817384 How To Use Kerberos Authentication for Microsoft SQL Server
2000
2) 828280 How to configure an Analysis server computer to use Kerberos

Ugh... the old two hop problem. You didn't mention server configuration in
your posting or I would have suggested that immediately. I had assumed that
either the RDBMS and AS server were together or that you were testing the
linked server on the machine where you defined it.

You know what they say about assumptions -- they will always come back to
haunt you :-)
--
Dave Wickert [MSFT]
dwickert (AT) online (DOT) microsoft.com
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.

"Steve" <squandt (AT) n-spacetechnology (DOT) com> wrote