Jump to content

Problems migrating from 2008 to 2019.


Ensenada
 Share

Recommended Posts

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

 

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
 Share

×
×
  • Create New...