Error in sql server log - SQL Server Forums

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.

All Forums

General SQL Server Forums

New to SQL Server Administration

Error in sql server log

Author

Topic

Sharon911
Starting Member

46 Posts

Posted - 2010-05-28 : 10:49:19

The error In event viewer:

Source: Microsoft OLE DB Provider for SQL Server
Code: 11 occurred 1 time(s)
Description: [DBNETLIB][ConnectionOpen (PreLoginHandshake()).]General network error. Check your network documentation.

The error in sql server log:

2010-05-27 16:24:32.58 Server Using 'dbghelp.dll' version '4.0.5'
2010-05-27 16:24:32.68 Server ***Stack Dump being sent to E:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\LOG\SQLDump0001.txt
2010-05-27 16:24:32.68 Server SqlDumpExceptionHandler: Process 3684 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.
2010-05-27 16:24:32.68 Server * *******************************************************************************
2010-05-27 16:24:32.68 Server *
2010-05-27 16:24:32.68 Server * BEGIN STACK DUMP:
2010-05-27 16:24:32.68 Server * 05/27/10 16:24:32 spid 3684
2010-05-27 16:24:32.68 Server *
2010-05-27 16:24:32.68 Server *
2010-05-27 16:24:32.68 Server * Exception Address = 0000000000A4521A Module(sqlservr+000000000027521A)
2010-05-27 16:24:32.68 Server * Exception Code = c0000005 EXCEPTION_ACCESS_VIOLATION
2010-05-27 16:24:32.68 Server * Access Violation occurred writing address 00000000007D4D20
......

This is a sharepoint environment, and we are using sql 2008.
The users couldn't login the pages after the error occured until the server has been restarted.

Did anyone have the same issue before? What might be the causes?

Thanks
Sharon

Kristen
Test

22859 Posts

Posted - 2010-05-28 : 11:38:51

Contents of

E:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\LOG\SQLDump0001.txt

might tell you something - e.g. the name of the SProc that was running at the time of the problem.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-05-28 : 12:21:10

These are typically SQL Server bugs. Are you running the latest and greatest CU for SQL 2008? What does SELECT @@VERSION show?

Do you have a support contract with Microsoft? If so, you can easily get help with this. If it's found to be a bug, there is no charge.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

Kristen
Test

22859 Posts

Posted - 2010-05-29 : 12:13:01

" These are typically SQL Server bugs"

I've only seen them in code that called COM objects which were "flakey"

Sharon911
Starting Member

46 Posts

Posted - 2010-05-31 : 12:07:16

TO Kristen,
The file E:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\LOG\SQLDump0001.txt
didn't tell me much, I think it is mainly for produciton support team to do investigation.

To tkizer,
Select @@version shows:
Microsoft SQL Server 2008 (SP1) - 10.0.2531.0 (X64) Mar 29 2009 10:11:52 Copyright (c) 1988-2008 Microsoft Corporation Enterprise Edition (64-bit) on Windows NT 6.0 <X64> (Build 6002: Service Pack 2) (VM)
Is it the latest version for sql 2008?

Kristen
Test

22859 Posts

Posted - 2010-05-31 : 12:47:43

" Is it the latest version for sql 2008?"

Excluding Cumulative Updates then Yes.

See
http://www.sqlteam.com/article/sql-server-versions
and look for "10.0.2531.0"

Sharon911
Starting Member

46 Posts

Posted - 2010-05-31 : 15:16:38

Thanks!
unable to open the link

quote:
Originally posted by Kristen

" Is it the latest version for sql 2008?"

Excluding Cumulative Updates then Yes.

See
http://www.sqlteam.com/article/sql-server-versions
and look for "10.0.2531.0"

Kristen
Test

22859 Posts

Posted - 2010-05-31 : 15:37:17

"unable to open the link"

Not sure why that would be, but navigate to the Home page, scroll down and the link to "SQL Server Version" is there ...

Sharon911
Starting Member

46 Posts

Posted - 2010-05-31 : 16:06:14

Odd.. Ican open weblogs and forums but not home page.Maybe I don't have the privileges?

Kristen
Test

22859 Posts

Posted - 2010-06-01 : 03:42:12

I've asked around. If you are using internet Explorer version 6 that is most likely the problem. Should work OK with more recent IE version, or other browsers.

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=139231&whichpage=1

Sharon911
Starting Member

46 Posts

Posted - 2010-06-01 : 10:03:30

That is it! I am using IE6, will try new version later.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources