Query crash after using any dblink

Hi experts,
this simple query, used to work in the past:
SELECT COUNT(*) from dblink.database.dbo.vwName

now it crashes returning:
Error: 0, Severity: 19, State: 0
SqlDumpExceptionHandler: Process 63 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.

Followed by (from event viewer):
Error: 0, Severity: 19, State: 0
language_exec: Process 63 generated an access violation. SQL Server is terminating this process.

Note that if I run the same query on the target database it will run successfully. And this happens for all dblinks in this server, they are not accessible. I cannot drop and re-create any of them. The error is the same. Any idea?
errorsql.JPG
Claudia CarlottiIT DirectorAsked:
Who is Participating?
 
Claudia CarlottiIT DirectorAuthor Commented:
I founded the problem, was a corrupted DLL. I had to copy a new one from another server (same configuration) and register it. And it worked. The SP didn't help. Thanks anyway.
0
 
RiteshShahCommented:
can you see event log? is there same error reported?
have you changed anything in login permission recently which might creating problem?

this could be raised because of network issue as well.
can you check whether your box with dblink is accessible from your sql box and vice versa?
0
 
Claudia CarlottiIT DirectorAuthor Commented:
Yes the event log show the same error.
We just installed outlook client on  the server,  no other changes have been made.
No, the dblink is not accessible for the sql box area, cannot be created again.
Both the two server are on virtual server, same node, we have others same situation but never had problem with dblinks.
Thanks.
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
RiteshShahCommented:
All I can guess right now is, your virtual server are not accessible from each other, have you tried pinging it from one server to another?
0
 
Claudia CarlottiIT DirectorAuthor Commented:
Yes I can ping from the other machine. I read on internet to upgrade to the latest service pack (right now we just have sql server 2000 without s.p.). I don't have any other idea. Thanks.
0
 
RiteshShahCommented:
yes, latest SP 4 can also help you out. but don't forget to have your full backup before start applying the patch, in case something goes wrong.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.