Multiple SQL errors seems to pertain to Sharepoint

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

Data Corruption Issues

Multiple SQL errors seems to pertain to Sharepoint

Author

Topic

blue92lx
Starting Member

3 Posts

Posted - 2011-07-28 : 14:58:33

I'm getting multiple SQL errors on a SBS2008 server. I'm a bit perplexed at it all and don't know where to start, I'm not a SQL or Sharepoint person so that doesn't help. About every 30 minutes the Applications log explodes with a list of SQL errors for:
SQLVDI event id: 1
MSSQLSERVER event id: 3041 and 18210
SQLWRITER event id: 24583
MSSQL$SBSMONITORING event id 3041 and 18210
MSSQL$MICROSOFT##SSEE event id: 3041 and 18210

The 18210 errors for SQLWRITER or MSSQL$MICROSOFT##SSEE are always:
The description for Event ID 18210 from source <SQLWRITER or 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:
The event is always something different. Either pertaining to Backups of some kind or Sharepoint

The MSSQLSERVER and MSSQL$SBSMONITORING 18210 and 3041 errors are these:
18210 - BackupVirtualDeviceFile::SendFileInfoBegin: failure on backup device '{A9AE340F-5DC5-4061-A4E8-B5A21AD3FC99}3'. Operating system error 995(The I/O operation has been aborted because of either a thread exit or an application request.).
3041 - BACKUP failed to complete the command BACKUP DATABASE <model, report server, master, SBSMonitoring, msdb, etc> . Check the backup application log for detailed messages.

SQLWRITER event id 24583 is always somethign to this effect:
The description for Event ID 24583 from source SQLWRITER 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:
ICommandText::Execute
0x80040e14
SQLSTATE: 42000, Native Error: 3013
Error state: 1, Severity: 16
Source: Microsoft SQL Server Native Client 10.0
Error message: BACKUP DATABASE is terminating abnormally.
SQLSTATE: 42000, Native Error: 3271
Error state: 1, Severity: 16
Source: Microsoft SQL Server Native Client 10.0
Error message: A nonrecoverable I/O error occurred on file "{F45C634B-B3E8-412F-AF89-1A6C64761698}8:" 995(The I/O operation has been aborted because of either a thread exit or an application request.).
SQLSTATE: 01000, Native Error: 4035
Error state: 1, Severity: 0
Source: Microsoft SQL Server Native Client 10.0
Error message: Processed 0 pages for database 'master', file 'master' on file 1.

the message resource is present but the message is not found in the string/message table

And finally the SQLVDI event id 1:
SQLVDI: Loc=TriggerAbort. Desc=invoked. ErrorCode=(0). Process=3444. Thread=11172. Server. Instance=MICROSOFT##SSEE. VD=Global\{F45C634B-B3E8-412F-AF89-1A6C64761698}7_SQLVDIMemoryName_0.

There are SceCli warnings event id 1202 pertaining to GPO permissions. The users are MSSQLFDLauncher, SQLSERVERAGENT, and MSSQLSERVER.

And finally the Sharepoint errors are

Event id 3760 - SQL Database 'ShareWebDb' on SQL Server instance 'LAW-SERVER\Microsoft##SSEE' not found. Additional error information from SQL Server is included below.
Cannot open database "ShareWebDb" requested by the login. The login failed.

Event id 5215 - Unable to connect to database. Check database connection information and make sure the database server is running.

Event Id 6398 - The Execute method of job definition Microsoft.SharePoint.Administration.SPImmediateAlertsJobDefinition (ID 2ffbbc12-3b56-4abf-80d8-3c669644e270) threw an exception. More information is included below.

Unable to connect to database. Check database connection information and make sure the database server is running.

I hope I didn’t just destroy your brains because I don’t even know where to start with this one. They have been getting intermittent slow downs on the network with a program called Client Profiles which uses SQL and these are the only errors in the logs. I can’t find anything else that would cause slow downs over the network.

Thanks,
Adam

blue92lx
Starting Member

3 Posts

Posted - 2011-08-02 : 15:08:17

SQL issues was due to an admin user that was only listed as public permissions and also not listed to the correct DB.

SceCli was easy enough to fix, just had to find the GPO that the incorrect users were in, I followed the procedure listed in the error log itself and got that taken care of.

Sharepoint I'm working on when I have the chance, but the errors are apparently not critical so it's not a huge rush.

It's really nice to not see my event logs filled with red x's though that's for sure.

3magic
Starting Member

14 Posts

Posted - 2011-08-25 : 05:32:54

But in my case i want to understand how the Sharepoint Site and SQL server 2005 works simultanously.....need to know he workflow .I too am interested in hearing a solution to this problem.

3magic
Starting Member

14 Posts

Posted - 2011-08-25 : 05:34:01

But in my case i want to understand how the Sharepoint Site and SQL server 2005 works simultanously.....need to know he workflow .

blue92lx
Starting Member

3 Posts

Posted - 2011-08-25 : 08:47:09

I'm not sure right now how they work together, actually I'm going to be learning about Sharepoint soon. I still haven't had time to fix the sharepoint crawl issue though, but it doesn't seem to be affecting anything so it's not on my priority list.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources