BI Portal 2003 connecting to SSAS 2005

Hi,

I seem to have a problem connecting to the analysis server 2005 when I create a data source in BIP 2003. When I supply the servername, it says that "the server does not exist or access denied". However, when I try to use the Advanced option and create a connection string, I encounter an error message stating the ff:

Line: 465
Char: 4
Error: the object doesn't support this property or method
Code: 0
URL: http://localhost:8080/_layouts/1033/Menu.htc

How can I make a data source connection? Help is very much appreciated.

Thanks in advance,
May Lanie

If you would like to connect to Analysis Services using HTTP, you need to make sure you setup HTTP connectivity to Analysis Server. Here is whitepaper on how to do that: http://www.microsoft.com/technet/prodtechnol/sql/2005/httpssas.mspx

If you would like to connect to AS using TCP/IP, here is set of instructions on how to troubleshoot connectivity problems http://www.sqljunkies.com/WebLog/edwardm/archive/2006/05/26/21447.aspx

Hope that helps.

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

|||

Hello May,

Were you able to resolve this issue? I am experiencing the same issue. Please let me know either way. I will let you know what I find.

Thanks