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(89.60000000000001, 18%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDM%3C/text%3E%3C/svg%3E)
When installing SSIS or SSAS using SQL Server Installation Center It says that they are already installed. When I open SSMS (Management Studio) The only option I have is to logon to the database engine. The box is grayed out. See below. Can someone tell me what to do?
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
Which version of SSMS do you have? SSMS 22 became generally available yesterday, so you may want to download it and give it a spin. Note that support for SSIS and SSAS are optional components, so you need to select these when you install.
Also note that your current version of SSMS will not be affected. Different major versions of SSMS install side by side.
![](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(134.4, 49%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAG%3C/text%3E%3C/svg%3E)
Hi @Douglas M ,
Thanks for the input, @Erland Sommarskog
Douglas M ,could you please try this and let us know if it resolves the issue? If it works, marking the answer would help others facing the same problem.
Thanks,
Akhil.