Posted - 01/21/2014 : 19:23:15
| USE SSISDB;
OPEN MASTER KEY DECRYPTION BY PASSWORD = 'OurPassword1';
BACKUP MASTER KEY TO FILE = 'G:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DBMasterkeyBackups'
ENCRYPTION BY PASSWORD = 'OurPassword1'
Msg 15240, Level 16, State 4, Line 3
Cannot write into file 'G:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DBMasterkeyBackups'. Verify that you have write permissions, that the file path is valid, and that the file does not already exist.
The SQL Server 2012 service account has full access to drive G:
My windows login has full access to drive G:
My windows account is a SYSADMIN.
NTFS permissions for both above accounts ok.
Has to be a bug!
Email ; JAMES.BIRD@SA.GOV.AU