View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
mta37 mta37 is offline
external usenet poster
 
Posts: 1
Default Excel Add-in for Analysis Services: can't connect


Hi,

I've installed Office 2003 (the trial of the Standard edition) alon
with the Excel Add-In for Analysis Services on a Windows Server 200
box that is running SQL Server 2005.

When I select Build Report in Excel to connect to a cube I've created
am getting the following error when attempting to connect to th
server:

OLAP Server error on connection SCSRV-DR2\MATTTEST

OLAP Server error: Unable to connect to the Analysis Server. The serve
name 'SCSRV-DR2\MATTTEST' was not found. Please verify that the name yo
entered is correct, and then try again.

The analysis server and the SQL server are both started. I have trie
reinstalling Office and the Add-In without any luck. Can anyone hel
out with this, or direct me to extra resources for the add-in?

Thanks,
Mat

--
mta3
-----------------------------------------------------------------------
mta37's Profile: http://www.excelforum.com/member.php...fo&userid=1825
View this thread: http://www.excelforum.com/showthread.php?threadid=49676