troubleshooting Question

How to resolve Event ID 33002

Avatar of gtrapp
gtrapp asked on
Microsoft SQL Server 2005Microsoft SharePoint
1 Comment1 Solution2072 ViewsLast Modified:
Hello,

In the event log, I see:

Event Type:      Error
Event Source:      MSSQL$MICROSOFT##SSEE
Event Category:      (2)
Event ID:      33002
Computer:      CHINOOK
Description:
The description for Event ID ( 33002 ) in Source ( MSSQL$MICROSOFT##SSEE ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following information is part of the event: table, dbo.backupset.

In SQL Mangement Studio, I right-click on the properties of any of the SharePoint database names, and I see the following error message box that says:

Cannot show requested dialog.
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
Access to table dbo.backupset is blocked because the signature is not valid. (Microsoft SQL Server, Error: 33002)

These are SharePoint 3.0 databases and I am using SQL Server 2005 Mangement Studio on Windows Server 2003. Can you explain why this error occurs and how I can fix them?

Thanks,
ASKER CERTIFIED SOLUTION
Paul Jackson
Software Engineer

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Top Expert 2011

The Distinguished Expert awards are presented to the top veteran and rookie experts to earn the most points in the top 50 topics.

Join our community to see this answer!
Unlock 1 Answer and 1 Comment.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 1 Comment.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros