Home
%3CLINGO-SUB%20id%3D%22lingo-sub-664734%22%20slang%3D%22en-US%22%3ETroubleshooting%20BULK%20INSERT%20and%20OPENROWSET%20issues%20on%20Azure%20SQL%20Database%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-664734%22%20slang%3D%22en-US%22%3E%3CP%3EAzure%20SQL%20Database%20(single%20database%20and%20Managed%20Instance)%20enables%20you%20to%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2FAzure-SQL-Database%2FLoading-files-from-Azure-Blob-Storage-into-Azure-SQL-Database%2Fba-p%2F386133%22%20target%3D%22_self%22%3Eload%20files%20from%20Azure%20Blob%20Storage%3C%2FA%3E.%20If%20you%20experience%20some%20issue%20while%20you%20are%20loading%20files%20from%20Azure%20blob%20storage%2C%20here%20you%20can%20find%20the%20actions%20that%20can%20help%20you%20to%20troubleshoot%20and%20mitigate%20the%20issue.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CUL%20style%3D%22box-sizing%3A%20border-box%3B%20margin-top%3A%200px%3B%20margin-bottom%3A%2012px%3B%20padding-left%3A%202.5em%3B%20list-style%3A%20outside%3B%20clear%3A%20left%3B%20color%3A%20%23333333%3B%20font-family%3A%20SegoeUI%2C%20Lato%2C%20'Helvetica%20Neue'%2C%20Helvetica%2C%20Arial%2C%20sans-serif%3B%20font-size%3A%2016px%3B%20font-style%3A%20normal%3B%20font-variant-ligatures%3A%20normal%3B%20font-variant-caps%3A%20normal%3B%20font-weight%3A%20300%3B%20letter-spacing%3A%20normal%3B%20orphans%3A%202%3B%20text-align%3A%20left%3B%20text-indent%3A%200px%3B%20text-transform%3A%20none%3B%20white-space%3A%20normal%3B%20widows%3A%202%3B%20word-spacing%3A%200px%3B%20-webkit-text-stroke-width%3A%200px%3B%20background-color%3A%20%23ffffff%3B%20text-decoration-style%3A%20initial%3B%20text-decoration-color%3A%20initial%3B%22%3E%0A%3CLI%20class%3D%22code-line%20code-line%20code-line%22%20style%3D%22box-sizing%3A%20border-box%3B%20font-family%3A%20SegoeUI%2C%20Lato%2C%20'Helvetica%20Neue'%2C%20Helvetica%2C%20Arial%2C%20sans-serif%3B%22%20data-line%3D%2228%22%3EIf%20you%20are%20noticing%20that%20some%20syntax%20error%20is%20returned%20by%3CCODE%20style%3D%22box-sizing%3A%20border-box%3B%20font-family%3A%20Menlo%2C%20Monaco%2C%20Consolas%2C%20'Courier%20New'%2C%20monospace%3B%20font-size%3A%2014.4px%3B%20padding%3A%202px%204px%3B%20color%3A%20%23c7254e%3B%20background-color%3A%20%23f9f2f4%3B%20border-radius%3A%204px%3B%22%3EBULK%20INSERT%3C%2FCODE%3E%3CSPAN%20style%3D%22box-sizing%3A%20border-box%3B%20font-family%3A%20SegoeUI%2C%20Lato%2C%20'Helvetica%20Neue'%2C%20Helvetica%2C%20Arial%2C%20sans-serif%3B%22%3E%20or%3C%2FSPAN%3E%20%3CCODE%20style%3D%22background-color%3A%20%23f9f2f4%3B%20border-bottom-left-radius%3A%204px%3B%20border-bottom-right-radius%3A%204px%3B%20border-top-left-radius%3A%204px%3B%20border-top-right-radius%3A%204px%3B%20box-sizing%3A%20border-box%3B%20color%3A%20%23c7254e%3B%20font-family%3A%20Menlo%2CMonaco%2CConsolas%2C%26amp%3Bquot%3B%20courier%20new%26amp%3Bquot%3B%2Cmonospace%3B%20font-size%3A%2014.4px%3B%20padding%3A%202px%204px%202px%204px%3B%22%3EBULK%20INSERT%3C%2FCODE%3Echeck%20are%20you%20using%3CSPAN%20style%3D%22box-sizing%3A%20border-box%3B%20font-family%3A%20SegoeUI%2C%20Lato%2C%20'Helvetica%20Neue'%2C%20Helvetica%2C%20Arial%2C%20sans-serif%3B%22%3E%26nbsp%3B%3C%2FSPAN%3E%3CA%20title%3D%22supported%20syntax%20bulk%20insert%20openrowset%22%20style%3D%22box-sizing%3A%20border-box%3B%20background-color%3A%20transparent%3B%20color%3A%20%23146cac%3B%20text-decoration%3A%20underline%3B%22%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fazure%2Fsql-database%2Fsql-database-managed-instance-transact-sql-information%23bulk-insert--openrowset%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Esupported%20syntax%20in%20this%20statement%3C%2FA%3E.%20As%20an%20example%2C%20if%20you%20are%20trying%20to%20load%20data%20via%20network%20share%20path%20note%20that%20this%20option%20is%20not%20supported%20in%20Managed%20Instance.%3C%2FLI%3E%0A%3CLI%20class%3D%22code-line%20code-line%20code-line%22%20style%3D%22box-sizing%3A%20border-box%3B%20font-family%3A%20SegoeUI%2C%20Lato%2C%20'Helvetica%20Neue'%2C%20Helvetica%2C%20Arial%2C%20sans-serif%3B%22%20data-line%3D%2228%22%3EMake%20sure%20that%20you%20are%20restoring%20a%20database%20from%20public%20blob%20storage%20protected%20with%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CA%20style%3D%22box-sizing%3A%20border-box%3B%20background-color%3A%20transparent%3B%20color%3A%20%23146cac%3B%20text-decoration%3A%20underline%3B%22%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fazure%2Fstorage%2Fcommon%2Fstorage-dotnet-shared-access-signature-part-1%3Ftoc%3D%252fazure%252fstorage%252fblobs%252ftoc.json%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3ESAS%20credential%3C%2FA%3E.%20Private%20IPs%20for%20blob%20storage%20and%20service%20endpoints%20are%20currently%20not%20supported.%3C%2FLI%3E%0A%3CLI%20class%3D%22code-line%20code-line%20code-line%22%20style%3D%22box-sizing%3A%20border-box%3B%20font-family%3A%20SegoeUI%2C%20Lato%2C%20'Helvetica%20Neue'%2C%20Helvetica%2C%20Arial%2C%20sans-serif%3B%22%20data-line%3D%2228%22%3EIf%20you%20are%20getting%20the%20error%205%20(Access%20Denied)%2C%20make%20sure%20that%20you%20have%20not%20denied%20the%20access%20to%20your%20Azure%20Blob%20Storage%20account%20using%20the%20firewall%3A%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22box-sizing%3A%20border-box%3B%20font-family%3A%20SegoeUI%2C%20Lato%2C%20'Helvetica%20Neue'%2C%20Helvetica%2C%20Arial%2C%20sans-serif%3B%20display%3A%20inline-block%3B%20max-width%3A%20100%25%3B%20position%3A%20relative%3B%20width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-message-image-wrapper%20lia-message-image-actions-narrow%20lia-message-image-actions-below%22%20style%3D%22box-sizing%3A%20border-box%3B%20font-family%3A%20SegoeUI%2C%20Lato%2C%20'Helvetica%20Neue'%2C%20Helvetica%2C%20Arial%2C%20sans-serif%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F116415i12D12C318CD65A32%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20alt%3D%22Storage%20firewall.png%22%20title%3D%22Storage%20firewall.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FLI%3E%0A%3C%2FUL%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CUL%20style%3D%22box-sizing%3A%20border-box%3B%20margin-top%3A%200px%3B%20margin-bottom%3A%2012px%3B%20padding-left%3A%202.5em%3B%20list-style%3A%20outside%3B%20clear%3A%20left%3B%20color%3A%20%23333333%3B%20font-family%3A%20SegoeUI%2C%20Lato%2C%20'Helvetica%20Neue'%2C%20Helvetica%2C%20Arial%2C%20sans-serif%3B%20font-size%3A%2016px%3B%20font-style%3A%20normal%3B%20font-variant-ligatures%3A%20normal%3B%20font-variant-caps%3A%20normal%3B%20font-weight%3A%20300%3B%20letter-spacing%3A%20normal%3B%20orphans%3A%202%3B%20text-align%3A%20left%3B%20text-indent%3A%200px%3B%20text-transform%3A%20none%3B%20white-space%3A%20normal%3B%20widows%3A%202%3B%20word-spacing%3A%200px%3B%20-webkit-text-stroke-width%3A%200px%3B%20background-color%3A%20%23ffffff%3B%20text-decoration-style%3A%20initial%3B%20text-decoration-color%3A%20initial%3B%22%3E%0A%3CLI%20class%3D%22code-line%20code-line%20code-line%22%20style%3D%22box-sizing%3A%20border-box%3B%20font-family%3A%20SegoeUI%2C%20Lato%2C%20'Helvetica%20Neue'%2C%20Helvetica%2C%20Arial%2C%20sans-serif%3B%22%20data-line%3D%2229%22%3EVerify%20that%20you%20have%20created%3CSPAN%20style%3D%22box-sizing%3A%20border-box%3B%20font-family%3A%20SegoeUI%2C%20Lato%2C%20'Helvetica%20Neue'%2C%20Helvetica%2C%20Arial%2C%20sans-serif%3B%22%3E%26nbsp%3B%3C%2FSPAN%3E%3CCODE%20style%3D%22box-sizing%3A%20border-box%3B%20font-family%3A%20Menlo%2C%20Monaco%2C%20Consolas%2C%20'Courier%20New'%2C%20monospace%3B%20font-size%3A%2014.4px%3B%20padding%3A%202px%204px%3B%20color%3A%20%23c7254e%3B%20background-color%3A%20%23f9f2f4%3B%20border-radius%3A%204px%3B%22%3EEXTERNAL%20DATA%20SOURCE%3C%2FCODE%3E%3CSPAN%20style%3D%22box-sizing%3A%20border-box%3B%20font-family%3A%20SegoeUI%2C%20Lato%2C%20'Helvetica%20Neue'%2C%20Helvetica%2C%20Arial%2C%20sans-serif%3B%22%3E%20with%20type%20%3CCODE%20style%3D%22background-color%3A%20%23f9f2f4%3B%20border-bottom-left-radius%3A%204px%3B%20border-bottom-right-radius%3A%204px%3B%20border-top-left-radius%3A%204px%3B%20border-top-right-radius%3A%204px%3B%20box-sizing%3A%20border-box%3B%20color%3A%20%23c7254e%3B%20font-family%3A%20Menlo%2CMonaco%2CConsolas%2C%26amp%3Bquot%3B%20courier%20new%26amp%3Bquot%3B%2Cmonospace%3B%20font-size%3A%2014.4px%3B%20font-style%3A%20normal%3B%20font-variant%3A%20normal%3B%20font-weight%3A%20300%3B%20letter-spacing%3A%20normal%3B%20orphans%3A%202%3B%20text-align%3A%20left%3B%20text-decoration%3A%20none%3B%20text-indent%3A%200px%3B%20text-transform%3A%20none%3B%20-webkit-text-stroke-width%3A%200px%3B%20white-space%3A%20normal%3B%20word-spacing%3A%200px%3B%20padding%3A%202px%204px%202px%204px%3B%22%3EBLOB_STORAGE%3C%2FCODE%3E%20targeting%20%3C%2FSPAN%3Ethe%20URL%20of%20the%20blob%20storage%20where%20you%20placed%20the%20files%20that%20should%20be%20restored%20to%20your%20database.%3C%2FLI%3E%0A%3CLI%20class%3D%22code-line%20code-line%20code-line%22%20style%3D%22box-sizing%3A%20border-box%3B%20font-family%3A%20SegoeUI%2C%20Lato%2C%20'Helvetica%20Neue'%2C%20Helvetica%2C%20Arial%2C%20sans-serif%3B%22%20data-line%3D%2229%22%3EMake%20sure%20that%20you%20are%20targeting%20existing%20file%20on%20Azure%20blob%20storage.%3C%2FLI%3E%0A%3CLI%20class%3D%22code-line%20code-line%20code-line%22%20style%3D%22box-sizing%3A%20border-box%3B%20font-family%3A%20SegoeUI%2C%20Lato%2C%20'Helvetica%20Neue'%2C%20Helvetica%2C%20Arial%2C%20sans-serif%3B%22%20data-line%3D%2231%22%3EScript%3CSPAN%20style%3D%22box-sizing%3A%20border-box%3B%20font-family%3A%20SegoeUI%2C%20Lato%2C%20'Helvetica%20Neue'%2C%20Helvetica%2C%20Arial%2C%20sans-serif%3B%22%3E%26nbsp%3B%3C%2FSPAN%3E%3CCODE%20style%3D%22box-sizing%3A%20border-box%3B%20font-family%3A%20Menlo%2C%20Monaco%2C%20Consolas%2C%20'Courier%20New'%2C%20monospace%3B%20font-size%3A%2014.4px%3B%20padding%3A%202px%204px%3B%20color%3A%20%23c7254e%3B%20background-color%3A%20%23f9f2f4%3B%20border-radius%3A%204px%3B%22%3ECREDENTIAL%3C%2FCODE%3E%3CSPAN%20style%3D%22box-sizing%3A%20border-box%3B%20font-family%3A%20SegoeUI%2C%20Lato%2C%20'Helvetica%20Neue'%2C%20Helvetica%2C%20Arial%2C%20sans-serif%3B%22%3E%26nbsp%3B%3C%2FSPAN%3Eto%20SQL%20Server%202017%20%3CSPAN%20style%3D%22display%3A%20inline%20!important%3B%20float%3A%20none%3B%20background-color%3A%20%23ffffff%3B%20color%3A%20%23333333%3B%20cursor%3A%20text%3B%20font-family%3A%20inherit%3B%20font-size%3A%2016px%3B%20font-style%3A%20normal%3B%20font-variant%3A%20normal%3B%20font-weight%3A%20300%3B%20letter-spacing%3A%20normal%3B%20line-height%3A%201.7142%3B%20orphans%3A%202%3B%20text-align%3A%20left%3B%20text-decoration%3A%20none%3B%20text-indent%3A%200px%3B%20text-transform%3A%20none%3B%20-webkit-text-stroke-width%3A%200px%3B%20white-space%3A%20normal%3B%20word-spacing%3A%200px%3B%22%3Eand%20try%20to%20load%20the%20files.%3C%2FSPAN%3E%20If%20you%20are%20troubleshooting%20the%20issue%20on%20Managed%20Instance%20make%20sure%20that%20SQL%20Server%20is%20in%20the%20subnet%20that%20is%20within%20the%20same%20VNet%20as%20the%20Managed%20Instance%2C%26nbsp%3B%3C%2FLI%3E%0A%3CLI%20class%3D%22code-line%20code-line%20code-line%22%20style%3D%22box-sizing%3A%20border-box%3B%20font-family%3A%20SegoeUI%2C%20Lato%2C%20'Helvetica%20Neue'%2C%20Helvetica%2C%20Arial%2C%20sans-serif%3B%22%20data-line%3D%2232%22%3ECheck%20is%20your%20SAS%20credential%20placed%20in%3CSPAN%20style%3D%22box-sizing%3A%20border-box%3B%20font-family%3A%20SegoeUI%2C%20Lato%2C%20'Helvetica%20Neue'%2C%20Helvetica%2C%20Arial%2C%20sans-serif%3B%22%3E%26nbsp%3B%3C%2FSPAN%3E%3CCODE%20style%3D%22box-sizing%3A%20border-box%3B%20font-family%3A%20Menlo%2C%20Monaco%2C%20Consolas%2C%20'Courier%20New'%2C%20monospace%3B%20font-size%3A%2014.4px%3B%20padding%3A%202px%204px%3B%20color%3A%20%23c7254e%3B%20background-color%3A%20%23f9f2f4%3B%20border-radius%3A%204px%3B%22%3ESECRET%3C%2FCODE%3E%3CSPAN%20style%3D%22box-sizing%3A%20border-box%3B%20font-family%3A%20SegoeUI%2C%20Lato%2C%20'Helvetica%20Neue'%2C%20Helvetica%2C%20Arial%2C%20sans-serif%3B%22%3E%26nbsp%3B%3C%2FSPAN%3Eoption%20of%3CSPAN%20style%3D%22box-sizing%3A%20border-box%3B%20font-family%3A%20SegoeUI%2C%20Lato%2C%20'Helvetica%20Neue'%2C%20Helvetica%2C%20Arial%2C%20sans-serif%3B%22%3E%26nbsp%3B%3C%2FSPAN%3E%3CCODE%20style%3D%22box-sizing%3A%20border-box%3B%20font-family%3A%20Menlo%2C%20Monaco%2C%20Consolas%2C%20'Courier%20New'%2C%20monospace%3B%20font-size%3A%2014.4px%3B%20padding%3A%202px%204px%3B%20color%3A%20%23c7254e%3B%20background-color%3A%20%23f9f2f4%3B%20border-radius%3A%204px%3B%22%3ECREATE%20DATABASE%20SCOPED%20CREDENTIAL%3C%2FCODE%3E%3CSPAN%20style%3D%22box-sizing%3A%20border-box%3B%20font-family%3A%20SegoeUI%2C%20Lato%2C%20'Helvetica%20Neue'%2C%20Helvetica%2C%20Arial%2C%20sans-serif%3B%22%3E%26nbsp%3B%3C%2FSPAN%3Estatement%20valid.%20The%20most%20common%20errors%20in%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CA%20style%3D%22box-sizing%3A%20border-box%3B%20background-color%3A%20transparent%3B%20color%3A%20%23146cac%3B%20text-decoration%3A%20underline%3B%22%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fazure%2Fstorage%2Fcommon%2Fstorage-dotnet-shared-access-signature-part-1%23shared-access-signature-parameters%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3ESAS%20token%20parameters%3C%2FA%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3Eare%3A%0A%3CUL%20style%3D%22box-sizing%3A%20border-box%3B%20margin-top%3A%200px%3B%20margin-bottom%3A%200px%3B%20padding-left%3A%202.5em%3B%20list-style%3A%20outside%3B%20clear%3A%20left%3B%22%3E%0A%3CLI%20class%3D%22code-line%20code-line%20code-line%22%20style%3D%22box-sizing%3A%20border-box%3B%20font-family%3A%20SegoeUI%2C%20Lato%2C%20'Helvetica%20Neue'%2C%20Helvetica%2C%20Arial%2C%20sans-serif%3B%22%20data-line%3D%2233%22%3E%3CCODE%20style%3D%22box-sizing%3A%20border-box%3B%20font-family%3A%20Menlo%2C%20Monaco%2C%20Consolas%2C%20'Courier%20New'%2C%20monospace%3B%20font-size%3A%2014.4px%3B%20padding%3A%202px%204px%3B%20color%3A%20%23c7254e%3B%20background-color%3A%20%23f9f2f4%3B%20border-radius%3A%204px%3B%22%3E%3F%3C%2FCODE%3E%3CSPAN%20style%3D%22box-sizing%3A%20border-box%3B%20font-family%3A%20SegoeUI%2C%20Lato%2C%20'Helvetica%20Neue'%2C%20Helvetica%2C%20Arial%2C%20sans-serif%3B%22%3E%26nbsp%3B%3C%2FSPAN%3Eis%20not%20removed%20from%20the%20beginning%20of%20the%20SAS%20token%20because%20the%20Azure%20portal%20generates%20SAS%20token%20with%20the%20leading%3CSPAN%20style%3D%22box-sizing%3A%20border-box%3B%20font-family%3A%20SegoeUI%2C%20Lato%2C%20'Helvetica%20Neue'%2C%20Helvetica%2C%20Arial%2C%20sans-serif%3B%22%3E%26nbsp%3B%3C%2FSPAN%3E%3CCODE%20style%3D%22box-sizing%3A%20border-box%3B%20font-family%3A%20Menlo%2C%20Monaco%2C%20Consolas%2C%20'Courier%20New'%2C%20monospace%3B%20font-size%3A%2014.4px%3B%20padding%3A%202px%204px%3B%20color%3A%20%23c7254e%3B%20background-color%3A%20%23f9f2f4%3B%20border-radius%3A%204px%3B%22%3E%3F%3C%2FCODE%3E.%20Remove%20this%20character%20if%20you%20see%20it.%3C%2FLI%3E%0A%3CLI%20class%3D%22code-line%20code-line%20code-line%22%20style%3D%22box-sizing%3A%20border-box%3B%20font-family%3A%20SegoeUI%2C%20Lato%2C%20'Helvetica%20Neue'%2C%20Helvetica%2C%20Arial%2C%20sans-serif%3B%22%20data-line%3D%2234%22%3E%3CCODE%20style%3D%22box-sizing%3A%20border-box%3B%20font-family%3A%20Menlo%2C%20Monaco%2C%20Consolas%2C%20'Courier%20New'%2C%20monospace%3B%20font-size%3A%2014.4px%3B%20padding%3A%202px%204px%3B%20color%3A%20%23c7254e%3B%20background-color%3A%20%23f9f2f4%3B%20border-radius%3A%204px%3B%22%3Ese%3C%2FCODE%3E%3CSPAN%20style%3D%22box-sizing%3A%20border-box%3B%20font-family%3A%20SegoeUI%2C%20Lato%2C%20'Helvetica%20Neue'%2C%20Helvetica%2C%20Arial%2C%20sans-serif%3B%22%3E%26nbsp%3B%3C%2FSPAN%3E(expiry%20date)%20property%20is%20set%20to%20some%20value%20in%20the%20past%20(note%20that%20this%20is%20UTC%20time).%3C%2FLI%3E%0A%3CLI%20class%3D%22code-line%20code-line%20code-line%22%20style%3D%22box-sizing%3A%20border-box%3B%20font-family%3A%20SegoeUI%2C%20Lato%2C%20'Helvetica%20Neue'%2C%20Helvetica%2C%20Arial%2C%20sans-serif%3B%22%20data-line%3D%2235%22%3E%3CCODE%20style%3D%22box-sizing%3A%20border-box%3B%20font-family%3A%20Menlo%2C%20Monaco%2C%20Consolas%2C%20'Courier%20New'%2C%20monospace%3B%20font-size%3A%2014.4px%3B%20padding%3A%202px%204px%3B%20color%3A%20%23c7254e%3B%20background-color%3A%20%23f9f2f4%3B%20border-radius%3A%204px%3B%22%3Est%3C%2FCODE%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E(start%20date)%20property%20is%20not%20in%20the%20past%20(note%20that%20this%20is%20UTC%20time).%3C%2FLI%3E%0A%3CLI%20class%3D%22code-line%20code-line%20code-line%22%20style%3D%22box-sizing%3A%20border-box%3B%20font-family%3A%20SegoeUI%2C%20Lato%2C%20'Helvetica%20Neue'%2C%20Helvetica%2C%20Arial%2C%20sans-serif%3B%22%20data-line%3D%2236%22%3E%3CCODE%20style%3D%22box-sizing%3A%20border-box%3B%20font-family%3A%20Menlo%2C%20Monaco%2C%20Consolas%2C%20'Courier%20New'%2C%20monospace%3B%20font-size%3A%2014.4px%3B%20padding%3A%202px%204px%3B%20color%3A%20%23c7254e%3B%20background-color%3A%20%23f9f2f4%3B%20border-radius%3A%204px%3B%22%3Esp%3C%2FCODE%3E%3CSPAN%20style%3D%22box-sizing%3A%20border-box%3B%20font-family%3A%20SegoeUI%2C%20Lato%2C%20'Helvetica%20Neue'%2C%20Helvetica%2C%20Arial%2C%20sans-serif%3B%22%3E%26nbsp%3B%3C%2FSPAN%3E(permission)%20property%20should%20allow%20reading%20the%20file%20on%20the%20storage%20account.%3C%2FLI%3E%0A%3CLI%20class%3D%22code-line%20code-line%20code-line%22%20style%3D%22box-sizing%3A%20border-box%3B%20font-family%3A%20SegoeUI%2C%20Lato%2C%20'Helvetica%20Neue'%2C%20Helvetica%2C%20Arial%2C%20sans-serif%3B%22%20data-line%3D%2236%22%3E%3CCODE%20style%3D%22box-sizing%3A%20border-box%3B%20font-family%3A%20Menlo%2C%20Monaco%2C%20Consolas%2C%20'Courier%20New'%2C%20monospace%3B%20font-size%3A%2014.4px%3B%20padding%3A%202px%204px%3B%20color%3A%20%23c7254e%3B%20background-color%3A%20%23f9f2f4%3B%20border-radius%3A%204px%3B%22%3Esip%3C%2FCODE%3E%3CSPAN%20style%3D%22box-sizing%3A%20border-box%3B%20font-family%3A%20SegoeUI%2C%20Lato%2C%20'Helvetica%20Neue'%2C%20Helvetica%2C%20Arial%2C%20sans-serif%3B%22%3E%26nbsp%3B%3C%2FSPAN%3E(ip%20rage)%20remove%20this%20parameter%20if%20it%20is%20present%20in%20SAS%20token..%3C%2FLI%3E%0A%3C%2FUL%3E%0A%3C%2FLI%3E%0A%3C%2FUL%3E%3C%2FLINGO-BODY%3E%3CLINGO-TEASER%20id%3D%22lingo-teaser-664734%22%20slang%3D%22en-US%22%3E%3CP%3EThis%20article%20provides%20actions%20that%20can%20help%20you%20to%20troubleshoot%20potential%20%3CFONT%20style%3D%22background-color%3A%20%23ffffff%3B%22%3EBULK%20INSERT%20and%20OPENROWSET%20issues%20in%20Azure%20SQL%20while%20loading%20the%20files%20from%20Azure%20Blob%20Storage%3C%2FFONT%3E%3C%2FP%3E%3C%2FLINGO-TEASER%3E%3CLINGO-LABS%20id%3D%22lingo-labs-664734%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EInteroperability%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMaintenance%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EManaged%20Instance%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Microsoft

Azure SQL Database (single database and Managed Instance) enables you to load files from Azure Blob Storage. If you experience some issue while you are loading files from Azure blob storage, here you can find the actions that can help you to troubleshoot and mitigate the issue.

 

  • If you are noticing that some syntax error is returned by BULK INSERT or BULK INSERTcheck are you using supported syntax in this statement. As an example, if you are trying to load data via network share path note that this option is not supported in Managed Instance.
  • Make sure that you are restoring a database from public blob storage protected with SAS credential. Private IPs for blob storage and service endpoints are currently not supported.
  • If you are getting the error 5 (Access Denied), make sure that you have not denied the access to your Azure Blob Storage account using the firewall:Storage firewall.png

 

  • Verify that you have created EXTERNAL DATA SOURCE with type BLOB_STORAGE targeting the URL of the blob storage where you placed the files that should be restored to your database.
  • Make sure that you are targeting existing file on Azure blob storage.
  • Script CREDENTIAL to SQL Server 2017 and try to load the files. If you are troubleshooting the issue on Managed Instance make sure that SQL Server is in the subnet that is within the same VNet as the Managed Instance, 
  • Check is your SAS credential placed in SECRET option of CREATE DATABASE SCOPED CREDENTIAL statement valid. The most common errors in SAS token parameters are:
    • ? is not removed from the beginning of the SAS token because the Azure portal generates SAS token with the leading ?. Remove this character if you see it.
    • se (expiry date) property is set to some value in the past (note that this is UTC time).
    • st (start date) property is not in the past (note that this is UTC time).
    • sp (permission) property should allow reading the file on the storage account.
    • sip (ip rage) remove this parameter if it is present in SAS token..