Jump to content

Problems migrating from 2008 to 2019.


Recommended Posts



My plan is to backup and restore database and install passwordstate in a Windows 2019 server and use the database restored in an SQL 2017.


Im doing the backup/restore database from 2005 SQL(running in 2008) to 2017 SQL(running in 2019) like this document:



I imported database without problems, but when i try to delete user like says step 4, i got this error:


Drop failed for User 'passwordstate_user'.  (Microsoft.SqlServer.Smo)

For help, click: https://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=16.100.47021.0&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Drop+User&LinkId=20476


An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)


The database principal owns a schema in the database, and cannot be dropped. (Microsoft SQL Server, Error: 15138)


Do you know how can i delete it?


We have version 8114, i have seen on the web that i must download the version 8995:



Why cannot install the last version 9 9583 ?


Many thanks,

Best regards


Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Create New...