Re: Cannot open connection to Analysis server
From: Danny Ravid (danny@deltathree.com)
Date: 09/26/02
- Next message: Sue Hoegemeier: "Re: Permissions required to view SQL counters in System Monitor"
- Previous message: jimmers: "Re: How can i know what SQL Servers are available on the intranet"
- In reply to: Hari Prasad: "Cannot open connection to Analysis server"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
From: "Danny Ravid" <danny@deltathree.com> Date: Thu, 26 Sep 2002 14:39:16 +0300
i have encountered this problem before ,it happend to me when using
and MDB (access) database for analysis services repository ,
the MDB got corrupted,i just used ACCESS 2000 to repair it,and it worked.
look for "msmdrep.mdb" in Analysis services folders.
Regards
Danny Ravid
Senior DBA
DELTATHREE INC.
"Hari Prasad" <Hari.Prasad@weltec.ac.nz> wrote in message
news:909701c264e0$dd84e040$35ef2ecf@TKMSFTNGXA11...
> I am trying to connect to an Analysis Server running on
> Win2K server from my PC (running Win2K Pro) and I keep
> getting the following error:
> Cannot open connection to Analyis server 'servername'.
> Error in data [Possible data corruption]''
>
> I have spent a lot of time surfing the net to find a
> solution. In one of the newsgroup messages I read that
> this problem could be due to the MSSQLADHelper file in
> SP2. I have tried copying the old SQLADHLP and XPADSI
> files from the SQL Server RTM CD ROM to the respective
> directories - but still the same problem. I am at my
> wit's end and would appreciate any pointers please. I can
> access the server from the Server box itself without any
> problems.
- Next message: Sue Hoegemeier: "Re: Permissions required to view SQL counters in System Monitor"
- Previous message: jimmers: "Re: How can i know what SQL Servers are available on the intranet"
- In reply to: Hari Prasad: "Cannot open connection to Analysis server"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
