question

AmyJandreau-8392 avatar image
0 Votes"
AmyJandreau-8392 asked CarrinWu-MSFT commented

Connection cannot be made while processing dimension

Hi All,
I opened my SSAS Database using SSDT. I tested the connection to Data Sources and was tested successfully. However when i tried to process a dimension i am getting the below error
TITLE: Microsoft Visual Studio



A connection cannot be made. Ensure that the server is running.


BUTTONS:

OK




I checked all the services are running, Please advice.
Thanks

sql-server-analysis-services
· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @AmyJandreau-8392, we have not get a reply from you. Could below answers help you? If yes, please do "Accept Answer". By doing so, it will benefit for community members who have this similar issue. Your contribution is highly appreciated. Thank you!

0 Votes 0 ·

Hi @AmyJandreau-8392, we have not get a reply from you. Could below answers help you? If yes, please do "Accept Answer". By doing so, it will benefit for community members who have this similar issue. Your contribution is highly appreciated. Thank you!

0 Votes 0 ·

1 Answer

CarrinWu-MSFT avatar image
0 Votes"
CarrinWu-MSFT answered

Hi @AmyJandreau-8392,

Thanks for your posting.

The SSAS connectivity issue can be cause by several reasons.

1.Have you right click your solution to check the target server name? Please refer to below shotscreen:
143508-1.png

2.Make sure the TCP has been enabled and the port is open in the firewall. Default instance listens to TCP port 2383. If the client does not use a port number or an instance name, and it is TCP connection, the client will try reach TCP port 2383. The best way to test if this port is open is to use telnet.

3.Make sure there haven't any antivirus software block your connection.

4.Try to restart servers.

For more information, please refer to Connect to SQL Server Analysis Services.


Best regards,
Carrin


If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.



1.png (108.6 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.