Hello,
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:
https://www.clickstudios.com.au/downloads/version9/Move_New_Database_Server.pdf
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
------------------------------
ADDITIONAL INFORMATION:
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:
https://www.clickstudios.com.au/downloads/version9/Move_New_Web_Server.pdf
Why cannot install the last version 9 9583 ?
Many thanks,
Best regards