rookie11
12 years agoModerator
SQL backup problem
Hi experts
SQL 2012 on server WIN 2008. recently added SQL instance. when i tried to run of this it fails give me error.
16> CODBCaccess::LogODBCerr: DBMS MSG - ODBC return code <-1>, SQL State <08004>, SQL Message <916><[Microsoft][ODBC SQL Server Driver][SQL Server]The server principal "NT AUTHORITY\SYSTEM" is not able to access the database "model" under the current security context.>.
i m getting same error for all databases in SQL instance. dbclient logs attached
Change NBU Client Service to user account with sufficient SQL rights.
Best to start NBU service with same logon account as SQL services.