MSSQL$MICROSOFT##SSEE The description for Event ID 2803 from source MSSQL$MICROSOFT##SSEE cannot be found
I am getting the following FOUR messages being written to the Application event log every 5 minutes:
Log Name: Application
Source: MSSQL$MICROSOFT##SSEE
Date: 28/08/2010 7:39:58 AM
Event ID: 2803
Task Category: (2)
Level: Information
Keywords: Classic
User: N/A
Computer: TMGS02.TheMineraGroup.loca
Description:
The description for Event ID 2803 from source MSSQL$MICROSOFT##SSEE cannot be found. Either the component that raises this event is not installed on your local computer or the installation is corrupted. You can install or repair the component on the local computer.
If the event originated on another computer, the display information had to be saved with the event.
The following information was included with the event:
2
Object Plans
The specified resource type cannot be found in the image file
Event Xml:
<Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
<System>
<Provider Name="MSSQL$MICROSOFT##SSE
<EventID Qualifiers="16384">2803</E
<Level>4</Level>
<Task>2</Task>
<Keywords>0x80000000000000
<TimeCreated SystemTime="2010-08-27T21:
<EventRecordID>37379</Even
<Channel>Application</Chan
<Computer>TMGS02.TheMinera
<Security />
</System>
<EventData>
<Data>2</Data>
<Data>Object Plans</Data>
<Binary>F30A00000A00000017
</EventData>
</Event>
Log Name: Application
Source: MSSQL$MICROSOFT##SSEE
Date: 28/08/2010 7:39:58 AM
Event ID: 2803
Task Category: (2)
Level: Information
Keywords: Classic
User: N/A
Computer: TMGS02.TheMineraGroup.loca
Description:
The description for Event ID 2803 from source MSSQL$MICROSOFT##SSEE cannot be found. Either the component that raises this event is not installed on your local computer or the installation is corrupted. You can install or repair the component on the local computer.
If the event originated on another computer, the display information had to be saved with the event.
The following information was included with the event:
2
SQL Plans
The specified resource type cannot be found in the image file
Event Xml:
<Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
<System>
<Provider Name="MSSQL$MICROSOFT##SSE
<EventID Qualifiers="16384">2803</E
<Level>4</Level>
<Task>2</Task>
<Keywords>0x80000000000000
<TimeCreated SystemTime="2010-08-27T21:
<EventRecordID>37380</Even
<Channel>Application</Chan
<Computer>TMGS02.TheMinera
<Security />
</System>
<EventData>
<Data>2</Data>
<Data>SQL Plans</Data>
<Binary>F30A00000A00000017
</EventData>
</Event>
Log Name: Application
Source: MSSQL$MICROSOFT##SSEE
Date: 28/08/2010 7:39:58 AM
Event ID: 2803
Task Category: (2)
Level: Information
Keywords: Classic
User: N/A
Computer: TMGS02.TheMineraGroup.loca
Description:
The description for Event ID 2803 from source MSSQL$MICROSOFT##SSEE cannot be found. Either the component that raises this event is not installed on your local computer or the installation is corrupted. You can install or repair the component on the local computer.
If the event originated on another computer, the display information had to be saved with the event.
The following information was included with the event:
2
Bound Trees
The specified resource type cannot be found in the image file
Event Xml:
<Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
<System>
<Provider Name="MSSQL$MICROSOFT##SSE
<EventID Qualifiers="16384">2803</E
<Level>4</Level>
<Task>2</Task>
<Keywords>0x80000000000000
<TimeCreated SystemTime="2010-08-27T21:
<EventRecordID>37381</Even
<Channel>Application</Chan
<Computer>TMGS02.TheMinera
<Security />
</System>
<EventData>
<Data>2</Data>
<Data>Bound Trees</Data>
<Binary>F30A00000A00000017
</EventData>
</Event>
Log Name: Application
Source: MSSQL$MICROSOFT##SSEE
Date: 28/08/2010 7:40:28 AM
Event ID: 17137
Task Category: (2)
Level: Information
Keywords: Classic
User: NETWORK SERVICE
Computer: TMGS02.TheMineraGroup.loca
Description:
The description for Event ID 17137 from source MSSQL$MICROSOFT##SSEE cannot be found. Either the component that raises this event is not installed on your local computer or the installation is corrupted. You can install or repair the component on the local computer.
If the event originated on another computer, the display information had to be saved with the event.
The following information was included with the event:
SharePoint_AdminContent_d4
The specified resource type cannot be found in the image file
Event Xml:
<Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
<System>
<Provider Name="MSSQL$MICROSOFT##SSE
<EventID Qualifiers="16384">17137</
<Level>4</Level>
<Task>2</Task>
<Keywords>0x80000000000000
<TimeCreated SystemTime="2010-08-27T21:
<EventRecordID>37382</Even
<Channel>Application</Chan
<Computer>TMGS02.TheMinera
<Security UserID="S-1-5-20" />
</System>
<EventData>
<Data>SharePoint_AdminCont
<Binary>F14200000A00000017
</EventData>
</Event>
Whilst only information type message I would like to solve the problem so the logs are much smaller.
Can anyone assist ?
Log Name: Application
Source: MSSQL$MICROSOFT##SSEE
Date: 28/08/2010 7:39:58 AM
Event ID: 2803
Task Category: (2)
Level: Information
Keywords: Classic
User: N/A
Computer: TMGS02.TheMineraGroup.loca
Description:
The description for Event ID 2803 from source MSSQL$MICROSOFT##SSEE cannot be found. Either the component that raises this event is not installed on your local computer or the installation is corrupted. You can install or repair the component on the local computer.
If the event originated on another computer, the display information had to be saved with the event.
The following information was included with the event:
2
Object Plans
The specified resource type cannot be found in the image file
Event Xml:
<Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
<System>
<Provider Name="MSSQL$MICROSOFT##SSE
<EventID Qualifiers="16384">2803</E
<Level>4</Level>
<Task>2</Task>
<Keywords>0x80000000000000
<TimeCreated SystemTime="2010-08-27T21:
<EventRecordID>37379</Even
<Channel>Application</Chan
<Computer>TMGS02.TheMinera
<Security />
</System>
<EventData>
<Data>2</Data>
<Data>Object Plans</Data>
<Binary>F30A00000A00000017
</EventData>
</Event>
Log Name: Application
Source: MSSQL$MICROSOFT##SSEE
Date: 28/08/2010 7:39:58 AM
Event ID: 2803
Task Category: (2)
Level: Information
Keywords: Classic
User: N/A
Computer: TMGS02.TheMineraGroup.loca
Description:
The description for Event ID 2803 from source MSSQL$MICROSOFT##SSEE cannot be found. Either the component that raises this event is not installed on your local computer or the installation is corrupted. You can install or repair the component on the local computer.
If the event originated on another computer, the display information had to be saved with the event.
The following information was included with the event:
2
SQL Plans
The specified resource type cannot be found in the image file
Event Xml:
<Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
<System>
<Provider Name="MSSQL$MICROSOFT##SSE
<EventID Qualifiers="16384">2803</E
<Level>4</Level>
<Task>2</Task>
<Keywords>0x80000000000000
<TimeCreated SystemTime="2010-08-27T21:
<EventRecordID>37380</Even
<Channel>Application</Chan
<Computer>TMGS02.TheMinera
<Security />
</System>
<EventData>
<Data>2</Data>
<Data>SQL Plans</Data>
<Binary>F30A00000A00000017
</EventData>
</Event>
Log Name: Application
Source: MSSQL$MICROSOFT##SSEE
Date: 28/08/2010 7:39:58 AM
Event ID: 2803
Task Category: (2)
Level: Information
Keywords: Classic
User: N/A
Computer: TMGS02.TheMineraGroup.loca
Description:
The description for Event ID 2803 from source MSSQL$MICROSOFT##SSEE cannot be found. Either the component that raises this event is not installed on your local computer or the installation is corrupted. You can install or repair the component on the local computer.
If the event originated on another computer, the display information had to be saved with the event.
The following information was included with the event:
2
Bound Trees
The specified resource type cannot be found in the image file
Event Xml:
<Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
<System>
<Provider Name="MSSQL$MICROSOFT##SSE
<EventID Qualifiers="16384">2803</E
<Level>4</Level>
<Task>2</Task>
<Keywords>0x80000000000000
<TimeCreated SystemTime="2010-08-27T21:
<EventRecordID>37381</Even
<Channel>Application</Chan
<Computer>TMGS02.TheMinera
<Security />
</System>
<EventData>
<Data>2</Data>
<Data>Bound Trees</Data>
<Binary>F30A00000A00000017
</EventData>
</Event>
Log Name: Application
Source: MSSQL$MICROSOFT##SSEE
Date: 28/08/2010 7:40:28 AM
Event ID: 17137
Task Category: (2)
Level: Information
Keywords: Classic
User: NETWORK SERVICE
Computer: TMGS02.TheMineraGroup.loca
Description:
The description for Event ID 17137 from source MSSQL$MICROSOFT##SSEE cannot be found. Either the component that raises this event is not installed on your local computer or the installation is corrupted. You can install or repair the component on the local computer.
If the event originated on another computer, the display information had to be saved with the event.
The following information was included with the event:
SharePoint_AdminContent_d4
The specified resource type cannot be found in the image file
Event Xml:
<Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
<System>
<Provider Name="MSSQL$MICROSOFT##SSE
<EventID Qualifiers="16384">17137</
<Level>4</Level>
<Task>2</Task>
<Keywords>0x80000000000000
<TimeCreated SystemTime="2010-08-27T21:
<EventRecordID>37382</Even
<Channel>Application</Chan
<Computer>TMGS02.TheMinera
<Security UserID="S-1-5-20" />
</System>
<EventData>
<Data>SharePoint_AdminCont
<Binary>F14200000A00000017
</EventData>
</Event>
Whilst only information type message I would like to solve the problem so the logs are much smaller.
Can anyone assist ?
This may be helpful - http://social.msdn.microsoft.com/Forums/en-US/sqldatabaseengine/thread/0b3a2163-929f-4ba6-8e74-3d683aea19f1
Have you got management studio on the server?
http://www.microsoft.com/downloads/details.aspx?FamilyId=C243A5AE-4BD1-4E3D-94B8-5A0F62BF7796&displaylang=en
Also, to connect to the MSSQL$MICROSOFT##SSEE instance can be tricky. Try this in the server field - np:\\.\pipe\MSSQL$Microsof
But the article at the top also discusses protocol settings
Have you got management studio on the server?
http://www.microsoft.com/downloads/details.aspx?FamilyId=C243A5AE-4BD1-4E3D-94B8-5A0F62BF7796&displaylang=en
Also, to connect to the MSSQL$MICROSOFT##SSEE instance can be tricky. Try this in the server field - np:\\.\pipe\MSSQL$Microsof
But the article at the top also discusses protocol settings
ASKER
Cliff,
The events are not being viewed remotely. This is the eventvwr information shown when signed onto the server itself using RDP.
I should also mention - This is a newly installed Small Business Server 2008 - just migrated from 2003 to 2008 on a new server.
Regards
Michael
The events are not being viewed remotely. This is the eventvwr information shown when signed onto the server itself using RDP.
I should also mention - This is a newly installed Small Business Server 2008 - just migrated from 2003 to 2008 on a new server.
Regards
Michael
ASKER
ebooyens,
I can confirm Microsoft SQL Server Management Studio Express is installed on the server.
I was able to connect to the Sharepoint / SUSDB instance with the Connect string you provided (which I've used before).
Re the first link you provided - if I'm reading this thread correctly the auto-close option didn't solve the problem ??????
Can you please advise exactly what you think the solution is to these 'error messages about not being able to display error messages' ?
I can confirm Microsoft SQL Server Management Studio Express is installed on the server.
I was able to connect to the Sharepoint / SUSDB instance with the Connect string you provided (which I've used before).
Re the first link you provided - if I'm reading this thread correctly the auto-close option didn't solve the problem ??????
Can you please advise exactly what you think the solution is to these 'error messages about not being able to display error messages' ?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I can confirm:
1. The 'Sharepoint Services Data' was moved immediately after installation from C: to E: drie
2. Companyweb and Sharepoint Central Admin seem to be working correctly
3. Sharepoint was NOT migrated from the previous SBS2003 server as the customer did not use it but now wants to.
so what would you suggest as the first step ?
1. The 'Sharepoint Services Data' was moved immediately after installation from C: to E: drie
2. Companyweb and Sharepoint Central Admin seem to be working correctly
3. Sharepoint was NOT migrated from the previous SBS2003 server as the customer did not use it but now wants to.
so what would you suggest as the first step ?
SGSmikeG, It's very hard to try and address an issue that isn't defined as your event isn't coming through with specifics of what's going wrong, assuming something is wrong as opposed to just logging information. I appreciate you're trying to be a purist in terms of addressing anything suspicious in the event viewer but personally I wouldn't spend any more time on this.
If you're adamant that you'd like to get rid of the event then you will be forced to assume something is wrong somewhere although you barely have any idea what it is, so working through the article above to repair or essentially set up SharePoint from scratch.
If you really want to go to that effort then maybe it's worth going to SharePoint 2010 to at least get some benefit from it - strip off SharePoint, install SQL 2008 Express with Advanced Tools on the server, then install SharePoint 2010 Foundation and make sure to use that instance, not SSEE. That way you know the event above has nothing to do with SharePoint and you've taken them to the latest version to get started with and you're in control of the new instance. In time you can move the WSUS database to the new instance as well and disable the SSEE instance. Surely that's got to get rid of the event. Is it worth it though? Your call.
If you're adamant that you'd like to get rid of the event then you will be forced to assume something is wrong somewhere although you barely have any idea what it is, so working through the article above to repair or essentially set up SharePoint from scratch.
If you really want to go to that effort then maybe it's worth going to SharePoint 2010 to at least get some benefit from it - strip off SharePoint, install SQL 2008 Express with Advanced Tools on the server, then install SharePoint 2010 Foundation and make sure to use that instance, not SSEE. That way you know the event above has nothing to do with SharePoint and you've taken them to the latest version to get started with and you're in control of the new instance. In time you can move the WSUS database to the new instance as well and disable the SSEE instance. Surely that's got to get rid of the event. Is it worth it though? Your call.
Thanks for the points SGSMikeG
Hi SGSMikeG,
I had the same problem on 3 different servers, after moving the Sharepoint Services Data. The solution is to start SQL Server Management Studio Express as administrator. Connect to the database \\.\pipe\MSSQL$MICROSOFT##
After connection edit the properties of every database an change the value "auto close" to "false". After a server restart this solved my problems.
I had the same problem on 3 different servers, after moving the Sharepoint Services Data. The solution is to start SQL Server Management Studio Express as administrator. Connect to the database \\.\pipe\MSSQL$MICROSOFT##
After connection edit the properties of every database an change the value "auto close" to "false". After a server restart this solved my problems.
View the event from the console and you'll know more about the event, and if you *still* need help fixing it, you can post back here and we can better assist.
-Cliff