Did you try ODBCPING.EXE to verify all of the connection parameters?
Maybe this sounds simplistic, but I always utilize this as a first step
in troubleshooting these types of errors.
--
Marc Handelman



> -------- Original Message --------
> Subject: RE: Database job - System databases fail
> From: "Ben Helfer "
> <mssqldba-ezmlmshield-x83952711.[Email address protected]
> Date: Mon, January 30, 2006 10:43 am
> To: "LazyDBA Discussion" <[Email address protected]
>
> I tried this and it didn't work, thanks for the suggestion. Still looking for a solution.
>
> Davis Ralph <Ralph.[Email address protected] wrote: **A LazyDBA.com subscriber has responded to your lazydba.com post**
> **LazyDBA.com mail shield has forwarded you this email,
> **and removed any attachments, and kept your email address secret
> **from this person, and any viruses/trojans.
> **If you reply to this email, the person will see your email address as normal
> **Anything below this line is the original email text
>
>
> I would try opening your client network utility and unclick the "enable
> shared memory protocol" in the lower left corner. Then save and retry
> your maintenance plan.
>
> Thanks,
> Ralph W. Davis
>
> *********************************************************
> *** CORPORATE DBA group - Houston ***
> *********************************************************
> -----Original Message-----
> From: Ben Helfer
> [Email address protected]
> Sent: Monday, January 23, 2006 6:25 PM
> To: LazyDBA Discussion
> Subject: Database job - System databases fail
>
> I've created two database maintenance plans. One for user databases and
> one for system databases. The backup job for the users databases runs
> flawlessly. The backup job for the system databases generates the
> following error listed below. Any suggestions?
>
> 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()).
>
>
>
> ---------------------------------------------------------------------
> TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
> Website : http://www.LazyDBA.com
> To unsubscribe: http://www.lazydba.com/unsubscribe.html
>
> Confidentiality Note: The information contained in this message, and any
> attachments, may contain confidential and/or privileged material. It is intended
> solely for the person or entity to which it is addressed. Any review,
> retransmission, dissemination, or taking of any action in reliance upon this
> information by persons or entities other than the intended recipient is
> prohibited. If you received this in error, please contact the sender and delete
> the material from any computer.
>
>
>
>
>
>
>
> ---------------------------------------------------------------------
> TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
> Website : http://www.LazyDBA.com
> To unsubscribe: http://www.lazydba.com/unsubscribe.html


MS Sql Server LazyDBA home page