New-SCSSASConnection

Creates a connection to SQL Server Analysis Services.

Syntax

New-SCSSASConnection
   [-VMMServer <ServerConnection>]
   -ComputerName <String>
   -InstanceName <String>
   -Port <Int32>
   -Credential <VMMCredential>
   [-RunAsynchronously]
   [-PROTipID <Guid>]
   [-JobVariable <String>]
   [<CommonParameters>]

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, this cmdlet also connects to the SQL Server Reporting Server Web Service to update the credentials for forecasting reports to connect to Analysis Services.

Examples

Example 1: Create a connection to SSAS

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 then stores that 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. This cmdlet uses the credentials provided in the Run As account stored in $SSASCreds to create the connection.

Parameters

-ComputerName

Specifies the name of a computer that VMM can uniquely identify on your network. Valid formats are:

  • FQDN (fully qualified domain name)
  • IPv4 or IPv6 address
  • NetBIOS name
Type:String
Position:Named
Default value:None
Required:True
Accept pipeline input:False
Accept wildcard characters:False

-Credential

Specifies a credential object or that contains the user name and password of an account that has permission to perform this action. For more information about the PSCredential object, type Get-Help Get-Credential.

Type:VMMCredential
Position:Named
Default value:None
Required:True
Accept pipeline input:False
Accept wildcard characters:False

-InstanceName

Specifies the SSAS database instance name.

Type:String
Position:Named
Default value:None
Required:True
Accept pipeline input:False
Accept wildcard characters:False

-JobVariable

Specifies a variable in which job progress is tracked and stored.

Type:String
Position:Named
Default value:None
Required:False
Accept pipeline input:False
Accept wildcard characters:False

-Port

Specifies the network port to use when adding an object or creating a connection. Valid values are: 1 to 4095.

Type:Int32
Position:Named
Default value:None
Required:True
Accept pipeline input:False
Accept wildcard characters:False

-PROTipID

Specifies the ID of the Performance and Resource Optimization tip (PRO tip) that triggered this action. This parameter lets you audit PRO tips.

Type:Guid
Position:Named
Default value:None
Required:False
Accept pipeline input:False
Accept wildcard characters:False

-RunAsynchronously

Indicates that the job runs asynchronously so that control returns to the command shell immediately.

Type:SwitchParameter
Position:Named
Default value:None
Required:False
Accept pipeline input:False
Accept wildcard characters:False

-VMMServer

Specifies a VMM server object.

Type:ServerConnection
Position:Named
Default value:None
Required:False
Accept pipeline input:True
Accept wildcard characters:False

Outputs

String

This cmdlet returns a String object.