Report Portal

Troubleshooting Analysis Services 2005 connectivity problems (By Edward Melomed)

After answering quite a few questions on the Microsoft forum and getting some common questions regarding connectively to analysis services 2005 it is time to have a common place for look for information about how to troubleshoot connectivity:

There are several causes for connectivity problems.

  • Client components problems.
  • Firewall
  • Security problems.
  • Other problems

Just to remind. There are two protocols you can use to connect to Analysis Server: TCP/IP and HTTP.
Here are pointers to whitepapers on how to configure HTTP connectivity:
http://www.microsoft.com/technet/prodtechnol/sql/2005/httpssas.mspx
http://www.microsoft.com/technet/prodtechnol/sql/2005/httpasws.mspx

When troubleshooting HTTP connectivity problems, first make to connect to Analysis Server using TCP/IP from IIS machine using same credentials you use for IIS virtual directory.

Read more...

Tags: connectivity

 

2007-2015 VidasSoft Systems Inc.