May 27, 2013 at 5:06 am
I have created one ssis on 2012 .
in this packse i have added one cube processing task after that i had run that time it was working fine.
after that i have scheduled that job on sql agent that time it was failed.
Error:a connection cannot be made ensure that the server is running
who to reslove these issue.
July 26, 2013 at 4:08 pm
Make sure , Sql Server Sql agent service is running
July 29, 2013 at 5:23 pm
... by making sure the connection can be established perhaps?
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.August 26, 2013 at 9:07 pm
thanks for gave replay.
actualy cube was deployed s1 server.
i have sehedule job s2 server.
in server s2 the sql server agent was working.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply