Thursday 2 June 2011

Event 24581, SQLWRITER

Issue

Log Name:   Application
Source:        SQLWRITEREvent ID:     24581
Level:           Error
User:            N/A
Computer:   Description:
Sqllib error:

System table sys.sysdatabases in SQL Server instance  is empty.
Nothing reported in SQL Server error logs.
To reproduce the error, execute vssadmin list writers

Fix
I had removed SQL Server sysadmin permissions from NT AUTHORITY\SYSTEM to enhance security. 

Granting sysadmin to NT AUTHORITY\SYSTEM fixed the problem.

Seems VSS Writer requires sysadmin to work ....  

No comments:

Post a Comment