This post is more than 5 years old
1 Rookie
•
84 Posts
0
12310
January 2nd, 2013 21:00
SQL Backup error
Hi Guys,
I have issue with 4 of our new SQL backup. I'm NMM 2.4 to backup SQL and i'm getting below error message. Anyone seen this error before?
38006 1357189513 5 0 0 5828 5920 0 ch00sdf3 (pid5920) 3 %s. 1 24 121 The server principal "NT AUTHORITY\SYSTEM" is not able to access the database "model" under the current security context.
37938 1357189513 5 0 0 5828 5920 0 ch00sdf3 (pid5920) 35 Failed to obtain filegroups for %s. 1 0 5 model
29085 1357189513 5 0 0 2940 5920 0 ch00sdf3 (pid5920) 36 Microsoft SQL Server Provider error: 0
38006 1357189513 5 0 0 2940 5920 0 ch00sdf3 (pid5920) 3 %s. 1 24 55 BACKUP DATABASE permission denied in database 'master'.
38006 1357189513 5 0 0 2940 5920 0 ch00sdf3 (pid5920) 3 %s. 1 24 42 BACKUP DATABASE is terminating abnormally.
29282 1357189513 5 0 0 5828 5920 0 ch00sdf3 (pid5920) 31 \nBackup/Recover command failed 0
53084 1357189513 5 0 0 5828 5920 0 ch00sdf3 (pid5920) 47 Processing %s failed, the item will be skipped. 1 0 6 master
29085 1357189513 5 0 0 5828 5920 0 ch00sdf3 (pid5920) 36 Microsoft SQL Server Provider error: 0
38006 1357189513 5 0 0 5828 5920 0 ch00sdf3 (pid5920) 3 %s. 1 24 121 The server principal "NT AUTHORITY\SYSTEM" is not able to access the database "model" under the current security context.
37958 1357189513 5 0 0 5828 5920 0 ch00sdf3 (pid5920) 30 Execute DB command <%s> failed 1 0 39 SELECT sum(size) FROM [model]..sysfiles
29085 1357189513 5 0 0 4660 5920 0 ch00sdf3 (pid5920) 36 Microsoft SQL Server Provider error: 0
38006 1357189513 5 0 0 4660 5920 0 ch00sdf3 (pid5920) 3 %s. 1 24 121 The server principal "NT AUTHORITY\SYSTEM" is not able to access the database "model" under the current security context.
38006 1357189513 5 0 0 4660 5920 0 ch00sdf3 (pid5920) 3 %s. 1 24 42 BACKUP DATABASE is terminating abnormally.
29282 1357189513 5 0 0 5828 5920 0 ch00sdf3 (pid5920) 31 \nBackup/Recover command failed 0
53084 1357189513 5 0 0 5828 5920 0 ch00sdf3 (pid5920) 47 Processing %s failed, the item will be skipped. 1 0 5 model
29085 1357189513 5 0 0 5064 5920 0 ch00sdf3 (pid5920) 36 Microsoft SQL Server Provider error: 0
38006 1357189513 5 0 0 5064 5920 0 ch00sdf3 (pid5920) 3 %s. 1 24 53 BACKUP DATABASE permission denied in database 'msdb'.
38006 1357189513 5 0 0 5064 5920 0 ch00sdf3 (pid5920) 3 %s. 1 24 42 BACKUP DATABASE is terminating abnormally.
29282 1357189513 5 0 0 5828 5920 0 ch00sdf3 (pid5920) 31 \nBackup/Recover command failed 0
53084 1357189513 5 0 0 5828 5920 0 ch00sdf3 (pid5920) 47 Processing %s failed, the item will be skipped. 1 0 4 msdb
43709 1357189514 1 0 0 5828 5920 0 ch00sdf3 (pid5920) 13 Stop time: %s 1 35 25 Thu Jan 03 06:05:14 2013
Attached is the nsrsqlsv and nmm.raw log files
mgennacc
13 Posts
2
January 7th, 2013 11:00
Please note:
You are running SQL Server 2012
920) Computer Name: CH00SDF3 User Name: SYSTEM
2013-01-03 12:05:11 AM 1 0 0 5828 5920 0 ch00sdf3 (pid5920) System Version: 6.1 Build 7601 S
2013-01-03 12:05:11 AM 1 0 0 5828 5920 0 ch00sdf3 (pid5920) Microsoft Data Access Component(MDAC) version: 6.1.7601.17514
2013-01-03 12:05:11 AM 1 0 0 5828 5920 0 ch00sdf3 (pid5920) Microsoft SQL Server version (from registry) : 11.0.2100.60
2013-01-03 12:05:11 AM 1 0 0 5828 5920 0 ch00sdf3 (pid5920) Local host has following SQL Server online:
2013-01-03 12:05:11 AM 1 0 0 5828 5920 0 ch00sdf3 (pid5920) MSSQL server : CH00SDF3
NOTES:
Microsoft changed the security privileges of SQL Server 2012 such that
-- previous versions allowed local SYSTEM account sysadmin role automatically in SQL Server.
-- Version 2012 no longer allows SYSTEM account any role at all
-- therefore no sysadmin or any access to any databases
-- as a result, any process trying to connect to SQL
with SYSTEM account to run commands that requiressysadmin privlieges - such as backup -- will fail.
Eg.
2013-01-03 12:05:13 AM 5 0 0 5828 5920 0 ch00sdf3 (pid5920) Microsoft SQL Server Provider error:
2013-01-03 12:05:13 AM 5 0 0 5828 5920 0 ch00sdf3 (pid5920) The server principal "NT AUTHORITY\SYSTEM" is not able to access the database "model" under the current security context..
Solution:
-- make sure at least one domain account (eg. sqlsvc) has SQL Server sysadmin role granted
-- run the backup such that one of the following is true:
a) nsrexecd service on SQL Server runs as the domain account (sqlsvc)
b) or the nsrexecd runs as SYSTEM account (by default) but the
client resource for the SQL Server runs as domain\sqlsvc
NOTES
a) will definitely work.
b) has had issues with SQL 2012 - if you have issues use a)
and check if you are using mirroring or Availability Groups
Bebo2k
544 Posts
0
January 3rd, 2013 19:00
Hi Iman,
Your database user does not have permissions to backup its database. It is likely that the SQL Backup Agent service for the server has been configured to use a Local System Account.Modify the Login account for the SQL Backup Agent service to use a Windows Authenticated account that has Sysadmin privileges on the SQL Server.
To set the appropriate permissions in SQL Server Managment Studio
You can involve your SQL DBA in this permission issue as well.
Hope this helps, Waiting your updates.
Ahmed Bahaa