Error in windows event logs: [sqsrvres] CheckQueryProcessorAlive: sqlexecdirect failed [sqsrvres] printODBCError: sqlstate = HYT00; native error = 0; message = [Microsoft][ODBC SQL Server Driver]Timeout expired  —————————- Suggestions from MSDN forum link: Reference link: http://social.msdn.microsoft.com/Forums/en-US/sqldisasterrecovery/thread/e5b8d938-e529-40f5-bdaa-601a8f6d7aca/ From the error it looks like there was issue with your network. Make sure you have a dedicated Heartbeat Network configured and that it is designated as such in Cluster Administrator. The public facing network can be configured for both Public […]

When you try to connect to SQL Server OLAP services hosted on a server from your desktop or client machine then it will require appropriate drivers to connect to SQL Server Analysis services.