New-SCSSASConnection

Creates a connection to SQL Server Analysis Services.

Description

The New-SCSSASConnection cmdlet creates a connection to SQL Server Analysis Services (SSAS) and creates a database named VMMAnalysisServerDB on the SSAS server. 

This cmdlet assumes that SSAS and Operations Manager Reporting Server are installed on the same computer. Therefore, New-SSASConnection also connects to the SQL Server Reporting Server Web Service to update the credentials for forecasting reports to connect to Analysis Services.

For more information about New-SCSSASConnection, type: "Get-Help New-SCSSASConnection -online".

Parameters

ComputerName

Required? true
Accept Pipeline Input? false
Position? named 
Specifies the name of a computer that VMM can uniquely identify on your network. Valid formats are: FQDN, IPv4 or IPv6 address, or NetBIOS name.

NOTE: See the examples for a specific cmdlet to determine how that cmdlet specifies the computer name.

Credential

Required? true
Accept Pipeline Input? false
Position? named 
Specifies a credential object or, for some cmdlets, a Run As account object that contains the user name and password of an account that has permission to perform this action. Or, in the case of Restart-SCJob, has permission to complete a restarted task. 

For more information about the PSCredential object, type: "Get-Help Get-Credential". 
For more information about Run As accounts, type: "Get-Help New-SCRunAsAccount".

InstanceName

Required? true
Accept Pipeline Input? false
Position? named 
Specifies the SQL Server Analysis Services (SSAS) database instance name.

Port

Required? true
Accept Pipeline Input? false
Position? named 
Specifies the network port to use when adding an object or creating a connection. Valid values are: 1 to 4095.

JobVariable

Required? false
Accept Pipeline Input? false
Position? named 
Specifies that job progress is tracked and stored in the variable named by this parameter.

PROTipID

Required? false
Accept Pipeline Input? false
Position? named 
Specifies the ID of the PRO tip that triggered this action. This allows for auditing of PRO tips.

RunAsynchronously

Required? false
Accept Pipeline Input? false
Position? named 
Indicates that the job runs asynchronously so that control returns to the command shell immediately.

VMMServer

Required? false
Accept Pipeline Input? true (ByValue)
Position? named 
Specifies a VMM server object.

Examples

1: Create a connection to SQL Server Analysis Service. 
PS C:\> $SSASCreds = Get-SCRunAsAccount -Name "SSASRunAsAcct"
PS C:\> $SSASSConnection = New-SCSSASConnection -ComputerName "SQLServer01" -InstanceName MSSQLServer -Port 2383 -Credential $SSASCreds

The first command gets the Run As account object named SSASRunAsAcct and stores the object in the $SSASCreds variable. This credential needs to be an administrator in both the SQL Server Analysis Service Instance and SQL Server Reporting Instance.

The second command creates an SSAS connection to SQL Server SQLServer01, using the default instance name of MSSQLServer and port 2383. New-SCASSConnection uses the credentials provided in the Run As account stored in $SSASCreds to create the connection.

See Also