Share via

Powershell with multidimensional and tabular ssas instances

Christoph Muthmann 181 Reputation points
2022-08-16T09:30:31.007+00:00

Hi All!

I've got two SSAS instances, one with multidimensional databases (#1) and one with a tabular model (#2).

I have stopped the multidimensional instance (#1) because we do not need it any more. When I try to connect via powershell to sqlas

cd '\sqlas\servername\instanz2\databases'
it is resulting in an error: A connection cannot be made. Ensure that the server is running.

After starting instance #1, the connection to instance #2 can be made immediately.

But I want to get rid of instance #1. How can I tell powershell not to connect to instance #1 first but to use instance #2 only?
Will an uninstall of #1 help?

Kind regards,
Christoph

SQL Server Analysis Services
SQL Server Analysis Services

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.

Windows for business | Windows Server | User experience | PowerShell
0 comments No comments

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.