Post reply

General network error wit job

  • June 7, 2004 at 3:37 am

    #152176

    Hi,

    we are using job for reindex our tables. Sometimes job goes right sometimes it fails with error:

    ConnectionRead (WrapperRead()). [SQLSTATE 01000] (Message 258)  General network error. Check your network documentation. [SQLSTATE 08S01] (Error 11).  The step failed.

    We are using dbcc dbreindex in the job. I didn't find relevant info on microsoft.com site.

    We are using SQL2000 SP3a, Win 2003, cluster.

    Can anyone help me how to resolve this problem?

    Thank you.

     

    Kindest Regards,

    vbenus

  • June 10, 2004 at 8:00 am

    This was removed by the editor as SPAM

  • June 10, 2004 at 8:25 am

    #509882

    Is the job running locally or from a remote server

  • June 10, 2004 at 10:01 am

    #509906

    Job is running locally.

    Kindest Regards,

    vbenus

  • June 11, 2004 at 12:06 am

    #509994

    vbenus,

    Local on the box? sounds vaguely familiar. On the server, open up Client Network Utility (from the MS SQL Server grouping on Menu).

    Look and see whether the "Enable Shared Memory Protocol" is ticked or not.

    I suspect you will find that this is NOT ticked. As I recall, this setting allows jobs running locally to avoid using network libraries (it is enabled by default) - but if it is disabled, you may see what you are seeing.

     

    HTH

     

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply