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.
Tags: connectivity