User logins are currently disabled

[bodgerx]

We have just moved our Vault database to a different SQL Server. The application remains on the same server. The migration looked ok, but when anyone logs in we get:

"Login Failed: Your serial number is not a valid serial number. User logins are currently disabled."

All I did to the application was to update the web.config to point to the new database.

[bodgerx]

As per some of the other comments I have seen on here, I attempted to uninstall and reinstall. On the reinstall, on connecting to the existing database, I get asked the question on whether I would like to use the existing database - I answer yes, and then get this error:

vault-server-install-error.jpg (216.12 KiB) Viewed 3670 times

[bodgerx]

Please ignore this thread. It transpires that the migration utility we used to copy the database to the new server failed to copy any of the tables!

[Beth]

When moving to a different server, you will get your best results by just restoring a backup of the database to the new SQL Server or SQL instance, and then installing Vault. During the install, Vault will pick up the database and make any changes it needs to at that time. You may find the following KB article useful: Moving Vault (Server and Database) to a new machine

[bodgerx]

Normally we would have done what you have stated.

Thing is, our SQL Server database instance is on a Polyserve Matrix. The instance (along with the db) was being migrated to a newer, more powerful, matrix. Polyserve (HP) provide a utility to do this (it copies the db, users, logins, jobs everything). There is a bug in the utility that we have raised with HP, but this meant everything but the tables themselves made it across.

[Beth]

Thank you for the additional information. This might be useful for other users that are using the same tool.