October 18, 2002 at 12:45 pm
I'm having a reoccurring problem that, so far, I have been able to find little or no information on. The MSSQLSERVER service terminates unexpectedly in the middle of the night and the following messages are left in the error log:
2002-10-18 01:41:28.71 server Error: 17882, Severity: 18, State: 1
2002-10-18 01:41:28.71 server Error accepting connection request via Net-Library 'SSNETLIB'. Execution continuing..
2002-10-18 01:41:28.79 server Error: 17059, Severity: 18, State: 0
2002-10-18 01:41:28.79 server Operating system error 1: Incorrect function...
Here's the scenario, we have a SQL Server 2000 SP2 installation on a Win2k SP3 machine. We have a couple of nightly jobs that run for various administrative tasks. Most of these jobs are started after the regular backups have finished. One particular job is fairly lengthy (starts at 12:00 AM and takes about 2 hours to finish) mainly because it scrolls through a table with about 6,700 rows and processes each row. It creates a single instance of an ActiveX dll, using the sp_OACreate command, at the beginning of the job and for each row, several calls are made to the ActiveX object. At the end of the job, the object is destroyed.
The termination of the service has happened twice now with the same error messages as above and both times, the job above has been running while the service terminated. The first time this happened was at 10/07/2002 01:13 AM and it occurred again at 10/18/2002 01:41 AM. During this span, the SQL Server service was not restarted nor was the server rebooted (except to recover from the initial termination).
My first thought for this was that I am running into problems with memory but I would think that the error messages would indicate something different if that were the case. Still, it is a possiblity since I am using an ActiveX object created in SQL Server's memory space.
My first question is, has anyone ran into any similar problems or seen these errors before? Any help or suggestions would be greatly appreciated.
Second, how often should you restart the SQL Server service? I know that it depends on the activity of your databases and such but what's a good rule of thumb? This is a pretty active database and we try to do it at least once a month but maybe that is not enough. I have heard that you can use Win2k task scheduler and the "net stop mssqlserver"/"net start mssqlserver" commands to automatically stop and start the services on a regular basis.
Just curious what everyone's take on the matter is. More than likely we will probably try and restart the SQL Server service on a more regular basis (like weekly) to see if this helps alleviate the problem. Thanks for your input.
Kevin Tanferani
October 18, 2002 at 2:15 pm
Have you recently reonfigured your SQL Server with 'Force Protocol Encryption' being turned off/on? The error message seems indicate that a client try to access SQL Server with requests encryption, if SSL certificate is not installed on your SQL Server machine, or if SQL Server cannot validate the certificate, SQL Server fails to start.
Two Microsoft KB for your information.
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q318605
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q314636
October 18, 2002 at 5:09 pm
No, I do not have "Force Protocol Encryption" turned on at the server nor did I have this option on at one point. I can't say the same for any clients out there but I wouldn't think that a client with this option on would be able to bring down the service. Plus, given our environment, I can be pretty sure that no one would be trying to connect to SQL Server at that time of night, except for any processes or jobs spawned by SQL Server itself.
Edited by - ktanfera on 10/18/2002 5:09:35 PM
October 21, 2002 at 5:52 am
Due to the fact that is crashing the server, I would believe that it's your dll thats failing. You could run it under com+ which should protect the server more.
You could run profiler overnight to see what causes the fail, this would impact performance. You would need sp:stmtcompleted.
Simon Sabin
Co-author of SQL Server 2000 XML Distilled
http://www.amazon.co.uk/exec/obidos/ASIN/1904347088
Simon Sabin
SQL Server MVP
http://sqlblogcasts.com/blogs/simons
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply