I have the following equipment:
Windows 2000 Server
768MB of RAM
Intel 2.6 Celeron Processor
I am running SQL Server Exrpress 2005 on this server and running a VB.NET program create with Visual Studio 2005.
Using the program I am updating the SQL Server Express 2005 database with records from XML files.
While scanning through the XML files (opening/closing them as necessary) I receive the following error message after several cycles. This is random. It doesn't happen after a certain number of records or files that are opened as far as I can tell.
Error from SELECT * FROM Dummy
Index #0
Error.System.Data.SQLClient.SQLError: A connection was successfully established with the server, but then an error occurred during the pre-login handshake. (provider: SSL Provider, error: 0 - SSL Provider: ) (5)
Things that I have tried are as follows:
Uninstalling and reinstalling SQL Server Express 2005 on the server.
Under Server Properties - Memory - setting the Maximum server memory (in MB): to 750MB (which is lower than the amount of memory in the server).
In the connection string and under Server Properties - Connections - setting the Remote query timeout to 7200 (secs).
Any suggestions would be greatly appreciated. I have no idea how else to solve this issue. It is a consistent error in regards to happening every time I try to scan through all of the XML files but it doesn't happen on every XML file.
Thanks in advance for any help.
Do you have additional information about error number or / and states ?
BTW: DId you see the information from that blog: ?
http://blogs.msdn.com/sql_protocols/archive/2005/12/22/506607.aspx
Jens K. Suessmeyer
http://www.sqlserver2005.de
No comments:
Post a Comment