Excel File Locked

I'm building a package that has a Data Flow which reads an Excel File using the Excel Source connection - during development I hit errors in steps after the excel read. This is causing the excel file to be locked up and the next run fails on excel connection problem. If I go to Excel I can't open the file either. I have to exit BIDS and then file gets released. Is there any setting / different approach that would prevent this from happening?

thx

I doubt there is a setting - its just unfortunate I guess.

This probably won't happen if you run the package from the command line - so try that!

-Jamie

Excel Destination errors for fields > 255 chars

Hi:

Am trying to write sql2005 data to Excel. I have problems when data length exceeds 255 chars. I used a sample destination file with cells containing >255 chars where required, so that the Excel Destination external column was recognized as DT_Text.

My oledb source columns(external and output) are both varchar (1000).

Works fine , but fails when values>255 chars.

Error 0xC0202009 on ProcessInput.

I use SQL2005 enterprise SP2.

I tried changing the Oledb source output to Textstream, but that does not work at all.

How do I export values >255 chars to excel?

TIA

Kar

Hello,

could you try using Import/Export wizard and saving the package it produces? It will likely use DT_STR on the source, DT_TEXT on the destination and insert a data conversion (DT_STR->DT_TEXT).

HTH.|||

Hi:

Using Varchar(Max) in the SQL table works both ways(excel source and excel destination) without any need to convert. I used the Import wizard as suggested, and alllowed it to create a new SQL table. Thanks for the tip.

Kar

|||

Hmmm, I rejoiced too soon.

Using varchaar(max) in SQL Destination works in the normal case, when the column contains >255 chars in the reference rows (as set by the GuessTypeRows registry value).

However, if the column contains <255 rows, then I get error 0xC0208265 - Failed to retrieve long data for Column.

My problem is that I have multiple xls files from which I import data to SQL. Now most files would have a given column with data >255 chars, but maybe one of the files has that column with all values <255 chars.

I thought I would just convert everything to text, and then use a Text File Source. Problem is that "Excel Automation - Save as text" gives me a series of hashes for cells with >255 chars.

So now I am stuck, and the only inelegant solution is to add a dummy first row to each excel and set guessTypeRows to 1 and force excel to get at least one cell>255 chars for all files..

UGH.

How do I make sure the package works for all cases? Somebody please help me!

TIA
Kar

|||

Well, you can either go with your solution or try to build two packages if you know which Excel files will have <255 char columns.

Thanks.

Excel Destination errors for fields > 255 chars

Hi:

Am trying to write sql2005 data to Excel. I have problems when data length exceeds 255 chars. I used a sample destination file with cells containing >255 chars where required, so that the Excel Destination external column was recognized as DT_Text.

My oledb source columns(external and output) are both varchar (1000).

Works fine , but fails when values>255 chars.

Error 0xC0202009 on ProcessInput.

I use SQL2005 enterprise SP2.

I tried changing the Oledb source output to Textstream, but that does not work at all.

How do I export values >255 chars to excel?

TIA

Kar

Hello,

could you try using Import/Export wizard and saving the package it produces? It will likely use DT_STR on the source, DT_TEXT on the destination and insert a data conversion (DT_STR->DT_TEXT).

HTH.|||

Hi:

Using Varchar(Max) in the SQL table works both ways(excel source and excel destination) without any need to convert. I used the Import wizard as suggested, and alllowed it to create a new SQL table. Thanks for the tip.

Kar

|||

Hmmm, I rejoiced too soon.

Using varchaar(max) in SQL Destination works in the normal case, when the column contains >255 chars in the reference rows (as set by the GuessTypeRows registry value).

However, if the column contains <255 rows, then I get error 0xC0208265 - Failed to retrieve long data for Column.

My problem is that I have multiple xls files from which I import data to SQL. Now most files would have a given column with data >255 chars, but maybe one of the files has that column with all values <255 chars.

I thought I would just convert everything to text, and then use a Text File Source. Problem is that "Excel Automation - Save as text" gives me a series of hashes for cells with >255 chars.

So now I am stuck, and the only inelegant solution is to add a dummy first row to each excel and set guessTypeRows to 1 and force excel to get at least one cell>255 chars for all files..

UGH.

How do I make sure the package works for all cases? Somebody please help me!

TIA
Kar

|||

Well, you can either go with your solution or try to build two packages if you know which Excel files will have <255 char columns.

Thanks.

ex.Message in debug mode is much shorter

Exception ex.Message I am getting in debug mode calling AcquireConnection is much shorter than the logged message in run time because all the errors come to output window in debug. Is there any way to get all these errors description from exception object in debug time to be able to parse it?

Thanks.

What you are saying does not make sense. The exception details will always bee the same debug or otherwise. The exception will only have one message, but you suggest there should be more. You could check the InnerException property of the caught exception, that may give something. I really do not understand how you are describing the two modes, with all errors or otherwise.

Is this perhaps to do with a UI? If so try the IErrorCollectionService interface. This allows you to get details of the fire error, warning methods called from the IDTSComponentMetaData90.

|||

Thanks for your reply and sorry for not making this question clear.
Will try to explain what actually I am actually looking for.

Below the simplified piece of my code in script task
Try
connection = connMgr.AcquireConnection(Nothing)
Catch ex As Exception
'Dts.Events.FireError(1, ex.TargetSite.ToString, ex.Message, "", 0)
MsgBox(ex.Message)
Dts.TaskResult = Dts.Results.Failure
End Try

Deliberately providing wrong psw for the connection and running the package in debug (F5)
In the msgbox reading the message "Exception from HRESULT: 0xC0202009".

Running the same package in "Start Without Debugging" (ctrl+F5), getting the more informative msgbox:

Error: 0xC0202009 at EnvConfig, Connection manager "DB_SOURCE": An OLE DB error has occurred. Error code: 0x80040E4D.
An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80040E4D Description: "Communication link failure".
An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80040E4D Description: "TCP Provider: An existing connection was forcibly closed by the remote host.
".
An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80040E4D Description: "Login failed for user 'DTSUSE'.".

The message looks like as a collection that what I am actually looking for to get access to. I need to extract only latest description like "Login failed for user 'DTSUSE'" and log it.

Thanks, Vadim.

|||

Ok, now I see. This is not a SSIS issue, rather a .Net programming issue, in so much as it is actually bad practice to just catch the general Exception type. It is also very common, we all do it! Really you should catch targeted exceptions as they are richer classes that have more information relevant to the exception thrown.

If you catch the SqlException type you can get access to the Errors collection, that is a property on the SqlException class. That will give you that extra level of detail, both for the messages and things like the source.

Events 311, 312, 318.

Each time I clear the event log on two of our SQL servers, I get the
following errors a few seconds later (see below). Config is as follows:
Win2k3, IIS, SQL2000SP4, NOT Active Directory (these are primarily web
servers).
Any help in clearing up these annoying error messages would be appreciated.
Event Type:Warning
Event Source:SQLSERVERAGENT
Event Category:Alert Engine
Event ID:312
Date:27.10.2005
Time:08:53:31
User:N/A
Computer:DNS3
Description:
Successfully re-opened the local eventlog - NOTE: Some events may have been
missed.
Event Type:Information
Event Source:SQLSERVERAGENT
Event Category:Alert Engine
Event ID:311
Date:27.10.2005
Time:08:53:31
User:N/A
Computer:DNS3
Description:
Attempting to to re-open the local eventlog...
Event Type:Error
Event Source:SQLSERVERAGENT
Event Category:Alert Engine
Event ID:318
Date:27.10.2005
Time:08:53:31
User:N/A
Computer:DNS3
Description:
Unable to read local eventlog (reason: The event log file has changed
between read operations).
It's chicken and egg. The reason you get the messages is because you cleared
the event log. SQLAgent monitors the event log for alerting purposes and
when you clear it, it has to try and re-establish its monitoring. However,
if you don't use SQL Agent alerts you can delete the demo alerts that are
created when you install SQL Server (they all start with Demo) and you will
no longer get these messages (because with no alerts defined there is no
reason for SQL Agent to monitor the event log)
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"The Vogon" <The Vogon@.discussions.microsoft.com> wrote in message
news:14E7C465-925F-4B88-9222-7CA5DED549DD@.microsoft.com...
> Each time I clear the event log on two of our SQL servers, I get the
> following errors a few seconds later (see below). Config is as follows:
> Win2k3, IIS, SQL2000SP4, NOT Active Directory (these are primarily web
> servers).
> Any help in clearing up these annoying error messages would be
> appreciated.
> ----
> Event Type: Warning
> Event Source: SQLSERVERAGENT
> Event Category: Alert Engine
> Event ID: 312
> Date: 27.10.2005
> Time: 08:53:31
> User: N/A
> Computer: DNS3
> Description:
> Successfully re-opened the local eventlog - NOTE: Some events may have
> been
> missed.
> ----
> Event Type: Information
> Event Source: SQLSERVERAGENT
> Event Category: Alert Engine
> Event ID: 311
> Date: 27.10.2005
> Time: 08:53:31
> User: N/A
> Computer: DNS3
> Description:
> Attempting to to re-open the local eventlog...
> ----
> Event Type: Error
> Event Source: SQLSERVERAGENT
> Event Category: Alert Engine
> Event ID: 318
> Date: 27.10.2005
> Time: 08:53:31
> User: N/A
> Computer: DNS3
> Description:
> Unable to read local eventlog (reason: The event log file has changed
> between read operations).
> ----
>
|||Thankyou Jasper!
I have no need for SQL Agent Alerts, so the demo alerts have been deleted
and the problem is now resolved...
"Jasper Smith" wrote:

> It's chicken and egg. The reason you get the messages is because you cleared
> the event log. SQLAgent monitors the event log for alerting purposes and
> when you clear it, it has to try and re-establish its monitoring. However,
> if you don't use SQL Agent alerts you can delete the demo alerts that are
> created when you install SQL Server (they all start with Demo) and you will
> no longer get these messages (because with no alerts defined there is no
> reason for SQL Agent to monitor the event log)
> --
> HTH
> Jasper Smith (SQL Server MVP)
> http://www.sqldbatips.com
> I support PASS - the definitive, global
> community for SQL Server professionals -
> http://www.sqlpass.org
> "The Vogon" <The Vogon@.discussions.microsoft.com> wrote in message
> news:14E7C465-925F-4B88-9222-7CA5DED549DD@.microsoft.com...
>
>

Events 311, 312, 318.

Each time I clear the event log on two of our SQL servers, I get the
following errors a few seconds later (see below). Config is as follows:
Win2k3, IIS, SQL2000SP4, NOT Active Directory (these are primarily web
servers).
Any help in clearing up these annoying error messages would be appreciated.
----
--
Event Type: Warning
Event Source: SQLSERVERAGENT
Event Category: Alert Engine
Event ID: 312
Date: 27.10.2005
Time: 08:53:31
User: N/A
Computer: DNS3
Description:
Successfully re-opened the local eventlog - NOTE: Some events may have been
missed.
----
--
Event Type: Information
Event Source: SQLSERVERAGENT
Event Category: Alert Engine
Event ID: 311
Date: 27.10.2005
Time: 08:53:31
User: N/A
Computer: DNS3
Description:
Attempting to to re-open the local eventlog...
----
--
Event Type: Error
Event Source: SQLSERVERAGENT
Event Category: Alert Engine
Event ID: 318
Date: 27.10.2005
Time: 08:53:31
User: N/A
Computer: DNS3
Description:
Unable to read local eventlog (reason: The event log file has changed
between read operations).
----
--It's chicken and egg. The reason you get the messages is because you cleared
the event log. SQLAgent monitors the event log for alerting purposes and
when you clear it, it has to try and re-establish its monitoring. However,
if you don't use SQL Agent alerts you can delete the demo alerts that are
created when you install SQL Server (they all start with Demo) and you will
no longer get these messages (because with no alerts defined there is no
reason for SQL Agent to monitor the event log)
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"The Vogon" <The Vogon@.discussions.microsoft.com> wrote in message
news:14E7C465-925F-4B88-9222-7CA5DED549DD@.microsoft.com...
> Each time I clear the event log on two of our SQL servers, I get the
> following errors a few seconds later (see below). Config is as follows:
> Win2k3, IIS, SQL2000SP4, NOT Active Directory (these are primarily web
> servers).
> Any help in clearing up these annoying error messages would be
> appreciated.
> ----
--
> Event Type: Warning
> Event Source: SQLSERVERAGENT
> Event Category: Alert Engine
> Event ID: 312
> Date: 27.10.2005
> Time: 08:53:31
> User: N/A
> Computer: DNS3
> Description:
> Successfully re-opened the local eventlog - NOTE: Some events may have
> been
> missed.
> ----
--
> Event Type: Information
> Event Source: SQLSERVERAGENT
> Event Category: Alert Engine
> Event ID: 311
> Date: 27.10.2005
> Time: 08:53:31
> User: N/A
> Computer: DNS3
> Description:
> Attempting to to re-open the local eventlog...
> ----
--
> Event Type: Error
> Event Source: SQLSERVERAGENT
> Event Category: Alert Engine
> Event ID: 318
> Date: 27.10.2005
> Time: 08:53:31
> User: N/A
> Computer: DNS3
> Description:
> Unable to read local eventlog (reason: The event log file has changed
> between read operations).
> ----
--
>|||Thankyou Jasper!
I have no need for SQL Agent Alerts, so the demo alerts have been deleted
and the problem is now resolved...
"Jasper Smith" wrote:

> It's chicken and egg. The reason you get the messages is because you clear
ed
> the event log. SQLAgent monitors the event log for alerting purposes and
> when you clear it, it has to try and re-establish its monitoring. However,
> if you don't use SQL Agent alerts you can delete the demo alerts that are
> created when you install SQL Server (they all start with Demo) and you wil
l
> no longer get these messages (because with no alerts defined there is no
> reason for SQL Agent to monitor the event log)
> --
> HTH
> Jasper Smith (SQL Server MVP)
> http://www.sqldbatips.com
> I support PASS - the definitive, global
> community for SQL Server professionals -
> http://www.sqlpass.org
> "The Vogon" <The Vogon@.discussions.microsoft.com> wrote in message
> news:14E7C465-925F-4B88-9222-7CA5DED549DD@.microsoft.com...
>
>

Events 311, 312, 318.

Each time I clear the event log on two of our SQL servers, I get the
following errors a few seconds later (see below). Config is as follows:
Win2k3, IIS, SQL2000SP4, NOT Active Directory (these are primarily web
servers).
Any help in clearing up these annoying error messages would be appreciated.
----
Event Type: Warning
Event Source: SQLSERVERAGENT
Event Category: Alert Engine
Event ID: 312
Date: 27.10.2005
Time: 08:53:31
User: N/A
Computer: DNS3
Description:
Successfully re-opened the local eventlog - NOTE: Some events may have been
missed.
----
Event Type: Information
Event Source: SQLSERVERAGENT
Event Category: Alert Engine
Event ID: 311
Date: 27.10.2005
Time: 08:53:31
User: N/A
Computer: DNS3
Description:
Attempting to to re-open the local eventlog...
----
Event Type: Error
Event Source: SQLSERVERAGENT
Event Category: Alert Engine
Event ID: 318
Date: 27.10.2005
Time: 08:53:31
User: N/A
Computer: DNS3
Description:
Unable to read local eventlog (reason: The event log file has changed
between read operations).
----It's chicken and egg. The reason you get the messages is because you cleared
the event log. SQLAgent monitors the event log for alerting purposes and
when you clear it, it has to try and re-establish its monitoring. However,
if you don't use SQL Agent alerts you can delete the demo alerts that are
created when you install SQL Server (they all start with Demo) and you will
no longer get these messages (because with no alerts defined there is no
reason for SQL Agent to monitor the event log)
--
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"The Vogon" <The Vogon@.discussions.microsoft.com> wrote in message
news:14E7C465-925F-4B88-9222-7CA5DED549DD@.microsoft.com...
> Each time I clear the event log on two of our SQL servers, I get the
> following errors a few seconds later (see below). Config is as follows:
> Win2k3, IIS, SQL2000SP4, NOT Active Directory (these are primarily web
> servers).
> Any help in clearing up these annoying error messages would be
> appreciated.
> ----
> Event Type: Warning
> Event Source: SQLSERVERAGENT
> Event Category: Alert Engine
> Event ID: 312
> Date: 27.10.2005
> Time: 08:53:31
> User: N/A
> Computer: DNS3
> Description:
> Successfully re-opened the local eventlog - NOTE: Some events may have
> been
> missed.
> ----
> Event Type: Information
> Event Source: SQLSERVERAGENT
> Event Category: Alert Engine
> Event ID: 311
> Date: 27.10.2005
> Time: 08:53:31
> User: N/A
> Computer: DNS3
> Description:
> Attempting to to re-open the local eventlog...
> ----
> Event Type: Error
> Event Source: SQLSERVERAGENT
> Event Category: Alert Engine
> Event ID: 318
> Date: 27.10.2005
> Time: 08:53:31
> User: N/A
> Computer: DNS3
> Description:
> Unable to read local eventlog (reason: The event log file has changed
> between read operations).
> ----
>|||Thankyou Jasper!
I have no need for SQL Agent Alerts, so the demo alerts have been deleted
and the problem is now resolved...
"Jasper Smith" wrote:
> It's chicken and egg. The reason you get the messages is because you cleared
> the event log. SQLAgent monitors the event log for alerting purposes and
> when you clear it, it has to try and re-establish its monitoring. However,
> if you don't use SQL Agent alerts you can delete the demo alerts that are
> created when you install SQL Server (they all start with Demo) and you will
> no longer get these messages (because with no alerts defined there is no
> reason for SQL Agent to monitor the event log)
> --
> HTH
> Jasper Smith (SQL Server MVP)
> http://www.sqldbatips.com
> I support PASS - the definitive, global
> community for SQL Server professionals -
> http://www.sqlpass.org
> "The Vogon" <The Vogon@.discussions.microsoft.com> wrote in message
> news:14E7C465-925F-4B88-9222-7CA5DED549DD@.microsoft.com...
> > Each time I clear the event log on two of our SQL servers, I get the
> > following errors a few seconds later (see below). Config is as follows:
> > Win2k3, IIS, SQL2000SP4, NOT Active Directory (these are primarily web
> > servers).
> >
> > Any help in clearing up these annoying error messages would be
> > appreciated.
> >
> > ----
> > Event Type: Warning
> > Event Source: SQLSERVERAGENT
> > Event Category: Alert Engine
> > Event ID: 312
> > Date: 27.10.2005
> > Time: 08:53:31
> > User: N/A
> > Computer: DNS3
> > Description:
> > Successfully re-opened the local eventlog - NOTE: Some events may have
> > been
> > missed.
> > ----
> > Event Type: Information
> > Event Source: SQLSERVERAGENT
> > Event Category: Alert Engine
> > Event ID: 311
> > Date: 27.10.2005
> > Time: 08:53:31
> > User: N/A
> > Computer: DNS3
> > Description:
> > Attempting to to re-open the local eventlog...
> > ----
> > Event Type: Error
> > Event Source: SQLSERVERAGENT
> > Event Category: Alert Engine
> > Event ID: 318
> > Date: 27.10.2005
> > Time: 08:53:31
> > User: N/A
> > Computer: DNS3
> > Description:
> > Unable to read local eventlog (reason: The event log file has changed
> > between read operations).
> > ----
> >
>
>

Event log Errors

I am getting an odd error being logged in the event log to do with reporting services.

Report Server (MSSQLSERVER) cannot connect to the report server database.

We have 2 servers in the farm running on IA64, these errors are showing on both nodes they are connecting to a clustered SQL server instance. The odd thing is though, everything seems to be working! Reports run, the web viewer works, we are able to deploy reports from VS2005. So i am at a bit of a loss as to where and why we keep getting these errors.

Thanks in advance

Can you connect to the report server using a browser?

What is the setting for the reportserver virtual directory security in IIS. Is it set to windows authentication?

|||

Yes we can connect via a browser both remotely and locally.

Yes it is set to Windows Auth, the virtual directory is on the local C Drive.

|||Is the event showing up after a reboot, or does it repeat consistently?|||They still show up after a reboot, they seem to be fairly random a group all at once or just one every so often.

Event log error after SQL 2005 developer install

I get the following errors in my application event log on each reboot after
installing SQL Server 2005 developer edition.
..NET Runtime Optimization Service (clr_optimization_v2.0.50727_32) - Failed
to compile: Microsoft.ReportingServices.QueryDesigners, Version=9.0.242.0,
Culture=neutral, PublicKeyToken=89845dcd8080cc91 . Error code = 0x80070002
and
..NET Runtime Optimization Service (clr_optimization_v2.0.50727_32) - Failed
to compile: Microsoft.ReportingServices.QueryDesigners, Version=9.0.242.0,
Culture=neutral, PublicKeyToken=89845dcd8080cc91 . Error code = 0x80070002
While they are the same error, it appears twice right after a reboot.
Any ideas? Is this a problem?
jim
Jim,
I am getting the same error and was wondering if you had any luck with
finding an answer or explaination to what this is?
Thanks -
Fred W.
"Jim H" wrote:

> I get the following errors in my application event log on each reboot after
> installing SQL Server 2005 developer edition.
> ..NET Runtime Optimization Service (clr_optimization_v2.0.50727_32) - Failed
> to compile: Microsoft.ReportingServices.QueryDesigners, Version=9.0.242.0,
> Culture=neutral, PublicKeyToken=89845dcd8080cc91 . Error code = 0x80070002
> and
> ..NET Runtime Optimization Service (clr_optimization_v2.0.50727_32) - Failed
> to compile: Microsoft.ReportingServices.QueryDesigners, Version=9.0.242.0,
> Culture=neutral, PublicKeyToken=89845dcd8080cc91 . Error code = 0x80070002
> While they are the same error, it appears twice right after a reboot.
>
> Any ideas? Is this a problem?
> jim
>
>
|||Nope, still waiting.
jim
"Memic" <Memic@.discussions.microsoft.com> wrote in message
news:ED2A87FE-C42D-48DA-8101-358EB483F430@.microsoft.com...[vbcol=seagreen]
> Jim,
> I am getting the same error and was wondering if you had any luck with
> finding an answer or explaination to what this is?
> Thanks -
> Fred W.
> "Jim H" wrote:

Event log error after SQL 2005 developer install

I get the following errors in my application event log on each reboot after
installing SQL Server 2005 developer edition.
.NET Runtime Optimization Service (clr_optimization_v2.0.50727_32) - Failed
to compile: Microsoft.ReportingServices.QueryDesigners, Version=9.0.242.0,
Culture=neutral, PublicKeyToken=89845dcd8080cc91 . Error code = 0x80070002
and
.NET Runtime Optimization Service (clr_optimization_v2.0.50727_32) - Failed
to compile: Microsoft.ReportingServices.QueryDesigners, Version=9.0.242.0,
Culture=neutral, PublicKeyToken=89845dcd8080cc91 . Error code = 0x80070002
While they are the same error, it appears twice right after a reboot.
Any ideas? Is this a problem?
jimJim,
I am getting the same error and was wondering if you had any luck with
finding an answer or explaination to what this is?
Thanks -
Fred W.
"Jim H" wrote:
> I get the following errors in my application event log on each reboot after
> installing SQL Server 2005 developer edition.
> ..NET Runtime Optimization Service (clr_optimization_v2.0.50727_32) - Failed
> to compile: Microsoft.ReportingServices.QueryDesigners, Version=9.0.242.0,
> Culture=neutral, PublicKeyToken=89845dcd8080cc91 . Error code = 0x80070002
> and
> ..NET Runtime Optimization Service (clr_optimization_v2.0.50727_32) - Failed
> to compile: Microsoft.ReportingServices.QueryDesigners, Version=9.0.242.0,
> Culture=neutral, PublicKeyToken=89845dcd8080cc91 . Error code = 0x80070002
> While they are the same error, it appears twice right after a reboot.
>
> Any ideas? Is this a problem?
> jim
>
>|||Nope, still waiting.
jim
"Memic" <Memic@.discussions.microsoft.com> wrote in message
news:ED2A87FE-C42D-48DA-8101-358EB483F430@.microsoft.com...
> Jim,
> I am getting the same error and was wondering if you had any luck with
> finding an answer or explaination to what this is?
> Thanks -
> Fred W.
> "Jim H" wrote:
>> I get the following errors in my application event log on each reboot
>> after
>> installing SQL Server 2005 developer edition.
>> ..NET Runtime Optimization Service (clr_optimization_v2.0.50727_32) -
>> Failed
>> to compile: Microsoft.ReportingServices.QueryDesigners,
>> Version=9.0.242.0,
>> Culture=neutral, PublicKeyToken=89845dcd8080cc91 . Error code =>> 0x80070002
>> and
>> ..NET Runtime Optimization Service (clr_optimization_v2.0.50727_32) -
>> Failed
>> to compile: Microsoft.ReportingServices.QueryDesigners,
>> Version=9.0.242.0,
>> Culture=neutral, PublicKeyToken=89845dcd8080cc91 . Error code =>> 0x80070002
>> While they are the same error, it appears twice right after a reboot.
>>
>> Any ideas? Is this a problem?
>> jim
>>

Event log error after SQL 2005 developer install

I get the following errors in my application event log on each reboot after
installing SQL Server 2005 developer edition.
.NET Runtime Optimization Service (clr_optimization_v2.0.50727_32) - Failed
to compile: Microsoft.ReportingServices.QueryDesigners, Version=9.0.242.0,
Culture=neutral, PublicKeyToken=89845dcd8080cc91 . Error code = 0x80070002
and
.NET Runtime Optimization Service (clr_optimization_v2.0.50727_32) - Failed
to compile: Microsoft.ReportingServices.QueryDesigners, Version=9.0.242.0,
Culture=neutral, PublicKeyToken=89845dcd8080cc91 . Error code = 0x80070002
While they are the same error, it appears twice right after a reboot.
Any ideas? Is this a problem?
jimJim,
I am getting the same error and was wondering if you had any luck with
finding an answer or explaination to what this is?
Thanks -
Fred W.
"Jim H" wrote:

> I get the following errors in my application event log on each reboot afte
r
> installing SQL Server 2005 developer edition.
> ..NET Runtime Optimization Service (clr_optimization_v2.0.50727_32) - Fail
ed
> to compile: Microsoft.ReportingServices.QueryDesigners, Version=9.0.242.0,
> Culture=neutral, PublicKeyToken=89845dcd8080cc91 . Error code = 0x80070002
> and
> ..NET Runtime Optimization Service (clr_optimization_v2.0.50727_32) - Fail
ed
> to compile: Microsoft.ReportingServices.QueryDesigners, Version=9.0.242.0,
> Culture=neutral, PublicKeyToken=89845dcd8080cc91 . Error code = 0x80070002
> While they are the same error, it appears twice right after a reboot.
>
> Any ideas? Is this a problem?
> jim
>
>|||Nope, still waiting.
jim
"Memic" <Memic@.discussions.microsoft.com> wrote in message
news:ED2A87FE-C42D-48DA-8101-358EB483F430@.microsoft.com...[vbcol=seagreen]
> Jim,
> I am getting the same error and was wondering if you had any luck with
> finding an answer or explaination to what this is?
> Thanks -
> Fred W.
> "Jim H" wrote:
>

Event log 17055 errors

Hey guys,
I'm running sql server2000 enterprise with SP4. All of a sudden, I am
getting 17055 errors (Category 2 and 6). Here are samples:
Event Type:Error
Event Source:MSSQLSERVER
Event Category:(6)
Event ID:17055
Date:5/21/2007
Time:4:15:09 AM
User:N/A
Computer:SQL1
Description:
3041 :
BACKUP failed to complete the command BACKUP DATABASE [ZENworks] TO
VIRTUAL_DEVICE='{9EBA7F59-A3DE-4007-8D1C-7BA920CD8642}' WITH SNAPSHOT
Event Type:Error
Event Source:MSSQLSERVER
Event Category:(2)
Event ID:17055
Date:5/21/2007
Time:4:15:09 AM
User:N/A
Computer:CCPSSQL1
Description:
18210 :
BackupVirtualDeviceFile::TakeSnapshot: failure on backup device
'{9EBA7F59-A3DE-4007-8D1C-7BA920CD8642}'. Operating system error 995(The I/O
operation has been aborted because of either a thread exit or an application
request.).
At first I thought it was drive space issue, but there is plenty of space on
the backup volume. Any ideas?
Thanks,
Larry
Hi Larry
"Larry" wrote:

> Hey guys,
> I'm running sql server2000 enterprise with SP4. All of a sudden, I am
> getting 17055 errors (Category 2 and 6). Here are samples:
> Event Type:Error
> Event Source:MSSQLSERVER
> Event Category:(6)
> Event ID:17055
> Date:5/21/2007
> Time:4:15:09 AM
> User:N/A
> Computer:SQL1
> Description:
> 3041 :
> BACKUP failed to complete the command BACKUP DATABASE [ZENworks] TO
> VIRTUAL_DEVICE='{9EBA7F59-A3DE-4007-8D1C-7BA920CD8642}' WITH SNAPSHOT
>
> Event Type:Error
> Event Source:MSSQLSERVER
> Event Category:(2)
> Event ID:17055
> Date:5/21/2007
> Time:4:15:09 AM
> User:N/A
> Computer:CCPSSQL1
> Description:
> 18210 :
> BackupVirtualDeviceFile::TakeSnapshot: failure on backup device
> '{9EBA7F59-A3DE-4007-8D1C-7BA920CD8642}'. Operating system error 995(The I/O
> operation has been aborted because of either a thread exit or an application
> request.).
>
> At first I thought it was drive space issue, but there is plenty of space on
> the backup volume. Any ideas?
> Thanks,
> Larry
Looking for the 995 error turns up a few instances such as
http://tinyurl.com/yqh2pr although there doesn't seem to be an absolute
reason/answer. Is there any indications of a problem with the devices earlier
in the event log? What does the SQL Server error log say?
John
|||John,
Looking further back in tha application event log, I cam across the
following warning events:
Event Type:Warning
Event Source:SQLSERVERAGENT
Event Category:Job Engine
Event ID:208
Date:5/21/2007
Time:3:03:24 AM
User:N/A
Computer:SQL1
Description:
SQL Server Scheduled Job 'DB Backup Job for DB Maintenance Plan 'DB
Maintenance Plan1'' (0x28132269F9E31740AC82FF13854623BB) - Status: Failed -
Invoked on: 2007-05-21 03:00:00 - Message: The job failed. The Job was
invoked by Schedule 1 (Schedule 1). The last step to run was step 1 (Step 1).
Event Type:Warning
Event Source:SQLAgent$WEB
Event Category:Job Engine
Event ID:208
Date:5/21/2007
Time:3:15:00 AM
User:N/A
Computer:SQL1
Description:
SQL Server Scheduled Job 'Transaction Log Backup Job for DB Maintenance Plan
'DB Maintenance Plan1'' (0x6A5C46E6851D3D46BCE2C25E3F6A47C2) - Status: Failed
- Invoked on: 2007-05-21 03:15:00 - Message: The job failed. The Job was
invoked by Schedule 2 (Schedule 1). The last step to run was step 1 (Step 1).
Below is a partial content of the most recent errorlog file:
2007-05-20 04:15:37.00 backup BACKUP failed to complete the command
BACKUP DATABASE [AngelBetaLive] TO
VIRTUAL_DEVICE='{AED80475-7D86-4CC5-86A8-7BC1F20D48AD}' WITH SNAPSHOT
2007-05-20 04:15:37.00 spid71 BackupVirtualDeviceFile::TakeSnapshot:
failure on backup device '{AED80475-7D86-4CC5-86A8-7BC1F20D48AD}'. Operating
system error 995(The I/O operation has been aborted because of either a
thread exit or an application request.).
2007-05-20 04:15:37.06 spid71 Database AngelBetaLive: IO is thawed
2007-05-20 04:15:37.06 backup Database backed up: Database: sndata,
creation date(time): 2006/01/13(11:37:13), pages dumped: 1, first LSN:
766704:492:1, last LSN: 766704:494:1, number of dump devices: 1, device
information: (FILE=1, TYPE=VIRTUAL_DEVICE:
{'{1E0985AE-6086-4BA3-92E1-832F19FCA891}'}).
2007-05-20 04:15:38.04 spid72 BackupVirtualDeviceFile::TakeSnapshot:
failure on backup device '{CC3561FD-666A-4095-8DC5-A6C342C08779}'. Operating
system error 995(The I/O operation has been aborted because of either a
thread exit or an application request.).
2007-05-20 04:15:38.04 backup BACKUP failed to complete the command
BACKUP DATABASE [AngelBetaSQL] TO
VIRTUAL_DEVICE='{CC3561FD-666A-4095-8DC5-A6C342C08779}' WITH SNAPSHOT
2007-05-20 04:15:38.04 spid72 Database AngelBetaSQL: IO is thawed
2007-05-20 04:15:38.28 spid77 BackupVirtualDeviceFile::TakeSnapshot:
failure on backup device '{99252641-CC2D-454F-BC22-41987399D857}'. Operating
system error 995(The I/O operation has been aborted because of either a
thread exit or an application request.).
2007-05-20 04:15:38.28 backup BACKUP failed to complete the command
BACKUP DATABASE [Compellent] TO
VIRTUAL_DEVICE='{99252641-CC2D-454F-BC22-41987399D857}' WITH SNAPSHOT
2007-05-20 04:15:38.28 spid77 Database Compellent: IO is thawed
2007-05-20 04:15:38.31 spid78 BackupVirtualDeviceFile::TakeSnapshot:
failure on backup device '{F8D49E87-8B00-498A-AF65-DD5C44034D38}'. Operating
system error 995(The I/O operation has been aborted because of either a
thread exit or an application request.).
2007-05-20 04:15:38.31 backup BACKUP failed to complete the command
BACKUP DATABASE [compmsadb] TO
VIRTUAL_DEVICE='{F8D49E87-8B00-498A-AF65-DD5C44034D38}' WITH SNAPSHOT
2007-05-20 04:15:38.31 spid78 Database compmsadb: IO is thawed
2007-05-20 04:15:38.34 spid82 BackupVirtualDeviceFile::TakeSnapshot:
failure on backup device '{C0DE0FEC-F48E-414D-B288-B699F2AB4061}'. Operating
system error 995(The I/O operation has been aborted because of either a
thread exit or an application request.).
2007-05-20 04:15:38.34 backup BACKUP failed to complete the command
BACKUP DATABASE [Insight_v50_0_112126100] TO
VIRTUAL_DEVICE='{C0DE0FEC-F48E-414D-B288-B699F2AB4061}' WITH SNAPSHOT
2007-05-20 04:15:38.34 spid82 Database Insight_v50_0_112126100: IO is
thawed
2007-05-20 04:15:38.37 spid83 BackupVirtualDeviceFile::TakeSnapshot:
failure on backup device '{7EAB385B-5316-4D5D-83DC-A46346838A48}'. Operating
system error 995(The I/O operation has been aborted because of either a
thread exit or an application request.).
2007-05-20 04:15:38.37 backup BACKUP failed to complete the command
BACKUP DATABASE [Insight_v50_0_142631357] TO
VIRTUAL_DEVICE='{7EAB385B-5316-4D5D-83DC-A46346838A48}' WITH SNAPSHOT
2007-05-20 04:15:38.37 spid83 Database Insight_v50_0_142631357: IO is
thawed
2007-05-20 04:15:38.40 spid89 BackupVirtualDeviceFile::TakeSnapshot:
failure on backup device '{35EAC595-37CD-4B08-AEBD-D8D1A9317C71}'. Operating
system error 995(The I/O operation has been aborted because of either a
thread exit or an application request.).
2007-05-20 04:15:38.40 backup BACKUP failed to complete the command
BACKUP DATABASE [NSMRulestat] TO
VIRTUAL_DEVICE='{35EAC595-37CD-4B08-AEBD-D8D1A9317C71}' WITH SNAPSHOT
2007-05-20 04:15:38.40 spid89 Database NSMRulestat: IO is thawed
2007-05-20 04:15:38.43 spid92 BackupVirtualDeviceFile::TakeSnapshot:
failure on backup device '{FB52A694-27B9-4902-8522-98A82AA6B5A5}'. Operating
system error 995(The I/O operation has been aborted because of either a
thread exit or an application request.).
2007-05-20 04:15:38.43 backup BACKUP failed to complete the command
BACKUP DATABASE [vmm_db_v2] TO
VIRTUAL_DEVICE='{FB52A694-27B9-4902-8522-98A82AA6B5A5}' WITH SNAPSHOT
2007-05-20 04:15:38.43 spid92 Database vmm_db_v2: IO is thawed
2007-05-20 04:15:38.51 spid96 BackupVirtualDeviceFile::TakeSnapshot:
failure on backup device '{CFEB331A-D923-460E-9EF5-FCB6801CF6FE}'. Operating
system error 995(The I/O operation has been aborted because of either a
thread exit or an application request.).
2007-05-20 04:15:38.51 backup BACKUP failed to complete the command
BACKUP DATABASE [ZENworks] TO
VIRTUAL_DEVICE='{CFEB331A-D923-460E-9EF5-FCB6801CF6FE}' WITH SNAPSHOT
2007-05-20 04:15:38.51 spid96 Database ZENworks: IO is thawed
Larry
"John Bell" wrote:

> Hi Larry
> "Larry" wrote:
>
> Looking for the 995 error turns up a few instances such as
> http://tinyurl.com/yqh2pr although there doesn't seem to be an absolute
> reason/answer. Is there any indications of a problem with the devices earlier
> in the event log? What does the SQL Server error log say?
>
> John
|||Hi Larry
Looking at other posts the most likely cause is third party backup software,
if you are using a product then you will need make sure you have the latest
patches and if the problems persist contact the vendor.
http://tinyurl.com/2h646v
http://tinyurl.com/yrl2pm
John

Event log 17055 errors

Hey guys,
I'm running sql server2000 enterprise with SP4. All of a sudden, I am
getting 17055 errors (Category 2 and 6). Here are samples:
Event Type: Error
Event Source: MSSQLSERVER
Event Category: (6)
Event ID: 17055
Date: 5/21/2007
Time: 4:15:09 AM
User: N/A
Computer: SQL1
Description:
3041 :
BACKUP failed to complete the command BACKUP DATABASE [ZENworks] TO
VIRTUAL_DEVICE='{9EBA7F59-A3DE-4007-8D1C-7BA920CD8642}' WITH SNAPSHOT
Event Type: Error
Event Source: MSSQLSERVER
Event Category: (2)
Event ID: 17055
Date: 5/21/2007
Time: 4:15:09 AM
User: N/A
Computer: CCPSSQL1
Description:
18210 :
BackupVirtualDeviceFile::TakeSnapshot: failure on backup device
'{9EBA7F59-A3DE-4007-8D1C-7BA920CD8642}'. Operating system error 995(The I/O
operation has been aborted because of either a thread exit or an application
request.).
At first I thought it was drive space issue, but there is plenty of space on
the backup volume. Any ideas?
Thanks,
LarryHi Larry
"Larry" wrote:
> Hey guys,
> I'm running sql server2000 enterprise with SP4. All of a sudden, I am
> getting 17055 errors (Category 2 and 6). Here are samples:
> Event Type: Error
> Event Source: MSSQLSERVER
> Event Category: (6)
> Event ID: 17055
> Date: 5/21/2007
> Time: 4:15:09 AM
> User: N/A
> Computer: SQL1
> Description:
> 3041 :
> BACKUP failed to complete the command BACKUP DATABASE [ZENworks] TO
> VIRTUAL_DEVICE='{9EBA7F59-A3DE-4007-8D1C-7BA920CD8642}' WITH SNAPSHOT
>
> Event Type: Error
> Event Source: MSSQLSERVER
> Event Category: (2)
> Event ID: 17055
> Date: 5/21/2007
> Time: 4:15:09 AM
> User: N/A
> Computer: CCPSSQL1
> Description:
> 18210 :
> BackupVirtualDeviceFile::TakeSnapshot: failure on backup device
> '{9EBA7F59-A3DE-4007-8D1C-7BA920CD8642}'. Operating system error 995(The I/O
> operation has been aborted because of either a thread exit or an application
> request.).
>
> At first I thought it was drive space issue, but there is plenty of space on
> the backup volume. Any ideas?
> Thanks,
> Larry
Looking for the 995 error turns up a few instances such as
http://tinyurl.com/yqh2pr although there doesn't seem to be an absolute
reason/answer. Is there any indications of a problem with the devices earlier
in the event log? What does the SQL Server error log say?
John|||John,
Looking further back in tha application event log, I cam across the
following warning events:
Event Type: Warning
Event Source: SQLSERVERAGENT
Event Category: Job Engine
Event ID: 208
Date: 5/21/2007
Time: 3:03:24 AM
User: N/A
Computer: SQL1
Description:
SQL Server Scheduled Job 'DB Backup Job for DB Maintenance Plan 'DB
Maintenance Plan1'' (0x28132269F9E31740AC82FF13854623BB) - Status: Failed -
Invoked on: 2007-05-21 03:00:00 - Message: The job failed. The Job was
invoked by Schedule 1 (Schedule 1). The last step to run was step 1 (Step 1).
Event Type: Warning
Event Source: SQLAgent$WEB
Event Category: Job Engine
Event ID: 208
Date: 5/21/2007
Time: 3:15:00 AM
User: N/A
Computer: SQL1
Description:
SQL Server Scheduled Job 'Transaction Log Backup Job for DB Maintenance Plan
'DB Maintenance Plan1'' (0x6A5C46E6851D3D46BCE2C25E3F6A47C2) - Status: Failed
- Invoked on: 2007-05-21 03:15:00 - Message: The job failed. The Job was
invoked by Schedule 2 (Schedule 1). The last step to run was step 1 (Step 1).
Below is a partial content of the most recent errorlog file:
2007-05-20 04:15:37.00 backup BACKUP failed to complete the command
BACKUP DATABASE [AngelBetaLive] TO
VIRTUAL_DEVICE='{AED80475-7D86-4CC5-86A8-7BC1F20D48AD}' WITH SNAPSHOT
2007-05-20 04:15:37.00 spid71 BackupVirtualDeviceFile::TakeSnapshot:
failure on backup device '{AED80475-7D86-4CC5-86A8-7BC1F20D48AD}'. Operating
system error 995(The I/O operation has been aborted because of either a
thread exit or an application request.).
2007-05-20 04:15:37.06 spid71 Database AngelBetaLive: IO is thawed
2007-05-20 04:15:37.06 backup Database backed up: Database: sndata,
creation date(time): 2006/01/13(11:37:13), pages dumped: 1, first LSN:
766704:492:1, last LSN: 766704:494:1, number of dump devices: 1, device
information: (FILE=1, TYPE=VIRTUAL_DEVICE:
{'{1E0985AE-6086-4BA3-92E1-832F19FCA891}'}).
2007-05-20 04:15:38.04 spid72 BackupVirtualDeviceFile::TakeSnapshot:
failure on backup device '{CC3561FD-666A-4095-8DC5-A6C342C08779}'. Operating
system error 995(The I/O operation has been aborted because of either a
thread exit or an application request.).
2007-05-20 04:15:38.04 backup BACKUP failed to complete the command
BACKUP DATABASE [AngelBetaSQL] TO
VIRTUAL_DEVICE='{CC3561FD-666A-4095-8DC5-A6C342C08779}' WITH SNAPSHOT
2007-05-20 04:15:38.04 spid72 Database AngelBetaSQL: IO is thawed
2007-05-20 04:15:38.28 spid77 BackupVirtualDeviceFile::TakeSnapshot:
failure on backup device '{99252641-CC2D-454F-BC22-41987399D857}'. Operating
system error 995(The I/O operation has been aborted because of either a
thread exit or an application request.).
2007-05-20 04:15:38.28 backup BACKUP failed to complete the command
BACKUP DATABASE [Compellent] TO
VIRTUAL_DEVICE='{99252641-CC2D-454F-BC22-41987399D857}' WITH SNAPSHOT
2007-05-20 04:15:38.28 spid77 Database Compellent: IO is thawed
2007-05-20 04:15:38.31 spid78 BackupVirtualDeviceFile::TakeSnapshot:
failure on backup device '{F8D49E87-8B00-498A-AF65-DD5C44034D38}'. Operating
system error 995(The I/O operation has been aborted because of either a
thread exit or an application request.).
2007-05-20 04:15:38.31 backup BACKUP failed to complete the command
BACKUP DATABASE [compmsadb] TO
VIRTUAL_DEVICE='{F8D49E87-8B00-498A-AF65-DD5C44034D38}' WITH SNAPSHOT
2007-05-20 04:15:38.31 spid78 Database compmsadb: IO is thawed
2007-05-20 04:15:38.34 spid82 BackupVirtualDeviceFile::TakeSnapshot:
failure on backup device '{C0DE0FEC-F48E-414D-B288-B699F2AB4061}'. Operating
system error 995(The I/O operation has been aborted because of either a
thread exit or an application request.).
2007-05-20 04:15:38.34 backup BACKUP failed to complete the command
BACKUP DATABASE [Insight_v50_0_112126100] TO
VIRTUAL_DEVICE='{C0DE0FEC-F48E-414D-B288-B699F2AB4061}' WITH SNAPSHOT
2007-05-20 04:15:38.34 spid82 Database Insight_v50_0_112126100: IO is
thawed
2007-05-20 04:15:38.37 spid83 BackupVirtualDeviceFile::TakeSnapshot:
failure on backup device '{7EAB385B-5316-4D5D-83DC-A46346838A48}'. Operating
system error 995(The I/O operation has been aborted because of either a
thread exit or an application request.).
2007-05-20 04:15:38.37 backup BACKUP failed to complete the command
BACKUP DATABASE [Insight_v50_0_142631357] TO
VIRTUAL_DEVICE='{7EAB385B-5316-4D5D-83DC-A46346838A48}' WITH SNAPSHOT
2007-05-20 04:15:38.37 spid83 Database Insight_v50_0_142631357: IO is
thawed
2007-05-20 04:15:38.40 spid89 BackupVirtualDeviceFile::TakeSnapshot:
failure on backup device '{35EAC595-37CD-4B08-AEBD-D8D1A9317C71}'. Operating
system error 995(The I/O operation has been aborted because of either a
thread exit or an application request.).
2007-05-20 04:15:38.40 backup BACKUP failed to complete the command
BACKUP DATABASE [NSMRulestat] TO
VIRTUAL_DEVICE='{35EAC595-37CD-4B08-AEBD-D8D1A9317C71}' WITH SNAPSHOT
2007-05-20 04:15:38.40 spid89 Database NSMRulestat: IO is thawed
2007-05-20 04:15:38.43 spid92 BackupVirtualDeviceFile::TakeSnapshot:
failure on backup device '{FB52A694-27B9-4902-8522-98A82AA6B5A5}'. Operating
system error 995(The I/O operation has been aborted because of either a
thread exit or an application request.).
2007-05-20 04:15:38.43 backup BACKUP failed to complete the command
BACKUP DATABASE [vmm_db_v2] TO
VIRTUAL_DEVICE='{FB52A694-27B9-4902-8522-98A82AA6B5A5}' WITH SNAPSHOT
2007-05-20 04:15:38.43 spid92 Database vmm_db_v2: IO is thawed
2007-05-20 04:15:38.51 spid96 BackupVirtualDeviceFile::TakeSnapshot:
failure on backup device '{CFEB331A-D923-460E-9EF5-FCB6801CF6FE}'. Operating
system error 995(The I/O operation has been aborted because of either a
thread exit or an application request.).
2007-05-20 04:15:38.51 backup BACKUP failed to complete the command
BACKUP DATABASE [ZENworks] TO
VIRTUAL_DEVICE='{CFEB331A-D923-460E-9EF5-FCB6801CF6FE}' WITH SNAPSHOT
2007-05-20 04:15:38.51 spid96 Database ZENworks: IO is thawed
Larry
"John Bell" wrote:
> Hi Larry
> "Larry" wrote:
> > Hey guys,
> >
> > I'm running sql server2000 enterprise with SP4. All of a sudden, I am
> > getting 17055 errors (Category 2 and 6). Here are samples:
> >
> > Event Type: Error
> > Event Source: MSSQLSERVER
> > Event Category: (6)
> > Event ID: 17055
> > Date: 5/21/2007
> > Time: 4:15:09 AM
> > User: N/A
> > Computer: SQL1
> > Description:
> > 3041 :
> > BACKUP failed to complete the command BACKUP DATABASE [ZENworks] TO
> > VIRTUAL_DEVICE='{9EBA7F59-A3DE-4007-8D1C-7BA920CD8642}' WITH SNAPSHOT
> >
> >
> >
> > Event Type: Error
> > Event Source: MSSQLSERVER
> > Event Category: (2)
> > Event ID: 17055
> > Date: 5/21/2007
> > Time: 4:15:09 AM
> > User: N/A
> > Computer: CCPSSQL1
> > Description:
> > 18210 :
> > BackupVirtualDeviceFile::TakeSnapshot: failure on backup device
> > '{9EBA7F59-A3DE-4007-8D1C-7BA920CD8642}'. Operating system error 995(The I/O
> > operation has been aborted because of either a thread exit or an application
> > request.).
> >
> >
> > At first I thought it was drive space issue, but there is plenty of space on
> > the backup volume. Any ideas?
> >
> > Thanks,
> >
> > Larry
> Looking for the 995 error turns up a few instances such as
> http://tinyurl.com/yqh2pr although there doesn't seem to be an absolute
> reason/answer. Is there any indications of a problem with the devices earlier
> in the event log? What does the SQL Server error log say?
>
> John|||Hi Larry
Looking at other posts the most likely cause is third party backup software,
if you are using a product then you will need make sure you have the latest
patches and if the problems persist contact the vendor.
http://tinyurl.com/2h646v
http://tinyurl.com/yrl2pm
John

Event log 17055 errors

Hey guys,
I'm running sql server2000 enterprise with SP4. All of a sudden, I am
getting 17055 errors (Category 2 and 6). Here are samples:
Event Type: Error
Event Source: MSSQLSERVER
Event Category: (6)
Event ID: 17055
Date: 5/21/2007
Time: 4:15:09 AM
User: N/A
Computer: SQL1
Description:
3041 :
BACKUP failed to complete the command BACKUP DATABASE [ZENworks] TO
VIRTUAL_DEVICE='{9EBA7F59-A3DE-4007-8D1C-7BA920CD8642}' WITH SNAPSHOT
Event Type: Error
Event Source: MSSQLSERVER
Event Category: (2)
Event ID: 17055
Date: 5/21/2007
Time: 4:15:09 AM
User: N/A
Computer: CCPSSQL1
Description:
18210 :
BackupVirtualDeviceFile::TakeSnapshot: failure on backup device
'{9EBA7F59-A3DE-4007-8D1C-7BA920CD8642}'. Operating system error 995(Th
e I/O
operation has been aborted because of either a thread exit or an application
request.).
At first I thought it was drive space issue, but there is plenty of space on
the backup volume. Any ideas?
Thanks,
LarryHi Larry
"Larry" wrote:

> Hey guys,
> I'm running sql server2000 enterprise with SP4. All of a sudden, I am
> getting 17055 errors (Category 2 and 6). Here are samples:
> Event Type: Error
> Event Source: MSSQLSERVER
> Event Category: (6)
> Event ID: 17055
> Date: 5/21/2007
> Time: 4:15:09 AM
> User: N/A
> Computer: SQL1
> Description:
> 3041 :
> BACKUP failed to complete the command BACKUP DATABASE [ZENworks] TO
> VIRTUAL_DEVICE='{9EBA7F59-A3DE-4007-8D1C-7BA920CD8642}' WITH SNAPSHOT
>
> Event Type: Error
> Event Source: MSSQLSERVER
> Event Category: (2)
> Event ID: 17055
> Date: 5/21/2007
> Time: 4:15:09 AM
> User: N/A
> Computer: CCPSSQL1
> Description:
> 18210 :
> BackupVirtualDeviceFile::TakeSnapshot: failure on backup device
> '{9EBA7F59-A3DE-4007-8D1C-7BA920CD8642}'. Operating system error 995(
The I/O
> operation has been aborted because of either a thread exit or an applicati
on
> request.).
>
> At first I thought it was drive space issue, but there is plenty of space
on
> the backup volume. Any ideas?
> Thanks,
> Larry
Looking for the 995 error turns up a few instances such as
http://tinyurl.com/yqh2pr although there doesn't seem to be an absolute
reason/answer. Is there any indications of a problem with the devices earlie
r
in the event log? What does the SQL Server error log say?
John|||John,
Looking further back in tha application event log, I cam across the
following warning events:
Event Type: Warning
Event Source: SQLSERVERAGENT
Event Category: Job Engine
Event ID: 208
Date: 5/21/2007
Time: 3:03:24 AM
User: N/A
Computer: SQL1
Description:
SQL Server Scheduled Job 'DB Backup Job for DB Maintenance Plan 'DB
Maintenance Plan1'' (0x28132269F9E31740AC82FF13854623BB) - Status: Failed -
Invoked on: 2007-05-21 03:00:00 - Message: The job failed. The Job was
invoked by Schedule 1 (Schedule 1). The last step to run was step 1 (Step 1
).
Event Type: Warning
Event Source: SQLAgent$WEB
Event Category: Job Engine
Event ID: 208
Date: 5/21/2007
Time: 3:15:00 AM
User: N/A
Computer: SQL1
Description:
SQL Server Scheduled Job 'Transaction Log Backup Job for DB Maintenance Plan
'DB Maintenance Plan1'' (0x6A5C46E6851D3D46BCE2C25E3F6A47C2) - Status: Faile
d
- Invoked on: 2007-05-21 03:15:00 - Message: The job failed. The Job was
invoked by Schedule 2 (Schedule 1). The last step to run was step 1 (Step 1
).
Below is a partial content of the most recent errorlog file:
2007-05-20 04:15:37.00 backup BACKUP failed to complete the command
BACKUP DATABASE [AngelBetaLive] TO
VIRTUAL_DEVICE='{AED80475-7D86-4CC5-86A8-7BC1F20D48AD}' WITH SNAPSHOT
2007-05-20 04:15:37.00 spid71 BackupVirtualDeviceFile::TakeSnapshot:
failure on backup device '{AED80475-7D86-4CC5-86A8-7BC1F20D48AD}'. Oper
ating
system error 995(The I/O operation has been aborted because of either a
thread exit or an application request.).
2007-05-20 04:15:37.06 spid71 Database AngelBetaLive: IO is thawed
2007-05-20 04:15:37.06 backup Database backed up: Database: sndata,
creation date(time): 2006/01/13(11:37:13), pages dumped: 1, first LSN:
766704:492:1, last LSN: 766704:494:1, number of dump devices: 1, device
information: (FILE=1, TYPE=VIRTUAL_DEVICE:
{'{1E0985AE-6086-4BA3-92E1-832F19FCA891}'}).
2007-05-20 04:15:38.04 spid72 BackupVirtualDeviceFile::TakeSnapshot:
failure on backup device '{CC3561FD-666A-4095-8DC5-A6C342C08779}'. Oper
ating
system error 995(The I/O operation has been aborted because of either a
thread exit or an application request.).
2007-05-20 04:15:38.04 backup BACKUP failed to complete the command
BACKUP DATABASE [AngelBetaSQL] TO
VIRTUAL_DEVICE='{CC3561FD-666A-4095-8DC5-A6C342C08779}' WITH SNAPSHOT
2007-05-20 04:15:38.04 spid72 Database AngelBetaSQL: IO is thawed
2007-05-20 04:15:38.28 spid77 BackupVirtualDeviceFile::TakeSnapshot:
failure on backup device '{99252641-CC2D-454F-BC22-41987399D857}'. Oper
ating
system error 995(The I/O operation has been aborted because of either a
thread exit or an application request.).
2007-05-20 04:15:38.28 backup BACKUP failed to complete the command
BACKUP DATABASE [Compellent] TO
VIRTUAL_DEVICE='{99252641-CC2D-454F-BC22-41987399D857}' WITH SNAPSHOT
2007-05-20 04:15:38.28 spid77 Database Compellent: IO is thawed
2007-05-20 04:15:38.31 spid78 BackupVirtualDeviceFile::TakeSnapshot:
failure on backup device '{F8D49E87-8B00-498A-AF65-DD5C44034D38}'. Oper
ating
system error 995(The I/O operation has been aborted because of either a
thread exit or an application request.).
2007-05-20 04:15:38.31 backup BACKUP failed to complete the command
BACKUP DATABASE [compmsadb] TO
VIRTUAL_DEVICE='{F8D49E87-8B00-498A-AF65-DD5C44034D38}' WITH SNAPSHOT
2007-05-20 04:15:38.31 spid78 Database compmsadb: IO is thawed
2007-05-20 04:15:38.34 spid82 BackupVirtualDeviceFile::TakeSnapshot:
failure on backup device '{C0DE0FEC-F48E-414D-B288-B699F2AB4061}'. Oper
ating
system error 995(The I/O operation has been aborted because of either a
thread exit or an application request.).
2007-05-20 04:15:38.34 backup BACKUP failed to complete the command
BACKUP DATABASE [Insight_v50_0_112126100] TO
VIRTUAL_DEVICE='{C0DE0FEC-F48E-414D-B288-B699F2AB4061}' WITH SNAPSHOT
2007-05-20 04:15:38.34 spid82 Database Insight_v50_0_112126100: IO is
thawed
2007-05-20 04:15:38.37 spid83 BackupVirtualDeviceFile::TakeSnapshot:
failure on backup device '{7EAB385B-5316-4D5D-83DC-A46346838A48}'. Oper
ating
system error 995(The I/O operation has been aborted because of either a
thread exit or an application request.).
2007-05-20 04:15:38.37 backup BACKUP failed to complete the command
BACKUP DATABASE [Insight_v50_0_142631357] TO
VIRTUAL_DEVICE='{7EAB385B-5316-4D5D-83DC-A46346838A48}' WITH SNAPSHOT
2007-05-20 04:15:38.37 spid83 Database Insight_v50_0_142631357: IO is
thawed
2007-05-20 04:15:38.40 spid89 BackupVirtualDeviceFile::TakeSnapshot:
failure on backup device '{35EAC595-37CD-4B08-AEBD-D8D1A9317C71}'. Oper
ating
system error 995(The I/O operation has been aborted because of either a
thread exit or an application request.).
2007-05-20 04:15:38.40 backup BACKUP failed to complete the command
BACKUP DATABASE [NSMRulestat] TO
VIRTUAL_DEVICE='{35EAC595-37CD-4B08-AEBD-D8D1A9317C71}' WITH SNAPSHOT
2007-05-20 04:15:38.40 spid89 Database NSMRulestat: IO is thawed
2007-05-20 04:15:38.43 spid92 BackupVirtualDeviceFile::TakeSnapshot:
failure on backup device '{FB52A694-27B9-4902-8522-98A82AA6B5A5}'. Oper
ating
system error 995(The I/O operation has been aborted because of either a
thread exit or an application request.).
2007-05-20 04:15:38.43 backup BACKUP failed to complete the command
BACKUP DATABASE [vmm_db_v2] TO
VIRTUAL_DEVICE='{FB52A694-27B9-4902-8522-98A82AA6B5A5}' WITH SNAPSHOT
2007-05-20 04:15:38.43 spid92 Database vmm_db_v2: IO is thawed
2007-05-20 04:15:38.51 spid96 BackupVirtualDeviceFile::TakeSnapshot:
failure on backup device '{CFEB331A-D923-460E-9EF5-FCB6801CF6FE}'. Oper
ating
system error 995(The I/O operation has been aborted because of either a
thread exit or an application request.).
2007-05-20 04:15:38.51 backup BACKUP failed to complete the command
BACKUP DATABASE [ZENworks] TO
VIRTUAL_DEVICE='{CFEB331A-D923-460E-9EF5-FCB6801CF6FE}' WITH SNAPSHOT
2007-05-20 04:15:38.51 spid96 Database ZENworks: IO is thawed
Larry
"John Bell" wrote:

> Hi Larry
> "Larry" wrote:
>
> Looking for the 995 error turns up a few instances such as
> http://tinyurl.com/yqh2pr although there doesn't seem to be an absolute
> reason/answer. Is there any indications of a problem with the devices earl
ier
> in the event log? What does the SQL Server error log say?
>
> John|||Hi Larry
Looking at other posts the most likely cause is third party backup software,
if you are using a product then you will need make sure you have the latest
patches and if the problems persist contact the vendor.
http://tinyurl.com/2h646v
http://tinyurl.com/yrl2pm
John

Event ID 6013

I'm getting the following error everyday. I checked MS knowledge base and
found a reference to restore errors, but I'm not doing a restore.
Any ideas?
EVENT # 17861
EVENT LOG Application
EVENT TYPE Error
SOURCE VSS
EVENT ID 6013
COMPUTERNAME INTAKE2003
TIME 1/14/2007 7:30:03 PM
MESSAGE Sqllib error: OLEDB Error encountered calling ICommandText::Execute.
hr = 0x80040e09. SQLSTATE: 42000, Native Error: 229
Error state: 5, Severity: 14
Source: Microsoft OLE DB Provider for SQL Server
Error message: SELECT permission denied on object 'sysaltfiles', database
'master', owner 'dbo'.
BINARY DATA 0000: 2D 20 43 6F 64 65 3A 20 53 51 4C 43 4F 4E 4E 43
0010: 30 30 30 30 30 36 33 39 2D 20 43 61 6C 6C 3A 20
0020: 53 51 4C 43 4F 4E 4E 43 30 30 30 30 30 36 31 34
0030: 2D 20 50 49 44 3A 20 20 30 30 30 30 35 32 32 30
0040: 2D 20 54 49 44 3A 20 20 30 30 30 30 35 39 32 30
0050: 2D 20 43 4D 44 3A 20 20 43 3A 5C 57 49 4E 44 4F
0060: 57 53 5C 53 79 73 74 65 6D 33 32 5C 76 73 73 76
0070: 63 2E 65 78 65 20 20 20 2D 20 55 73 65 72 3A 20
0080: 4E 54 20 41 55 54 48 4F 52 49 54 59 5C 53 59 53
0090: 54 45 4D 20 20 20 20 20 2D 20 53 69 64 3A 20 20
00A0: 53 2D 31 2D 35 2D 31 38
Hi
http://demos.software-answers.com/CS/blogs/mike_bazarewsky/archive/2005/06/13/54.aspx
"Cwhitmore" <Cwhitmore@.discussions.microsoft.com> wrote in message
news:8B8F3C3F-0B5F-43E3-B2F4-BBF24672D015@.microsoft.com...
> I'm getting the following error everyday. I checked MS knowledge base and
> found a reference to restore errors, but I'm not doing a restore.
> Any ideas?
> EVENT # 17861
> EVENT LOG Application
> EVENT TYPE Error
> SOURCE VSS
> EVENT ID 6013
> COMPUTERNAME INTAKE2003
> TIME 1/14/2007 7:30:03 PM
> MESSAGE Sqllib error: OLEDB Error encountered calling
> ICommandText::Execute.
> hr = 0x80040e09. SQLSTATE: 42000, Native Error: 229
> Error state: 5, Severity: 14
> Source: Microsoft OLE DB Provider for SQL Server
> Error message: SELECT permission denied on object 'sysaltfiles', database
> 'master', owner 'dbo'.
>
> BINARY DATA 0000: 2D 20 43 6F 64 65 3A 20 53 51 4C 43 4F 4E 4E 43
> 0010: 30 30 30 30 30 36 33 39 2D 20 43 61 6C 6C 3A 20
> 0020: 53 51 4C 43 4F 4E 4E 43 30 30 30 30 30 36 31 34
> 0030: 2D 20 50 49 44 3A 20 20 30 30 30 30 35 32 32 30
> 0040: 2D 20 54 49 44 3A 20 20 30 30 30 30 35 39 32 30
> 0050: 2D 20 43 4D 44 3A 20 20 43 3A 5C 57 49 4E 44 4F
> 0060: 57 53 5C 53 79 73 74 65 6D 33 32 5C 76 73 73 76
> 0070: 63 2E 65 78 65 20 20 20 2D 20 55 73 65 72 3A 20
> 0080: 4E 54 20 41 55 54 48 4F 52 49 54 59 5C 53 59 53
> 0090: 54 45 4D 20 20 20 20 20 2D 20 53 69 64 3A 20 20
> 00A0: 53 2D 31 2D 35 2D 31 38
>
>
|||Uri,
Thanks for finding that post. I put local system back into the sysadmin
group. We'll see if it starts to work again.
Carlton.
"Uri Dimant" wrote:

> Hi
> http://demos.software-answers.com/CS/blogs/mike_bazarewsky/archive/2005/06/13/54.aspx
>
> "Cwhitmore" <Cwhitmore@.discussions.microsoft.com> wrote in message
> news:8B8F3C3F-0B5F-43E3-B2F4-BBF24672D015@.microsoft.com...
>
>

Event ID 6013

I'm getting the following error everyday. I checked MS knowledge base and
found a reference to restore errors, but I'm not doing a restore.
Any ideas?
EVENT # 17861
EVENT LOG Application
EVENT TYPE Error
SOURCE VSS
EVENT ID 6013
COMPUTERNAME INTAKE2003
TIME 1/14/2007 7:30:03 PM
MESSAGE Sqllib error: OLEDB Error encountered calling ICommandText::Execute.
hr = 0x80040e09. SQLSTATE: 42000, Native Error: 229
Error state: 5, Severity: 14
Source: Microsoft OLE DB Provider for SQL Server
Error message: SELECT permission denied on object 'sysaltfiles', database
'master', owner 'dbo'.
BINARY DATA 0000: 2D 20 43 6F 64 65 3A 20 53 51 4C 43 4F 4E 4E 43
0010: 30 30 30 30 30 36 33 39 2D 20 43 61 6C 6C 3A 20
0020: 53 51 4C 43 4F 4E 4E 43 30 30 30 30 30 36 31 34
0030: 2D 20 50 49 44 3A 20 20 30 30 30 30 35 32 32 30
0040: 2D 20 54 49 44 3A 20 20 30 30 30 30 35 39 32 30
0050: 2D 20 43 4D 44 3A 20 20 43 3A 5C 57 49 4E 44 4F
0060: 57 53 5C 53 79 73 74 65 6D 33 32 5C 76 73 73 76
0070: 63 2E 65 78 65 20 20 20 2D 20 55 73 65 72 3A 20
0080: 4E 54 20 41 55 54 48 4F 52 49 54 59 5C 53 59 53
0090: 54 45 4D 20 20 20 20 20 2D 20 53 69 64 3A 20 20
00A0: 53 2D 31 2D 35 2D 31 38Hi
http://demos.software-answers.com/CS/blogs/mike_bazarewsky/archive/2005/06/13/54.aspx
"Cwhitmore" <Cwhitmore@.discussions.microsoft.com> wrote in message
news:8B8F3C3F-0B5F-43E3-B2F4-BBF24672D015@.microsoft.com...
> I'm getting the following error everyday. I checked MS knowledge base and
> found a reference to restore errors, but I'm not doing a restore.
> Any ideas?
> EVENT # 17861
> EVENT LOG Application
> EVENT TYPE Error
> SOURCE VSS
> EVENT ID 6013
> COMPUTERNAME INTAKE2003
> TIME 1/14/2007 7:30:03 PM
> MESSAGE Sqllib error: OLEDB Error encountered calling
> ICommandText::Execute.
> hr = 0x80040e09. SQLSTATE: 42000, Native Error: 229
> Error state: 5, Severity: 14
> Source: Microsoft OLE DB Provider for SQL Server
> Error message: SELECT permission denied on object 'sysaltfiles', database
> 'master', owner 'dbo'.
>
> BINARY DATA 0000: 2D 20 43 6F 64 65 3A 20 53 51 4C 43 4F 4E 4E 43
> 0010: 30 30 30 30 30 36 33 39 2D 20 43 61 6C 6C 3A 20
> 0020: 53 51 4C 43 4F 4E 4E 43 30 30 30 30 30 36 31 34
> 0030: 2D 20 50 49 44 3A 20 20 30 30 30 30 35 32 32 30
> 0040: 2D 20 54 49 44 3A 20 20 30 30 30 30 35 39 32 30
> 0050: 2D 20 43 4D 44 3A 20 20 43 3A 5C 57 49 4E 44 4F
> 0060: 57 53 5C 53 79 73 74 65 6D 33 32 5C 76 73 73 76
> 0070: 63 2E 65 78 65 20 20 20 2D 20 55 73 65 72 3A 20
> 0080: 4E 54 20 41 55 54 48 4F 52 49 54 59 5C 53 59 53
> 0090: 54 45 4D 20 20 20 20 20 2D 20 53 69 64 3A 20 20
> 00A0: 53 2D 31 2D 35 2D 31 38
>
>

Event ID 6013

I'm getting the following error everyday. I checked MS knowledge base and
found a reference to restore errors, but I'm not doing a restore.
Any ideas?
EVENT # 17861
EVENT LOG Application
EVENT TYPE Error
SOURCE VSS
EVENT ID 6013
COMPUTERNAME INTAKE2003
TIME 1/14/2007 7:30:03 PM
MESSAGE Sqllib error: OLEDB Error encountered calling ICommandText::Execute.
hr = 0x80040e09. SQLSTATE: 42000, Native Error: 229
Error state: 5, Severity: 14
Source: Microsoft OLE DB Provider for SQL Server
Error message: SELECT permission denied on object 'sysaltfiles', database
'master', owner 'dbo'.
BINARY DATA 0000: 2D 20 43 6F 64 65 3A 20 53 51 4C 43 4F 4E 4E 43
0010: 30 30 30 30 30 36 33 39 2D 20 43 61 6C 6C 3A 20
0020: 53 51 4C 43 4F 4E 4E 43 30 30 30 30 30 36 31 34
0030: 2D 20 50 49 44 3A 20 20 30 30 30 30 35 32 32 30
0040: 2D 20 54 49 44 3A 20 20 30 30 30 30 35 39 32 30
0050: 2D 20 43 4D 44 3A 20 20 43 3A 5C 57 49 4E 44 4F
0060: 57 53 5C 53 79 73 74 65 6D 33 32 5C 76 73 73 76
0070: 63 2E 65 78 65 20 20 20 2D 20 55 73 65 72 3A 20
0080: 4E 54 20 41 55 54 48 4F 52 49 54 59 5C 53 59 53
0090: 54 45 4D 20 20 20 20 20 2D 20 53 69 64 3A 20 20
00A0: 53 2D 31 2D 35 2D 31 38Hi
http://demos.software-answers.com/C...54.a
spx
"Cwhitmore" <Cwhitmore@.discussions.microsoft.com> wrote in message
news:8B8F3C3F-0B5F-43E3-B2F4-BBF24672D015@.microsoft.com...
> I'm getting the following error everyday. I checked MS knowledge base and
> found a reference to restore errors, but I'm not doing a restore.
> Any ideas?
> EVENT # 17861
> EVENT LOG Application
> EVENT TYPE Error
> SOURCE VSS
> EVENT ID 6013
> COMPUTERNAME INTAKE2003
> TIME 1/14/2007 7:30:03 PM
> MESSAGE Sqllib error: OLEDB Error encountered calling
> ICommandText::Execute.
> hr = 0x80040e09. SQLSTATE: 42000, Native Error: 229
> Error state: 5, Severity: 14
> Source: Microsoft OLE DB Provider for SQL Server
> Error message: SELECT permission denied on object 'sysaltfiles', database
> 'master', owner 'dbo'.
>
> BINARY DATA 0000: 2D 20 43 6F 64 65 3A 20 53 51 4C 43 4F 4E 4E 43
> 0010: 30 30 30 30 30 36 33 39 2D 20 43 61 6C 6C 3A 20
> 0020: 53 51 4C 43 4F 4E 4E 43 30 30 30 30 30 36 31 34
> 0030: 2D 20 50 49 44 3A 20 20 30 30 30 30 35 32 32 30
> 0040: 2D 20 54 49 44 3A 20 20 30 30 30 30 35 39 32 30
> 0050: 2D 20 43 4D 44 3A 20 20 43 3A 5C 57 49 4E 44 4F
> 0060: 57 53 5C 53 79 73 74 65 6D 33 32 5C 76 73 73 76
> 0070: 63 2E 65 78 65 20 20 20 2D 20 55 73 65 72 3A 20
> 0080: 4E 54 20 41 55 54 48 4F 52 49 54 59 5C 53 59 53
> 0090: 54 45 4D 20 20 20 20 20 2D 20 53 69 64 3A 20 20
> 00A0: 53 2D 31 2D 35 2D 31 38
>
>|||Uri,
Thanks for finding that post. I put local system back into the sysadmin
group. We'll see if it starts to work again.
Carlton.
"Uri Dimant" wrote:

> Hi
> http://demos.software-answers.com/C...54
.aspx
>
> "Cwhitmore" <Cwhitmore@.discussions.microsoft.com> wrote in message
> news:8B8F3C3F-0B5F-43E3-B2F4-BBF24672D015@.microsoft.com...
>
>

event id 4014

Hello,
I keep getting these errors in Event Log.
Source: MSSQLSERVER
A fatal error occurred while reading the input stream from the network. The
session will be terminated.
For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.
Has anyone seen these events? I couldn't find any information on how to fix
this error and if you know anything about it would you please share?
Thanks
Anyone?
"Zvonimir Bilic" wrote:

> Hello,
> I keep getting these errors in Event Log.
> Source: MSSQLSERVER
> A fatal error occurred while reading the input stream from the network. The
> session will be terminated.
> For more information, see Help and Support Center at
> http://go.microsoft.com/fwlink/events.asp.
> Has anyone seen these events? I couldn't find any information on how to fix
> this error and if you know anything about it would you please share?
> Thanks
|||You have a network issue - you'd want to start by monitoring
the network activity to find out what the issue is. The
following article explains how to setup network monitoring:
How to use Network Monitor to capture network traffic
http://support.microsoft.com/?id=812953
-Sue
On Fri, 30 Mar 2007 12:06:01 -0700, Zvonimir Bilic
<cezar@.hotmail.com> wrote:
[vbcol=seagreen]
>Anyone?
>"Zvonimir Bilic" wrote:

event id 4014

Hello,
I keep getting these errors in Event Log.
Source: MSSQLSERVER
A fatal error occurred while reading the input stream from the network. The
session will be terminated.
For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.
Has anyone seen these events? I couldn't find any information on how to fix
this error and if you know anything about it would you please share?
ThanksAnyone?
"Zvonimir Bilic" wrote:

> Hello,
> I keep getting these errors in Event Log.
> Source: MSSQLSERVER
> A fatal error occurred while reading the input stream from the network. Th
e
> session will be terminated.
> For more information, see Help and Support Center at
> http://go.microsoft.com/fwlink/events.asp.
> Has anyone seen these events? I couldn't find any information on how to fi
x
> this error and if you know anything about it would you please share?
> Thanks|||You have a network issue - you'd want to start by monitoring
the network activity to find out what the issue is. The
following article explains how to setup network monitoring:
How to use Network Monitor to capture network traffic
http://support.microsoft.com/?id=812953
-Sue
On Fri, 30 Mar 2007 12:06:01 -0700, Zvonimir Bilic
<cezar@.hotmail.com> wrote:
[vbcol=seagreen]
>Anyone?
>"Zvonimir Bilic" wrote:
>

event id 4014

Hello,
I keep getting these errors in Event Log.
Source: MSSQLSERVER
A fatal error occurred while reading the input stream from the network. The
session will be terminated.
For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.
Has anyone seen these events? I couldn't find any information on how to fix
this error and if you know anything about it would you please share?
ThanksAnyone?
"Zvonimir Bilic" wrote:
> Hello,
> I keep getting these errors in Event Log.
> Source: MSSQLSERVER
> A fatal error occurred while reading the input stream from the network. The
> session will be terminated.
> For more information, see Help and Support Center at
> http://go.microsoft.com/fwlink/events.asp.
> Has anyone seen these events? I couldn't find any information on how to fix
> this error and if you know anything about it would you please share?
> Thanks|||You have a network issue - you'd want to start by monitoring
the network activity to find out what the issue is. The
following article explains how to setup network monitoring:
How to use Network Monitor to capture network traffic
http://support.microsoft.com/?id=812953
-Sue
On Fri, 30 Mar 2007 12:06:01 -0700, Zvonimir Bilic
<cezar@.hotmail.com> wrote:
>Anyone?
>"Zvonimir Bilic" wrote:
>> Hello,
>> I keep getting these errors in Event Log.
>> Source: MSSQLSERVER
>> A fatal error occurred while reading the input stream from the network. The
>> session will be terminated.
>> For more information, see Help and Support Center at
>> http://go.microsoft.com/fwlink/events.asp.
>> Has anyone seen these events? I couldn't find any information on how to fix
>> this error and if you know anything about it would you please share?
>> Thanks