| Troubleshooting Analysis Services 2005 connectivity problems (By Edward Melomed) |
| Written by Edward Melomed |
| Saturday, 19 May 2007 18:22 |
|
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.
Just to remind. There are two protocols you can use to connect to Analysis Server: TCP/IP and HTTP. 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. |
Latest Author Articles
- Configuring HTTP Access to SQL Server 2005 Analysis Services on Microsoft Windows Server 2003
- Configuring HTTP Access to SQL Server 2005 Analysis Services on Microsoft Windows XP
- SQL Server 2005 Analysis Services (SSAS) Server Properties
- Troubleshooting Analysis Services 2005 connectivity problems (By Edward Melomed)
- Backup Strategies with SQL Server 2005 Analysis Services
Top Rated
- SSAS Implementation Best Practices slides in PDF format
- SSRS Report Against a SSAS Parent Hierarchy
- Using AS Data Mining to Add Forecast Values to a Cube
- Handling inter-dimensional members dependency and reducing cube sparsity using reference dimensions in Analysis Services 2005
- Cube structure optimization for MDX query performance in Analysis Services 2005 SP2: Tips for Parent Child Hierarchies usage
- Handling Multiple Calendars with a M2M Scenario
- Passing MDX parameters in Reporting Services reports
- Using UserName to Control Data Access and Default Member in SSAS 2K5 (Carrie Williams)




