• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 320
  • Last Modified:

Help with SQL error for non dba

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
jzall
Asked:
jzall
  • 3
  • 2
1 Solution
 
arbertCommented:
I would contact microsoft PSS on this error--especially if you're using Axapta--it's a bear....
0
 
Eugene ZCommented:
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
 
arbertCommented:
I'm assuming since this is Axapta, you aren't running DTS applications right?
0
[Webinar] Improve your customer journey

A positive customer journey is important in attracting and retaining business. To improve this experience, you can use Google Maps APIs to increase checkout conversions, boost user engagement, and optimize order fulfillment. Learn how in this webinar presented by Dito.

 
jzallAuthor Commented:
correct...
0
 
arbertCommented:
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
 
jzallAuthor Commented:
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

Take Control of Web Hosting For Your Clients

As a web developer or IT admin, successfully managing multiple client accounts can be challenging. In this webinar we will look at the tools provided by Media Temple and Plesk to make managing your clients’ hosting easier.

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