Unanswered: Invalid Instance error in scheduled jobs
I just installed a named SQL Server 2000 instance with SP3a. All services seem to be running and I am able to connect to the instance using Query Analyzer. However, all of the database maintenance plan jobs fails reporting the following error:
Microsoft (R) SQLMaint Utility (Unicode), Version [Microsoft SQL-DMO (ODBC SQLState: 08001)] Error 0: [Microsoft][ODBC SQL Server Driver][Shared Memory]Invalid connection. [Microsoft][ODBC SQL Server Driver][Shared Memory]ConnectionOpen (Invalid Instance())
I did not use any fancy options during installations. The only option I did not take default was TCP/IP port.