What is the Powershell warning and How to get rid of this Warning??

Question

What is the Powershell warning and How to get rid of this Warning??

SQL_Hunt

SSC-Dedicated

Points: 33518
More actions
October 5, 2014 at 8:35 am

#293919

WARNING: Failed to load the 'SQLAS' extension: An exception occurred in SMO while trying to manage a service. --> Failed to retrieve data for this request. --> Invalid class
Thanks.

Viewing 5 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Eirikur Eiriksson SSC Guru Points: 182948 More actions · Answer 1

SQL-DBA-01 (10/5/2014)
WARNING: Failed to load the 'SQLAS' extension: An exception occurred in SMO while trying to manage a service. --> Failed to retrieve data for this request. --> Invalid class

This is a PS provider for Analysis Services. To get rid of this error try the following:

😎

Open SP as Administrator

/* Unrestricted Execution policy */

SET ExecutionPolicy UnRestreicted

/* Import the SQLPS module */

Import-Module SQLPS –DisableNameChecking

/* Import the SQLAS Commandlet*/

Import-module sqlascmdlets

/* List SQLAS commands*/

Get-command -module SQLASCmdlets

bcbarnestx Valued Member Points: 69 More actions · Answer 2

I'm getting the same error as the OP, and the above reply does not help.

I have Sql Analysis Services installed and running. When I enter the following into PowerShell:

import-module SqlPS -DisableNameChecking

I get the same warning message shown in the OP.

Any clues on what is going on here?

lansalot Valued Member Points: 69 More actions · Answer 3

PS C:\> powershell

Windows PowerShell

PS C:\> ipmo sqlps -DisableNameChecking

WARNING: Failed to load the 'SQLAS' extension: An exception occurred in SMO

while trying to manage a service. --> Failed to retrieve data for this request.

--> Invalid class

PS SQLSERVER:\> exit

PS C:\> powershell

Windows PowerShell

PS C:\> ipmo sqlps -WarningAction SilentlyContinue -DisableNameChecking

PS SQLSERVER:\>

nosqldba SSC Journeyman Points: 75 More actions · Answer 4

Note the

"This is a PS provider for Analysis Services. To get rid of this error try the following:"

comment

If Analysis Services in not installed, the error will persist:-D

Make sure it's running too or you'll get the warning below

WARNING: The local computer does not have an active instance of Analysis Services.