Tuesday, March 27, 2012

Cannot Enable Remote Connections for AS 2005 on clustered instance

Hello SQL pros -

I am having a problem with enabling the remote connections for Analysis
Services 2005, Here's the gist....

--Error Information--
"To configure Analysis Services for Remote Connections, you must be an
adminsitrator for Analysis Services Windows Service (SQLSAC).

Additonal Info
A connection cannot be made. Ensure that service is running
(Microsoft.AnalysisServices)
No connection could be made because the target machine actively refused
it (System)."

--Actions Taken--
1) Analysis Services Windows Service was confirmed to be running.
2) Analysis Services Windows Service was stopped and restarted.
3) Analysis Services Windows Service (and SQL Accounts) confirmed to be
running under domain account with administrator priviledges.
4) Confirmed connectivity to Analysis Services instance through direct
connection (Windows Authentication)

--OS/System Information--
Windows 2000 Service Pack 5

--Clustering Roles--
Primary node for 1 SQL 2000 SP4 instance
Secondary node 1 SQL 2000 SP4 instance
Primary node for 1 Analysis Services 2000 instance
Primary node for 1 SQL 2005 instance, and primary
Primary node for 1 SQL 2005 Analysis Services Instance

I didn't find anything of relevance in the Windows logs or SQL logs.
So I am not sure where else to look. Is this a bug with 2005?

Any Suggestions to help troubleshoot are greatly appreciated!

thanks in advance.

ben

First.

Here some fresh blog post on how to troubleshoot connectivity problems with Analysis Services:

http://www.sqljunkies.com/WebLog/edwardm/

Second.
You saying
"4) Confirmed connectivity to Analysis Services instance through direct
connection (Windows Authentication)"

Analysis Services support only Windows Authentication when connecing through TCP/IP.

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

|||

Please also note when connecting to clustered Analysis Server you only need to specify "VirtualServer" as a server name , not "VirtualServer\Instace".

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

|||

ANTIVIRUS PROBLEM

uninstall your antivirus and try again

No comments:

Post a Comment