process cube thorugh job service account issue

  • Hi All

    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:

    Message

    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?

  • sorry if you've already thought of this but i thought i'd ask the obvious first:

    Has the service account got the rights to process the cube?

    Try connecting directly to the SSAS instance using the service account via management studio and manually processing the cube under that user.

    other than that i cant see why it wouldn't process your cube.

  • Service account has full privileges and i can process my cube through management studio by using the same account.

    I am getting the error when i execute the job (try with both xmla and SSIS) to process the cube.

    Also use through proxy but no luck.

    Can you suggest any other automated way by which i can process cube?

  • Thought it would of been too obvious (always worth asking the simple questions first though) and sounds like you've tried all variations too.

    There always powershell 🙂

    here's a link which could help with that:

    http://www.mssqltips.com/sqlservertip/2937/using-powershell-for-sql-server-analysis-services-tasks--part-1/

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply