January 14, 2014 at 2:25 am
So i finally got to install my first SQL 2012 server, but unfortunately the project was very pressed for time so i had very little time to prep for it, the end result was a Virtual Machine, Windows 2012 and SQL Server 2012 without a service account, using the local system instead...
Before you know it, its grown from a simple demo environment to an actual development environment and now they want me to back it up...
but netbackup wont work, it didnt have access to any of the databases
googled that for a bit and the most common reply was to change to a service account that was in the domain.
so i did that, using the sql server configuration manager, the new account is also an administrator on the local computer.
Still getting problems with netbackup though, with 2 different error messages:
For Master and MSDB i get:
SQL Message <262><[Microsoft][ODBC SQL Server Driver][SQL Server]BACKUP DATABASE permission denied in database 'master'.>.
For Model and the user databases i get:
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.>.
Any thoughts?
January 14, 2014 at 3:23 am
Never mind, i solved it
turns out that SQL 2012 soes not give the SA role to NT AUTHORITY\SYSTEM group but SQL 2008 does, and since netbackup is using the local system account, i added the SA role to that group.
January 14, 2014 at 10:21 am
Thanks for this, I have an upcoming SQL 2012 install using Netbackup and would have hit the same problem 🙂
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply