VSS 1063 error points to logon failure, but how to fix???

[T_J]

Message: Sqllib error: OLEDB Error encountered calling IDBInitialize::Initialize. hr =
0x80040e4d. SQLSTATE: 42000, Native Error: 18456
Error state: 1, Severity: 14
Source: Microsoft OLE DB Provider for SQL Server
Error message: Login failed for user 'NT AUTHORITY\SYSTEM'.


Data: - Code: SQLCONNC00000491- Call: SQLCONNC00000397- PID: 00005928- TID: 00001348- CMD: C:\WINNT\System32\vssvc.exe - User: NT AUTHORITY\SYSTEM - Sid: S-1-5-18


'vssadmin list writers' returns (during a backup)

vssadmin 1.1 - Volume Shadow Copy Service administrative command-line tool
(C) Copyright 2001 Microsoft Corp.

Writer name: 'System Writer'
Writer Id: {e8132975-6f93-4464-a53e-1050253ae220}
Writer Instance Id: {4e6d6b3b-91c8-49fc-ad18-e5a449307fc6}
State: Waiting for completion
Last error: No error

Writer name: 'Event Log Writer'
Writer Id: {eee8c692-67ed-4250-8d86-390603070d00}
Writer Instance Id: {ecbdccb2-7457-4b5d-9b86-c867d18df162}
State: Waiting for completion
Last error: No error

Writer name: 'WMI Writer'
Writer Id: {a6ad56c2-b509-4e6c-bb19-49d8f43532f0}
Writer Instance Id: {e909d7ce-e166-44c9-b461-aad7e65430a1}
State: Waiting for completion
Last error: No error

Writer name: 'FRS Writer'
Writer Id: {d76f5a28-3092-4589-ba48-2958fb88ce29}
Writer Instance Id: {ada739d5-de60-45c6-8a0d-279049a43d5c}
State: Waiting for completion
Last error: No error

Writer name: 'Dhcp Jet Writer'
Writer Id: {be9ac81e-3619-421f-920f-4c6fea9e93ad}
Writer Instance Id: {67cc2a9d-099d-4977-bf33-01f01529bebe}
State: Waiting for completion
Last error: No error

Writer name: 'COM+ REGDB Writer'
Writer Id: {542da469-d3e1-473c-9f4f-7847f01fc64f}
Writer Instance Id: {c525a687-1def-4c5b-a0f3-e15376a6e86e}
State: Waiting for completion
Last error: No error

Writer name: 'Registry Writer'
Writer Id: {afbab4a2-367d-4d15-a586-71dbb18f8485}
Writer Instance Id: {b4c1d6a9-fdde-4535-91f8-d583145b9ade}
State: Waiting for completion
Last error: No error

Writer name: 'NTDS'
Writer Id: {b2014c9e-8711-4c5c-a5a9-3cf384484757}
Writer Instance Id: {44537eec-6408-4f4b-aa87-413222dcc418}
State: Waiting for completion
Last error: No error

Writer name: 'IIS Metabase Writer'
Writer Id: {59b1f0cf-90ef-465f-9609-6ca8b2938366}
Writer Instance Id: {0f70acf0-d1f8-45c0-b03b-4a45890ab017}
State: Waiting for completion
Last error: No error

Writer name: 'WINS Jet Writer'
Writer Id: {f08c1483-8407-4a26-8c26-6c267a629741}
Writer Instance Id: {9414bb0c-8a38-4332-a6f9-cd0ed61caee0}
State: Waiting for completion
Last error: No error

Writer name: 'Certificate Authority'
Writer Id: {6f5b15b5-da24-4d88-b737-63063e3a1f86}
Writer Instance Id: {40a86100-4ee8-41da-9e8b-7caea21647ee}
State: Waiting for completion
Last error: No error

I see that the error points to a logon failure, which should somehow be fixed I would think in SQL, but I need to know step by step how to take care of this, and cannot find any suggestions anywhere.

[Sharvari_Deshmu]

Hello,

Please see the microsoft article to resolve the issue:

The logon failure error is generated by VSS, and should be resolved by following Microsoft's recommendations in the following knowledge base article: The article details a VSS update package that is available from Microsoft


http://support.microsoft.com/?KBID=833167


Thanks,

NOTE : If we do not receive your reply within two business days, this post would be marked assumed answered and would be moved to answered questions pool.

[T_J]

KBid=833167 only seems to refer to Systems Pre Service Pack 1. I recieved the hotfix from PSS and it refused to install saying that the Service Pack installed was after that point. I called them again and got thrown to per incident queue.
AJ

[T_J]

Built In windows backup was able to backup the entire machine with no errors. As I stated above this machine has SP1 so there is no hotfix available to me.

[shweta_rege]

Hello,

- Do you receive this error while backing up SQL databases?

- Run a system state backup with NTBackup and find out if these errors are reported again.


******************************************************************


******************************************************************
*****************************************************************

Note : If we do not receive your reply within two business days, this post would be marked ‘assumed answered’ and would be moved to ‘answered questions’ pool.


Thank You