I am having trouble getting my SQL Agent job to process a cube on SQL Svr 2008.
I can run the SQL Server Analysis Services Command as myself, but has errors when run as SQL Agent.
The SQL Agent log message is as follows:
Executed as user: Domainname\UserName. 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:2382 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.GetTcpClient(ConnectionInfo connectionInfo) at Microsoft.AnalysisServices.Xmla.XmlaClient.OpenTcpConnection(ConnectionInfo connectionInfo) 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). The step failed.
SQL Agent and Analysis Services are running on the same box. I have tried to allow port 2383, and have tried turning the firewall off to see if this is the issue.
(I also have issues when I try to run a SSIS package which processes the cubes.)
Same is running perfectly on my local environment, so i think that it is related to service accounts.
Any ideas on solutions?