1

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.

2

Re: Created in SQL Server Agent it is not connected to SSAS

dmitriy_po;
Under whom the agent works?

3

Re: Created in SQL Server Agent it is not connected to SSAS

StarikNavy;
Under me also works.
For SSAS and Database Engine it is included Windows authentification, in addition for them I registered the login and the password under Windows in SQL Server Configuration Manager (in properties of services). For Service Agent made the same.
The additional information.  for Database Engine (creation and basis removal) works , but for SSAS - is not present (XMLA script).

4

Re: Created in SQL Server Agent it is not connected to SSAS

The problem is solved!
That  it was connected to SSAS it is necessary to register correctly reversal to SSAS , namely:
< machines> \<name SSAS >