Groups | Blog | Home
all groups > sql server msde > august 2006 >

sql server msde : Error 18456


Jens
8/28/2006 9:27:34 AM
Seems like the backup service is just running under the system service
account which is not priviledged by default in SQL Server. So you
either 1. have to authorize the service account in SQL Server (which is
not preferable) or use a dedicated service accont for the backup
service or 2. provide a SQL Server account (if you have SQL Server
authentication enabled at your server) to your backup software (if that
is supported by it.

HTH, Jens Suessmeyer.

---
http://www.sqlserver2005.de
---
Patrick Pavlan
8/28/2006 4:49:21 PM
I have a recurring problem. It comes up every time my backup starts on both
of my servers -Mainserver and Terminal server. Both have MSDE installed. We
use Windows server 2003 and EMC Retrospect with open file backup. However,
we do not have any SQL agent. We backup MSDE databases to the Backup foolder
with a solution provided with our propriatary software. Then we just backup
the Backup folder. Every night when the Retrospect backup starts I get a
bunch of messages:
Even source: VSS
Event ID: 6013
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'.

Thank you in advance.

Patrick

AddThis Social Bookmark Button