SSIS Analysis Services Processing Task.

Question

SSIS Analysis Services Processing Task.

brian118

Hall of Fame

Points: 3506
More actions
July 23, 2014 at 4:58 am

#397100

Hi
SSIS - 2008R2
SSAS - 2012
I have got a very weird problem. I am trying to build a package on SSIS 2008 to process a cube on SSAS 2012. I managed to do it successfully on a dev machine but it just doesn't want to work on production. Basically, if I open the connection manager for the Cube and Test the Connection, it gives me that the Test connection succeeded. However when I open the Analysis Services Processing Task, I receive a notification message -
TITLE: Analysis Services Processing Task
------------------------------
A connection cannot be made. Ensure that the server is running.
------------------------------
BUTTONS:
OK
------------------------------
which is very weird because the server IS running and this is proved by the Test connection.
Can someone shed some light on my issue?
btw, I installed MS OLE Provider for Analysis Services 11.0 on the 2008 machine....
Regards
Brian
Regards
Brian Ellul
----------------------------------------------------------------------------------
Computers are incredibly fast, accurate, and stupid. Human beings are incredibly slow, inaccurate, and brilliant. Together they are powerful beyond imagination.
- Albert Einstein -

Viewing 8 posts - 1 through 7 (of 7 total)

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

Nevyn SSChampion Points: 14210 More actions · Answer 1

I am guessing that you are using Windows Authentication? Are you logged into the production server you are trying to run the package from, or are you connecting to that server via SSMS?

brian118 Hall of Fame Points: 3506 More actions · Answer 2

Nevyn (7/24/2014)
I am guessing that you are using Windows Authentication?

Yes I am. Do please note that the 'Test Connection' of the Connection Manager is successful. The only difference from my Dev environment is that on Prod (were I'm getting the error), the Cube is on a Domain while the SSIS package is on another domain.

Regards

Brian

Regards
Brian Ellul
----------------------------------------------------------------------------------
Computers are incredibly fast, accurate, and stupid. Human beings are incredibly slow, inaccurate, and brilliant. Together they are powerful beyond imagination.
- Albert Einstein -

brian118 Hall of Fame Points: 3506 More actions · Answer 3

Nevyn (7/24/2014)
I am guessing that you are using Windows Authentication? Are you logged into the production server you are trying to run the package from, or are you connecting to that server via SSMS?

Yes I'm logged on to the server that I'm running the package from. In fact it's open in front of me in BIDS. As I mentioned in an earlier thread, the cube is on another domain however.

Regards
Brian Ellul
----------------------------------------------------------------------------------
Computers are incredibly fast, accurate, and stupid. Human beings are incredibly slow, inaccurate, and brilliant. Together they are powerful beyond imagination.
- Albert Einstein -

Nevyn SSChampion Points: 14210 More actions · Answer 4

Hmm, a bit different than the situation I encountered then.

Does it work if you specify username (including domain) and password in the connection?

brian118 Hall of Fame Points: 3506 More actions · Answer 5

Nevyn (7/24/2014)
Hmm, a bit different than the situation I encountered then.
Does it work if you specify username (including domain) and password in the connection?

Yes I can connect successfully when I open the connection manager and 'test the connection'. It's only when I open an Analysis Processing task that I receive the message 'A connection cannot be made. Ensure that the server is running.' when I have just confirmed that the connection is OK!

Regards
Brian Ellul
----------------------------------------------------------------------------------
Computers are incredibly fast, accurate, and stupid. Human beings are incredibly slow, inaccurate, and brilliant. Together they are powerful beyond imagination.
- Albert Einstein -

Nevyn SSChampion Points: 14210 More actions · Answer 6

Right, but does it still do that when you pass in the credentials instead of using integrated security?

brian118 Hall of Fame Points: 3506 More actions · Answer 7

Nevyn (7/25/2014)
Right, but does it still do that when you pass in the credentials instead of using integrated security?

Hi

In the Connection manager of SSIS, I have the option to Use 'Windows NT Integrated Security' or 'Use a specific user name and password'. I have tried both options and I'll connect successfully. Still when I open an Analysis Processing Task, I get the same Information message 'A connection cannot be made. Ensure that the server is running'.

Regards
Brian Ellul
----------------------------------------------------------------------------------
Computers are incredibly fast, accurate, and stupid. Human beings are incredibly slow, inaccurate, and brilliant. Together they are powerful beyond imagination.
- Albert Einstein -