Category Archives: amazon

amazon

[DBMS-MSSQL:11006#916] The server principal “NT AUTHORITY\SYSTEM” is not able to access the database under the current security context

amazon, security, sqlbackupandftp

If you encounter the error message:

[DBMS-MSSQL:11006#916] The server principal "NT AUTHORITY\SYSTEM" is not able to access the database <database-name> under the current security context

you will find the solution below:

Go to the “SQL Server” sections and click on the gear button. At the opened “Connect to Server” window you need to select “Microsoft SQ: Server (local) as your Server type, choose “Windows Authentication” and enter User Name and Password. Press “Test Connection” to make sure that you have specified the correct data and then click on “Save & Close” to save and apply new settings. Continue reading [DBMS-MSSQL:11006#916] The server principal “NT AUTHORITY\SYSTEM” is not able to access the database under the current security context →

Set Amazon S3 access policy to minimum permission

amazon, SQL Server, sqlbackupandftp, , , ,
Amazon S3 access policy to minimum permission
Due to security reasons, most admins will prefer to create accounts for any system with minimum privileges.
So now you might wonder how to create a user for Amazon S3 service that has minimum permissions in order to backup databases with SQLBackupAndFTP in a certain bucket and folder? It’s quite easy…

Continue reading Set Amazon S3 access policy to minimum permission →