Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 580
  • Last Modified:

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
0
Claudia Carlotti
Asked:
Claudia Carlotti
  • 3
  • 3
1 Solution
 
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
 
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
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
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
 
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

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now