Post reply

linked server problem

  • February 6, 2007 at 2:01 am

    #117474

    Hi everyone,

    I've got problem querying remote tables via a specific linked server.

    The server from which I execute the query is an SQLServer2005 and the linked server is an SQLServer2000.

    If I do select * from <linked server>.<database name>.<db owner>.<Table1>  after a while I get the following error message

    "Server: Msg 10054, Level 16, State 1, Line 0, TCP Provider: An existing connection was forcibly closed by the remote host."

    I execute the query using profiler and I got the following profiler error: 'OLE DB provider "Unknown" for linked server "(null)" supported the schema lock interface, but returned "0x80040e96" for "ReleaseSchemaLock".' (The query returns a subset of records before it is forcibly stopped)

    The strange thing is that i used to run the same query a week or two ago and faced no problem.

    Please help.

  • February 6, 2007 at 2:20 am

    #687939

    I've seen that problem when kerberos authentification could not be initialized when the server starts up. Check you're 2005 SQL log for any error during start up.

    Most of the time a restart of the server solves the problem.

    Markus

    [font="Verdana"]Markus Bohse[/font]

  • February 6, 2007 at 2:44 am

    #687949

    Markus thnx for the quick reply! I have enriched my post with extra details please check! I have also checked the Kerberos Key Distribution Service and it is disabled but my query still crashes after a while and not from the beginning.

Viewing 3 posts - 1 through 2 (of 2 total)

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