Error Msg 12809 You must remove all users with password before

msdeploy.exe : Error: .Net SqlClient Data Provider: Msg 12809, Level 16, State 1, Line 5 You must remove all users with password before

setting the containment property to NONE.

At C:\Program Files\WindowsPowerShell\Modules\SitecoreInstallFramework\1.0.2\Public\Tasks\Invoke-CommandTask.ps1:31 char:13

+             & $Path $Arguments | Out-Default

+             ~~~~~~~~~~~~~~~~~~

+ CategoryInfo          : NotSpecified: (Error: .Net Sql…operty to NONE.:String) [], RemoteException

+ FullyQualifiedErrorId : NativeCommandError

 

Error: Script execution error.  The executed script:

IF EXISTS (SELECT 1

FROM   [master].[dbo].[sysdatabases]

WHERE  [name] = N’$(DatabaseName)’)

BEGIN

ALTER DATABASE [$(DatabaseName)]

SET CONTAINMENT = N

Error: Script execution error.  The executed script:

IF EXISTS (SELECT 1

FROM   [master].[dbo].[sysdatabases]

WHERE  [name] = N’$(DatabaseName)’)

BEGIN

ALTER DATABASE [$(DatabaseName)]

SET CONTAINMENT = N

ONE

WITH ROLLBACK IMMEDIATE;

END

ONE

WITH ROLLBACK IMMEDIATE;

END

 

Error: .Net SqlClient Data Provider: Msg 5069, Level 16, State 1, Line 5 ALTER DATABASE statement failed.

 

Solution : Select Database “Mssql server”

Capture

Security->Logins-> Collectionuser “remove Collectionuser ” now again restart the powershell script

 

 

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s