Hi there,

I have a problem with connecting to the Microsoft SQL
Server 2000 Analysis Services via a client. However I have
no problem connecting to the Analysis Server directly on
the server itself. When I try to connect via the client I
get the following message:
"Path not found"

However I can access "Edit Repository Connection String"
which means my client can see the server and even access
it to some degree.

I recently migrated the repository to a local SQL2k. I
think the problem started after the migration.

!!! Any suggestions would be greatly appreciated !!!

Thanks in advance,
Annick van den Broek

EXTRA INFO:

Server:
-- Language: English
-- Microsoft Windows 2000; 5.00.2195; Service Pack 3
-- Analysis Manager (About Microsoft SQL Server 2000
Analysis Services); 8.0.760
-- Repository Migrated to local-SQL2k
-- SQL Server (About SQL Server Enterprise Manager);
8.00.760
-- Microsoft Analysis Services\Bin\msmdsrv.exe; 8.0.760.0
-- Program Files\Common Files\Microsoft
Shared\DSO\msmddo80.dll; 8.0.0.760
-- Program Files\Common Files\System\Ole DB\msolap80.dll;
8.0.760.0

Client:
-- Language: Dutch
-- Microsoft Windows XP; Professional; Versie 2002
-- Analysis Manager (About Microsoft SQL Server 2000
Analysis Services); 8.0.760
-- SQL Server (About SQL Server Enterprise Manager);
8.00.760
-- Program Files\Common Files\Microsoft
Shared\DSO\msmddo80.dll; 8.0.0.760
-- Program Files\Common Files\System\Ole DB\msolap80.dll;
8.0.760.0

Hi Annick,

Could you please do this test for me go to the command prompt on the XP
client where you see this error from and try to make the following
connection:

net use \\yourASservername\MsOLAPRepository$

Does this command complete succesfully?

If not is this share available set to the program files\Microsoft analysis
services\bin directory on the AS server, does this user have acces to this
share etc? Is netbios working?

HTH,
Bas

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

Hi Bas,

Thanks for you're reply. The problem is solved.
Somehow .. ?? .. the share MsOLAPRepository$ was removed.
I reinstalled the share. Gave OLAP Administrators access
to it .. and voila it works. However can't figure out how
the share got removed.

Thanks for you're help,
Annick van den Broek