[Resolved]-Error SQL72014 .Net SqlClient Data Provider The sp_configure value 'contained database authentication' must be set to 1 in order to alter a contained database. You may need to use RECONFIGURE to set the value_in_use.

  
Could not deploy package. Error SQL72014 .Net SqlClient Data Provider The sp_configure value 'contained database authentication' must be set to 1 in order to alter a contained database.  You may need to use RECONFIGURE to set the value_in_use.

Could not deploy package. Error SQL72014 .Net SqlClient Data Provider The sp_configure value 'contained database authentication' must be set to 1 in order to alter a contained database.  You may need to use RECONFIGURE to set the value_in_use.




The sp_configure value 'contained database authentication' must be set to 1 in order to alter a contained database. You may need to use RECONFIGURE to set the value_in_use.


Resolved:

USE master
GO
sp_configure 'show advanced options', 1
GO
RECONFIGURE
GO
sp_configure 'CONTAINED DATABASE AUTHENTICATION', 1
GO
RECONFIGURE
GO
sp_configure 'show advanced options', 0
GO
RECONFIGURE
GO


I hope it can help.

GoDevStack.com 

Post a Comment

Thank for leaving message

أحدث أقدم
managed wordpress hosting
managed wordpress hosting