Error in Starting SSAS Tabluar Service in Windows Server 2012 R2

%3CLINGO-SUB%20id%3D%22lingo-sub-1007407%22%20slang%3D%22en-US%22%3EError%20in%20Starting%20SSAS%20Tabluar%20Service%20in%20Windows%20Server%202012%20R2%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1007407%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20All%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20facing%20issue%20while%20starting%20up%20Sql%20Server%20Analysis%20service%20in%20Windows%20Server%202012%20R2.%26nbsp%3B%20My%20Sql%20Server%20version%20is%20Sql%20Server%202016%20Enterprise%20edition.%26nbsp%3B%20I%20am%20getting%20error%20%22The%20request%20failed%20or%20the%20service%20did%20not%20respond%20in%20a%20timely%20fashion.%20Consult%20the%20event%20log%20or%20other%20applicable%20error%20logs%20for%20details.%22%20when%20i%20am%20running%20form%20Sql%20server%20configuration%20manager.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFor%20the%20service%20account%20which%20running%20by%20Analysis%20services%20it%20is%20part%20of%20local%20Administrators%20group.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20help%20me%20to%20solve%20this.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20in%20advance.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1019786%22%20slang%3D%22en-US%22%3ERe%3A%20Error%20in%20Starting%20SSAS%20Tabluar%20Service%20in%20Windows%20Server%202012%20R2%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1019786%22%20slang%3D%22en-US%22%3EHey%2C%3CBR%20%2F%3E%3CBR%20%2F%3EPlease%20ensure%20there%20is%20enough%20memory%20available%20for%20the%20Service%20to%20start%2C%20If%20there%20are%20other%20services%20on%20the%20Server%2C%20ex.%20SQL%2C%20then%20leave%2010%2B%20G%20memory%20free%20for%20the%20SSAS%20service..%20depending%20on%20your%20configuration%3CBR%20%2F%3E%3CBR%20%2F%3E%2Fregards%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1019927%22%20slang%3D%22en-US%22%3ERe%3A%20Error%20in%20Starting%20SSAS%20Tabluar%20Service%20in%20Windows%20Server%202012%20R2%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1019927%22%20slang%3D%22en-US%22%3E%3CP%3EThank%20you%20for%20reply%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F321590%22%20target%3D%22_blank%22%3E%40renefk%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EServer%20has%2048%20GB%20memory%20on%20the%20server%2C%20but%20still%20no%20luck%20%3A(%3C%2Fimg%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1019942%22%20slang%3D%22en-US%22%3ERe%3A%20Error%20in%20Starting%20SSAS%20Tabluar%20Service%20in%20Windows%20Server%202012%20R2%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1019942%22%20slang%3D%22en-US%22%3Eyes%2C%20but%20can%20you%20elaborate%20on%20the%20amount%20allocated%20to%20other%20resources%3F%3CBR%20%2F%3E%3CBR%20%2F%3E%3CBR%20%2F%3EFunction%20Test-MemoryUsage%20%7B%3CBR%20%2F%3E%5Bcmdletbinding()%5D%3CBR%20%2F%3EParam()%3CBR%20%2F%3E%3CBR%20%2F%3E%24os%20%3D%20Get-Ciminstance%20Win32_OperatingSystem%3CBR%20%2F%3E%24pctFree%20%3D%20%5Bmath%5D%3A%3ARound((%24os.FreePhysicalMemory%2F%24os.TotalVisibleMemorySize)*100%2C2)%3CBR%20%2F%3E%3CBR%20%2F%3Eif%20(%24pctFree%20-ge%2045)%20%7B%3CBR%20%2F%3E%24Status%20%3D%20%22OK%22%3CBR%20%2F%3E%7D%3CBR%20%2F%3Eelseif%20(%24pctFree%20-ge%2015%20)%20%7B%3CBR%20%2F%3E%24Status%20%3D%20%22Warning%22%3CBR%20%2F%3E%7D%3CBR%20%2F%3Eelse%20%7B%3CBR%20%2F%3E%24Status%20%3D%20%22Critical%22%3CBR%20%2F%3E%7D%3CBR%20%2F%3E%3CBR%20%2F%3E%24os%20%7C%20Select%20%40%7BName%20%3D%20%22Status%22%3BExpression%20%3D%20%7B%24Status%7D%7D%2C%3CBR%20%2F%3E%40%7BName%20%3D%20%22PctFree%22%3B%20Expression%20%3D%20%7B%24pctFree%7D%7D%2C%3CBR%20%2F%3E%40%7BName%20%3D%20%22FreeGB%22%3BExpression%20%3D%20%7B%5Bmath%5D%3A%3ARound(%24_.FreePhysicalMemory%2F1mb%2C2)%7D%7D%2C%3CBR%20%2F%3E%40%7BName%20%3D%20%22TotalGB%22%3BExpression%20%3D%20%7B%5Bint%5D(%24_.TotalVisibleMemorySize%2F1mb)%7D%7D%3CBR%20%2F%3E%3CBR%20%2F%3E%7D%3CBR%20%2F%3ETest-MemoryUsage%3CBR%20%2F%3E%3CBR%20%2F%3Ecan%20you%20run%20above%20Powershell%20command%20and%20return%20the%20result%20%3F%3C%2FLINGO-BODY%3E
New Contributor

Hi All,

 

I am facing issue while starting up Sql Server Analysis service in Windows Server 2012 R2.  My Sql Server version is Sql Server 2016 Enterprise edition.  I am getting error "The request failed or the service did not respond in a timely fashion. Consult the event log or other applicable error logs for details." when i am running form Sql server configuration manager.

 

For the service account which running by Analysis services it is part of local Administrators group.

 

Please help me to solve this.

 

Thanks in advance.

3 Replies
Hey,

Please ensure there is enough memory available for the Service to start, If there are other services on the Server, ex. SQL, then leave 10+ G memory free for the SSAS service.. depending on your configuration

/regards

Thank you for reply @renefk 

 

Server has 48 GB memory on the server, but still no luck :(

yes, but can you elaborate on the amount allocated to other resources?


Function Test-MemoryUsage {
[cmdletbinding()]
Param()

$os = Get-Ciminstance Win32_OperatingSystem
$pctFree = [math]::Round(($os.FreePhysicalMemory/$os.TotalVisibleMemorySize)*100,2)

if ($pctFree -ge 45) {
$Status = "OK"
}
elseif ($pctFree -ge 15 ) {
$Status = "Warning"
}
else {
$Status = "Critical"
}

$os | Select @{Name = "Status";Expression = {$Status}},
@{Name = "PctFree"; Expression = {$pctFree}},
@{Name = "FreeGB";Expression = {[math]::Round($_.FreePhysicalMemory/1mb,2)}},
@{Name = "TotalGB";Expression = {[int]($_.TotalVisibleMemorySize/1mb)}}

}
Test-MemoryUsage

can you run above Powershell command and return the result ?