March 20, 2014 at 6:53 pm
Hi All,
I have a 3 node cluster on which I have installed SSAS as it's own insntance. I have created this as a named instance and can connect to it by server\instance if I'm on the server itself. However from my desktop I get the error saying instance was not found on server name.
I have defined an alternate port and setup firewall rules and can connect via server:port but not server\instance. Prior to making this change SSAS was running on default port of 2383 and I could connect just by servername.
I have read many articles for previous versions saying that clustered SSAS will always use 2383 and that you must connect just using servername. However and this is were it gets strange. I have a 2 node UAT cluster with SSAS setup exactly the same way I've described above and I can connect from my desktop as server\instance.
Should I be able to connect as server\instances for a named clustered instance in 2012 ? If not I'll put UAT down to being an oddity if so can you tell me what I may be missing.
Many Thanks
Corinne
March 20, 2014 at 10:52 pm
corinne_crawford (3/20/2014)
Hi All,I have a 3 node cluster on which I have installed SSAS as it's own insntance. I have created this as a named instance and can connect to it by server\instance if I'm on the server itself. However from my desktop I get the error saying instance was not found on server name.
I have defined an alternate port and setup firewall rules and can connect via server:port but not server\instance. Prior to making this change SSAS was running on default port of 2383 and I could connect just by servername.
I have read many articles for previous versions saying that clustered SSAS will always use 2383 and that you must connect just using servername. However and this is were it gets strange. I have a 2 node UAT cluster with SSAS setup exactly the same way I've described above and I can connect from my desktop as server\instance.
Should I be able to connect as server\instances for a named clustered instance in 2012 ? If not I'll put UAT down to being an oddity if so can you tell me what I may be missing.
Many Thanks
Corinne
If the SSAS instance was started through Cluster Administrator, all clustered SSAS instances whether default or named instances always listen on the default port 2383. Whereas if the SSAS instance was not started through Cluster Administrator , then it behaves as a stand alone instance and will use dynamic port allocation through SQL Browser service.
The only supported way to connect to a clustered SSAS instance ( Default or Named instance) is to use VirtualServerName and not VirtualServerName\InstanceName. And all clustered instances always listens on the default port 2383. This is because SQL Browser service is not cluster aware and can't be used for dynamic port allocation of SSAS Named instance.
So on UAT server check if the SSAS service was started outside cluster administrator and hence has a peculiar behavior. So rule out things, start the UAT instance within the cluster administrator and observer the behavior.
The key here is not to start SSAS Named instance outside the cluster administrator. If done so then it will behave as a Non-Clustered Named Instance.
Note:
VirtualServerName\InstanceName may work sometimes but it's not gauranteed always and also not supported by MS.
--
SQLBuddy
March 24, 2014 at 9:22 pm
Many Thanks for the clarification
March 25, 2014 at 8:12 am
You are welcome, Corinne 🙂
--
SQLBuddy
May 2, 2014 at 6:09 pm
Hi,
i have similar problem, i have two nodes, i have installed default instance with only SQL services and named instance with only SSAS. i was able to connect to SSAS using SSAS virtual name\instancename, from today morning i was not able to access the SSAS using SSAS virtual name or SSAS virtual name\instancename, but i am able to access it by providing Servername on which SSAS role is running. i restarted SSAS role using Failover cluster manager many times, but i am not able to connect it through SSAS virtual name. i am getting following error message.
TITLE: Connect to Server
------------------------------
Cannot connect to XXXXXXXXX
------------------------------
ADDITIONAL INFORMATION:
A connection cannot be made. Ensure that the server is running. (Microsoft.AnalysisServices.AdomdClient)
------------------------------
No connection could be made because the target machine actively refused it XXXXXXXXX:2383 (System)
------------------------------
BUTTONS:
OK
------------------------------
December 15, 2015 at 9:32 am
Hey together,
it might be a little bit late, but i had the same problem today.
The solution is real simple. You need to assign a port to your SSAS Instance, and while connecting from Excel just use the servername and that assigned port. Your server address should look like that: "Servername:Port".
You can also use the auto assigned port, but it changed with a restart.
Hope I could help anyone
Kind regards
Thomas
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply