Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

process cube thorugh job service account issue Expand / Collapse
Author
Message
Posted Thursday, June 20, 2013 3:53 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Wednesday, July 16, 2014 4:01 AM
Points: 93, Visits: 93
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?
Post #1465556
Posted Thursday, June 20, 2013 7:04 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Wednesday, May 14, 2014 2:53 AM
Points: 1,726, Visits: 490
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.

Post #1465669
Posted Thursday, June 20, 2013 7:27 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Wednesday, July 16, 2014 4:01 AM
Points: 93, Visits: 93
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?
Post #1465690
Posted Thursday, June 20, 2013 7:45 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Wednesday, May 14, 2014 2:53 AM
Points: 1,726, Visits: 490
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/
Post #1465706
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse