This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(131.20000000000002, 11%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAJ%3C/text%3E%3C/svg%3E)
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
Hi @Amy Jandreau , 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!
Hi @Amy Jandreau , 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!
Hi @Amy Jandreau ,
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:
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.
Thanks, but when i right click on the solution and click on properties, all I get is a blank screen. I have no issues processing from SSMS