New-SCSSASConnection
New-SCSSASConnection
Creates a connection to SQL Server Analysis Services.
Syntax
Parameter Set: Default
New-SCSSASConnection -ComputerName <String> -Credential <VMMCredential> -InstanceName <String> -Port <Int32> [-JobVariable <String> ] [-PROTipID <Guid> ] [-RunAsynchronously] [-VMMServer <ServerConnection> ] [ <CommonParameters>]
Detailed 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.
Parameters
-ComputerName<String>
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.
Aliases |
none |
Required? |
true |
Position? |
named |
Default Value |
none |
Accept Pipeline Input? |
false |
Accept Wildcard Characters? |
false |
-Credential<VMMCredential>
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".
Aliases |
none |
Required? |
true |
Position? |
named |
Default Value |
none |
Accept Pipeline Input? |
false |
Accept Wildcard Characters? |
false |
-InstanceName<String>
Specifies the SQL Server Analysis Services (SSAS) database instance name.
Aliases |
none |
Required? |
true |
Position? |
named |
Default Value |
none |
Accept Pipeline Input? |
false |
Accept Wildcard Characters? |
false |
-JobVariable<String>
Specifies that job progress is tracked and stored in the variable named by this parameter.
Aliases |
none |
Required? |
false |
Position? |
named |
Default Value |
none |
Accept Pipeline Input? |
false |
Accept Wildcard Characters? |
false |
-Port<Int32>
Specifies the network port to use when adding an object or creating a connection. Valid values are: 1 to 4095.
Aliases |
none |
Required? |
true |
Position? |
named |
Default Value |
none |
Accept Pipeline Input? |
false |
Accept Wildcard Characters? |
false |
-PROTipID<Guid>
Specifies the ID of the PRO tip that triggered this action. This allows for auditing of PRO tips.
Aliases |
none |
Required? |
false |
Position? |
named |
Default Value |
none |
Accept Pipeline Input? |
false |
Accept Wildcard Characters? |
false |
-RunAsynchronously
Indicates that the job runs asynchronously so that control returns to the command shell immediately.
Aliases |
none |
Required? |
false |
Position? |
named |
Default Value |
none |
Accept Pipeline Input? |
false |
Accept Wildcard Characters? |
false |
-VMMServer<ServerConnection>
Specifies a VMM server object.
Aliases |
none |
Required? |
false |
Position? |
named |
Default Value |
none |
Accept Pipeline Input? |
True (ByValue) |
Accept Wildcard Characters? |
false |
<CommonParameters>
This cmdlet supports the common parameters: -Verbose, -Debug, -ErrorAction, -ErrorVariable, -OutBuffer, and -OutVariable. For more information, see about_CommonParameters (https://go.microsoft.com/fwlink/p/?LinkID=113216).
Inputs
The input type is the type of the objects that you can pipe to the cmdlet.
Outputs
The output type is the type of the objects that the cmdlet emits.
- String
Examples
1: Create a connection to SQL Server Analysis Service.
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.
PS C:\> $SSASCreds = Get-SCRunAsAccount -Name "SSASRunAsAcct"
PS C:\> $SSASSConnection = New-SCSSASConnection -ComputerName "SQLServer01" -InstanceName MSSQLServer -Port 2383 -Credential $SSASCreds