October 10, 2008 at 4:14 am
I have a step in a Maint Plan that executes some TSQL that in turn sends me an Email.This works fine on all other steps / servers but this particular one, which simply backs up System and User databases.
The error I am getting is:
Email Success (ServerName)
Execute TSQL on
Execution time out: 0
Task start: 2008-10-09T16:31:21.
Task end: 2008-10-09T16:31:21.
Failed:(-1073573417) No connection manager is specified.
As far as I can tell there is a connection specified and have now run out of places to look.
Any ideas?
Regards
Steve
May 5, 2011 at 8:57 am
I am sure by this time it must be resolved but I have the same error and I figured out that in that particular task it asks for connection manager, so u need to specify the proper server name there. Or else just click on that task and hit F4 (properties), this way u can check properties of this particular task and then check for connection there. In my case there was no connection specified somehow, even though we have specified local connection manager. Please check that. I hope that helps.
May 6, 2011 at 2:41 am
Thanks for the response. The issue turned out to be due to the Local Connection setting. Even though it said Local Connection, the original server name was still buried in there. When it ran it was looking for a local server name that didn't exist.
What I had to do was import the package into BIDS and change the Local Connection string to the new server name. Then I imported the package into the new server and it worked.
I just assumed the Local Server connection meant just that no matter where you had sourced the package from - a bit of a gotcha really.
Regards
Steve
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply