SQL backup problem with sqlmaint

• DKG-967908

  SSCrazy

  Points: 2345

  More actions

  December 15, 2008 at 10:21 pm

  #125764

  Hi All,

  I am trying to schelule my sql server 2005's (SP2) database with xp_sqlmaint utility. Although its working fine on other servers.

  On one server, it is failing with below message::

  output

  ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

  NULL

  Microsoft (R) SQLMaint Utility (Unicode), Version 9.00.3042.00

  Copyright (c) Microsoft Corporation.

  NULL

  [Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 55555: [Microsoft][ODBC SQL Server Driver][SQL Server]To connect to this server you must use SQL Server Management Studio or SQL Server Management Objects (SMO).

  NULL

  Msg 22029, Level 16, State 1, Line 0

  sqlmaint.exe failed.

  I have also applied "SQLServer2005_XMO.msi" for the SMO error but no luck.

  If someone could please help in this regard.

  Thanks,