Claudia Carlotti
asked on
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
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
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
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
ASKER
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.
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.
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?
ASKER
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.
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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?