February 15, 2010 at 1:16 pm
Team,
My Maintenance plan had failed stating the error as follows,remote connections are enabled but same error
The Execute method on the task returned error code 0x80131904
(A network-related or instance-specific error occurred while establishing a connection to SQL Server.
The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server
is configured to allow remote connections. (provider: TCP Provider, error: 0 - No connection could be made
because the target machine actively refused it.)). The Execute method must succeed, and indicate the result
using an "out" parameter. End Error Warning: 2010-02-15 10:41:09.83 Code: 0x80019002
Source: OnPostExecute Description: SSIS Warning Code DTS_W_MAXIMUMERRORCOUNTREACHED.
The Execution method succeeded, but the number of errors raised (2) reached ... The package execution fa...
The step failed.
February 15, 2010 at 2:57 pm
Has it worked in the past?
Has anything changed?
Can you setup logging on the package and show us the error as it shows in the package log? (Not from SQL Agent)
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
February 15, 2010 at 4:27 pm
Some times maintenance jobs fails due to packet loss in network, if network connectivity blip this may happen once in a while. Did this fail again, when you restart the job?
EnjoY!
February 15, 2010 at 4:30 pm
What is the maintenance plan trying to do?
Gethyn Elliswww.gethynellis.com
February 15, 2010 at 8:58 pm
Correct.. I agree that it might be a network issues if that doesnot happened in the past.
If the same persisits:
1. Open the maintenance plan,
2. Re check the configure with credentials with which the plan executes,
3. Check the previous logs for the same,
4. Check the Job history as well, you can find the error log
Based on the above try to check the process once again.
Hope this adds...
-Win..
Cheers,
- Win.
" Have a great day "
February 16, 2010 at 11:23 am
this was a cluster server,when i execute the maintenanceplan ,i cant see the error log details on the history of maintenanceplan it displays nothing,neither in the error log,and in the logging of the maintenance plan.But only the error information is available from job history.
February 16, 2010 at 11:27 am
Alter the job to write the error to a file and see if it gives you any more details. You can also check the windows event log to see if there was anything else that cropped us that might tell you some things.
Fraggle
February 16, 2010 at 11:36 am
Please enable logging from within the maintenance plan. It will give more detail about the cause of the failure than the SQL Agent log.
Here is a link that shows how to enable logging.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply