ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Excel Add-in for Analysis Services: can't connect (https://www.excelbanter.com/excel-programming/349140-excel-add-analysis-services-cant-connect.html)

mta37

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



All times are GMT +1. The time now is 10:28 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com