I have found workaround:
- Create a package which process the cube on remote host.
- Create agent job which calls that package.
- Create the package which calls that job.
Of course, it would be interesting to find the way to process the cube directly.
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Hello
I am using Analysis Services Processing Task to process cube and use the following connection string:
Data Source=<SSAS instance>;User ID=<User ID>;Password=<Password>;Initial Catalog=BTR;Provider=MSOLAP.5;Persist Security Info=True;
It works fine if cube and SSIS sit on the same host, but if cube deployed on the remote host I have got an error message : "A connection cannot be made .Ensure that the server is running."
The server is running, I am certain.The user who run the package has administrative priveliges on remote host and Admin rights in the cube. What might be the problem ? Please, help
I have found workaround:
Hi @Roman Primolennyy ,
Best Regards,
Mona
----------
If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Hot issues in November--What can I do if my transaction log is full?
Hot issues in November--How to convert Profiler trace into a SQL Server table?
Hi,
Looks like you have connectivity issues in your remote server. We could try to troubleshot this from two aspects.
-ping *SSASServerName*
see if two machine is connected. -TELNET SQLASCLUS 2383
two check the port. (Normally this is the default port. )For detail description of the troubleshooting follow this : Troubleshooting Common SQL Server Analysis Services Connectivity Issues
Regards,
Lukas
If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
What can I do if my transaction log is full?--- Hot issues November
How to convert Profiler trace into a SQL Server table -- Hot issues November