I've discovered that my SQL 2005 server is getting the following error whenever it runs a backup.
Event Type: Error
Event Source: SQLWRITER
Event Category: None
Event ID: 24583
Time: 1:14:50 PM
Computer: <computer name>
Sqllib error: OLEDB Error encountered calling IDBInitialize::Initialize.
hr = 0x80040e4d. SQLSTATE: 28000, Native Error: 18456
Error state: 1, Severity: 14
Source: Microsoft SQL Native Client
Error message: Login failed for user 'NT AUTHORITY\SYSTEM'.
DBPROP_INIT_DATASOURCE: <computer name>\<database>
With the help of MS KB919023 http://support.microsoft.com/kb/919023
I am able to consistently replicate the issue by running the command: 'vssadmin list writers'
When I run the vssadmin command, it does not have an entry for SqlServerWriter at all. I believe that this may be a permissions issue, and that what I need to to is explictly add the NT AUTHORITY\SYSTEM account to the SQL Server.
However... while I'm comfortable with servers, I am not comfortable with SQL 2005. I don't know how to explictly add the NT AUTHORITY\ SYSTEM account to the SQL server. This is also a sensitive production server, so I'm trying to tread as lightly as possible.
Does this course of action sound correct? Can someone please explain how to add an account to SQL Server?