June 27, 2014 at 2:32 am
I installed SQL Server 2008 standard edition with service pack 1 on windows server 2008 std. But when I login to the Analysis Services by studio management, following error is shown.
A connection cannot be made. Ensure that the server is running (Microsoft.AnalysisServices.AdomdClient)
No Connection could be made because the target machine actively refused it 127.0.0.1:2383
But I can login to Database Engine and Integration Services. DB Engine/SSAS/SSRS have been installed at same time. So the instance name are same. I checked some topics on web, but no good solution works.
It's SQL SERVER 2008, not 2005, 2012, etc....
Please help to solve this problem. Thanks.
June 27, 2014 at 3:32 am
nicholas.zhao (6/27/2014)
I installed SQL Server 2008 standard edition with service pack 1 on windows server 2008 std. But when I login to the Analysis Services by studio management, following error is shown.A connection cannot be made. Ensure that the server is running (Microsoft.AnalysisServices.AdomdClient)
No Connection could be made because the target machine actively refused it 127.0.0.1:2383
But I can login to Database Engine and Integration Services. DB Engine/SSAS/SSRS have been installed at same time. So the instance name are same. I checked some topics on web, but no good solution works.
It's SQL SERVER 2008, not 2005, 2012, etc....
Please help to solve this problem. Thanks.
Is the analysis server service running? Look for "MSSQLServerOLAPService" or "MSOLAP$Instance" in services.msc (display name will be something like "SQL Server Analysis Services (MSSQLSERVER)").
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply