Unanswered: manteniance plan not working, sqlmaint failing
Hi, none of the jobs of the manteniance plans are running , i tried to research but the errors are to general, the errors i m getting are:
Job 'Transaction Log Backup Job for DB Maintenance Plan 'DB Maintenance Plan1'' : Step 1, 'Step 1' : Began Executing 2005-02-16 13:24:41
Microsoft (R) SQLMaint Utility (Unicode), Version 8.00.760 Copyright (C) Microsoft Corporation, 1995 - 1998
[Microsoft SQL-DMO (ODBC SQLState: 08001)] Error 0: [Microsoft][ODBC SQL Server Driver][Shared Memory]SQL Server does not exist or access denied.
[Microsoft][ODBC SQL Server Driver][Shared Memory]ConnectionOpen (Connect()).
Msg 22029, Sev 16: sqlmaint.exe failed. [SQLSTATE 42000]
sqlagent is fine, its a localjob,and i cant figure it out trought microsoft KNB
so any ideas will help. thanks a lot in advance.