?
Solved

Help with SQL error for non dba

Posted on 2004-09-09
8
Medium Priority
?
313 Views
Last Modified: 2012-06-27
Our SQL DBA is gone, and I am up the creek. Environment: SQL 2000 on WIn2K server. Database is the backend for Microsoft Navision Axapta application. We get a number of similar error messages (six in a 5 minute period) as the following, then the system hangs and requires a reboot. The error is:
Event ID 17052
Description:
Error: 0, Severity: 19, State: 0
SqlDumpExceptionHandler: Process 67 generated fatal exception c0000005 Exception_Access_Violation. SQL Server is terminating this process.
This is well out of my skill set. I am trying to find out what the error means and more importantly, how to fix it. Any help will be greatly appreciated. Thanks---Jeff
0
Comment
Question by:jzall
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
8 Comments
 
LVL 34

Expert Comment

by:arbert
ID: 12020326
I would contact microsoft PSS on this error--especially if you're using Axapta--it's a bear....
0
 
LVL 43

Expert Comment

by:Eugene Z
ID: 12020439
you can check:
1. check if sql server has latest SP3a and security patch  MS03-031 (from QA run select @@version must be >=8.00.760
http://www.microsoft.com/downloads/details.aspx?FamilyID=9814AE9D-BD44-40C5-ADD3-B8C99618E68D&displaylang=en

If not - install
Else
2. reboot the server

3. if all above does not work read below articles :
http://support.microsoft.com/?kbid=830773
http://www.sqldts.com/default.aspx?232
0
 
LVL 34

Expert Comment

by:arbert
ID: 12020469
I'm assuming since this is Axapta, you aren't running DTS applications right?
0
NFR key for Veeam Agent for Linux

Veeam is happy to provide a free NFR license for one year.  It allows for the non‑production use and valid for five workstations and two servers. Veeam Agent for Linux is a simple backup tool for your Linux installations, both on‑premises and in the public cloud.

 

Author Comment

by:jzall
ID: 12020486
correct...
0
 
LVL 34

Accepted Solution

by:
arbert earned 1500 total points
ID: 12020565
Ya, if your DBA is gone, I would contact MS.  It's their application (both Navision and SQL) and you definately don't want to mess up your financial data or void any support contracts that you might have...
0
 

Author Comment

by:jzall
ID: 12020591
it appears that we don't have the security update installed, so I am going to try that and see how it goes. If not, I will bit the bullet and call MS....Thanks
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.
Suggested Courses

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question