Results 1 to 8 of 8
  1. #1
    Join Date
    Feb 2007
    Posts
    71

    Unanswered: Connection failed:

    Hi Guys,

    I encountered an error while opening my third SQL Connection in Enterprise Manager

    ---------------------------
    Microsoft SQL Server Login
    ---------------------------
    Connection failed:
    SQLState: '01000'
    SQL Server Error: 232
    [Microsoft][ODBC SQL Server Driver][Shared Memory]ConnectionWrite (WrapperWrite()).
    Connection failed:
    SQLState: '08S01'
    SQL Server Error: 11
    [Microsoft][ODBC SQL Server Driver][Shared Memory]General network error. Check your network documentation.

    ---------------------------
    OK
    ---------------------------

    I am using the following
    SQL Server 2000 Enterprise Edition (SP4)
    Windows 2000 Professional (SP4)

    first two connections are with Query Analyzer, the third attempt is when opening a table inside Enterprise Manager

    anyone experienced this?

  2. #2
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,799
    Provided Answers: 11
    Sounds like you have to enable the shared memory protocol for the instance in cliconfg.exe.

  3. #3
    Join Date
    Feb 2007
    Posts
    71
    hi MCrowley

    yeah, but the problem is, I can't remember what I did (gosh, too much for making experiments )

    Is there a way on how to reverse this effect?

    Thanks

  4. #4
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,799
    Provided Answers: 11
    Is the Shared Memory protocol enabled in Cliconfg.exe?

  5. #5
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    Is the Shared Memory protocol enabled in Cliconfg.exe?
    George
    Home | Blog

  6. #6
    Join Date
    Feb 2004
    Location
    Burbank & Santa Cruz de la Sierra
    Posts
    3,716
    The first thing I would do if I were in your position would be to check the setting of Shared Memory Protocol in cliconfg.exe and make sure it is enabled.

    Just my .02
    aka "Paul"
    Non est ei similis.

    I just read "100 Things To Do Before You Die". I was surprised that "Yell for help!!" wasn't one of them

  7. #7
    Join Date
    Feb 2007
    Posts
    71
    gosh,

    sorry for the very late reply


    yes, its enabled, what does this option do by the way?

    thanks

  8. #8
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,799
    Provided Answers: 11
    Shared memory is a protocol that can be used by applications running on the same box as SQL Server. Now that it is enabled, do you still get the same error?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •