Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
scottmcx
Starting Member
5 Posts |
 Posted - 2006-05-23 : 22:25:20
|
| We have an old NT 4.0 SQL 6.5 box that has recently begun stopping the SQL server service about every 4 hours. This is some legacy equipment in a very small ISP. Uses radiusNT and an accounting package called Platypus (now owned by Tucows). I just got "appointed" to take care of it. I know nothing about SQL other than how to spell it. HELP! |
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2006-05-23 : 22:41:40
|
| Try looking in the System and Application Event logs to see if there are any messages that indicate what might be causing this.It you still need to use that software, now might be a good time to contact the vendor to see if they offer some kind of upgrade to a later version of SQL Server.CODO ERGO SUM |
 |
|
|
mr_mist
Grunnio
1870 Posts |
Posted - 2006-05-24 : 03:57:06
|
| If I were you I would mention that 6.5 has been out of extended microsoft support for a good few years now, and the knowledge base available to support it as a product will only continue to decrease as time goes on. Maybe it's running out of memory? Maybe it's overheating?-------Moo. :) |
|
|
|
scottmcx
Starting Member
5 Posts |
Posted - 2006-05-28 : 22:42:03
|
| I've ghosted the hard drives from very old and hot SCSIs to some newer IDEs now it only shuts down about every 26 hours an increase of 22 hours uptime. Keep in mind it is only the SQL Server service that stops the PC runs fine. I've just changed out the power supply, reseated the processor, ram, video and enet card to see if that helps. Any Ideas why just the SQL service would simply stop...HELP! |
|
|
|
cmdr_skywalker
Posting Yak Master
159 Posts |
Posted - 2006-05-29 : 00:25:46
|
| what's the message from the logs?May the Almighty God bless us all! |
|
|
|
scottmcx
Starting Member
5 Posts |
Posted - 2006-05-29 : 07:25:16
|
The NT log show no events. Is there a SQL event log (excuse me for not knowing). and where is it?quote:
Originally posted by cmdr_skywalker
what's the message from the logs?May the Almighty God bless us all!
|
|
|
|
scottmcx
Starting Member
5 Posts |
Posted - 2006-06-08 : 22:36:35
|
| SQl's error log shows a number of, ods error : 17832, severity: 18, state: 0 unable to read login packetsspid17 exception_access_violation attempting to create system dumpThen it dumps and I have to restart SQLAnyone have a solution? This happens about once every 48 hours now. |
|
|
|
|
|
|
SQL 6.5 Help!