Topic: Created in SQL Server Agent it is not connected to SSAS
Greetings to all!
Created simple test SQL Server Agent on removal of basis the data from SSAS. But does not work. I result more low an error:
136] Job Test reported: Microsoft.AnalysisServices.Xmla.ConnectionException: A connection cannot be made. Ensure that the server is running.--> System. Net. Sockets. SocketException: No connection could be made because the target machine actively refused it 127.0.0.1:2383 at System. Net. Sockets. TcpClient. ctor (String hostname, Int32 port) at Microsoft.AnalysisServices.Xmla.XmlaClient.GetTcpClient (ConnectionInfo connectionInfo) - - End of inner exception stack trace - - at Microsoft.AnalysisServices.Xmla.XmlaClient.OpenConnection (ConnectionInfo connectionInfo, Boolean& isSessionTokenNeeded) at Microsoft.AnalysisServices.Xmla.XmlaClient.Connect (ConnectionInfo connectionInfo, Boolean beginSession) at Microsoft.SqlServer.Management.Smo.Olap.SoapClient.Connect () at OlapEvent (SCH_STEP* pStep, SUBSYSTEM* pSubSystem, SUBSYSTEMPARAMS* pSubSystemParams, Boolean fQueryFlag)
Database engine and SSAS are installed at me by the local machine. I am the manager both .
Help to understand, please, why SQL Server Agent cannot will be connected to SSAS.
I thank for the answer.