SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,165 questions
Analysis Service very slow to connect in SQL Management Studio
![](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(57.599999999999994, 13%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENK%3C/text%3E%3C/svg%3E)
Norman K. F. Chow
80
Reputation points
Hi all,
I have a SQL Server, SSAS and SQL Server Management Studio installed on the same PC.
Connecting to the SQL Database Engine in SSMS is very fast.
However, connecting to SSAS in SSMS is excruciatingly slow, even though it is just a localhost connection. The SSAS databases are all multidimensional. Is there any way to speed up the connection? Thanks.