Here you must ex-plicitly enable contained database authentication on the in-stance.sp_configure 'show advanced', 1;RECONFIGURE WITH OVERRIDE;GOsp_configure 'contained database authentication', 1 ...