SQL 2014 Cloud Backups Part 4

Once the azure storage objects are created we need to configure a credential within SQL Server in order to allow SQL Server to securely access the cloud container.

The below script creates the credential that will be used

CREATE CREDENTIAL Azureblobbackups

WITH IDENTITY= 'ebsclouddbstore'
, SECRET = 'JsckzW.... put the primary access key here'

 

Credentials are a great way to ensure security but also little known. IF you interested please read more about credentials here.