Hello,
I have am setting up a new internal cloud. Everyting is System Center 2012 SP1 on Windows 2012, SQL 2012 etc.
I have connected VMM to Operations Manager successfully, had the issue with Pro Tip but now that is reporting green!
When I attempt to intergrate SQL Server Analysis Services however this causes a crash and restsrt to the System center Virtual machine Manager service.
There is very little helpful information in the Logs, I did get the issue of requiring the SQL AMO and installed SQL 2012 AMO and then the 2008 AMO as the 2012 AMO did not help, I have now removed the 2012 AMO.
VMM error log output:
Version=1 EventType=VMM20 EventTime=130111486497208436 ReportType=1 Consent=1 UploadTime=130111486497448445 ReportIdentifier=636bea8f-aba8-11e2-93f9-00155d075a10 Response.type=4 Sig[0].Name=appName Sig[0].Value=vmmservice Sig[1].Name=appVersion Sig[1].Value=3.1.6011.0 Sig[2].Name=assemblyName Sig[2].Value=Microsoft.AnalysisServices Sig[3].Name=assemblyVer Sig[3].Value=0.0.0.0 Sig[4].Name=methodName Sig[4].Value=M.A.DimeRecord.ReadHeader Sig[5].Name=exceptionType Sig[5].Value=M.AnalysisServices.ResponseFormatException Sig[6].Name=callstackHash Sig[6].Value=dea4 DynamicSig[1].Name=OS Version DynamicSig[1].Value=6.2.9200.2.0.0.400.8 DynamicSig[2].Name=Locale ID DynamicSig[2].Value=3081 FriendlyEventName=Stopped working ConsentKey=VMM20 AppName=System Center Virtual Machine Manager 2012SP1 AppPath=C:\Program Files\Microsoft System Center 2012\Virtual Machine Manager\Bin\vmmservice.exe ReportDescription=Stopped working
-----
I also attempted to add the SSRS connection via powershell, the SCVMM console was not open, this returned;
New-SCSSASConnection -ComputerName "<ServerName>" -InstanceName "mssqlserver" -Port 80 -RunAsynchronously -Credential $credential New-SCSSASConnection : Unable to retrieve the result of the job because the connection to the Virtual Machine Manager management server <ServerName>.FQDN was lost. The job will continue running on <ServerName>.FQDN until it completes. (Error ID: 1611) 1) Verify that <serverName>.FQDN is online and can be remotely accessed from your computer. 2) Verify that the Virtual Machine Manager service is started on <ServerName>.FQDN. If the problem persists, restart the Virtual Machine Manager service. To find out the result of the job, re-connect to the server, and run the following cmdlet: PS> Get-VMMServer<serverName>.FQDN | Get-Job | where { $_.ID -eq "29679ac3-d3a9-42fc-a6e1-6e4a3c1f7d14"} At line:1 char:1 + New-SCSSASConnection -ComputerName "<ServerName>" -InstanceName "mssqlserver" -Port ... + ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ + CategoryInfo : ReadError: (:)[New-SCSSASConnection], CarmineEx ception
+ FullyQualifiedErrorId :
1611,Microsoft.SystemCenter.VirtualMachineManager.Cmdlets.NewSCSSASConnection
--------------------------------------------------------------------------
Basically the service had crashed again and restarted, I ran the command as above and below and this returned;
C:\windows\system32> Get-VMMServer <ServerName>.FQDN | Get-Job | where { $_.ID -eq "29679ac3-d3a9-42fc-a6e1-6e4a3c1f7d14"}
Name : Set SQL Analysis Services connection Description : Set SQL Analysis Services connection Progress : 0% Status : Failed CmdletName : New-SCSSASConnection ErrorInfo : TaskCancelledOnRestart (1700) StartTime : 23/04/2013 10:04:09 AM EndTime : 23/04/2013 10:04:18 AM Owner : TEST\<LogonID> ErrorInfo : TaskCancelledOnRestart (1700) AdditionalMessages : {} ResultName : Job Failed ResultObjectTypeName : SQL Server Analysis Services Connection IsStoppable : FalseIsRestartable : False
Suggestions please?
- Edited by MrVirtual Tuesday, April 23, 2013 12:59 AM