URGENT Moving Vault DB

Bradless · Post by **Bradless** » Tue May 31, 2005 10:23 am

I am running Vault version 2.0 and have been attempting to move the entire DB from one server to another. I have searched the knowledge base and it seems I have done what I was supposed to in order to restore.

But after changing the web.config file to point to the new server I get a service failed to start error. In the log I get this "Login failed for user 'sgvaultuser"

any ideas would helpful

Thanks

Post by **jclausius** » Tue May 31, 2005 10:36 am

The shortcut method is to uninstall the server (keeping the database during the prompt), and then re-installing the server (keeping the database during the prompt). This will re-create everything you need in SQL Server as well as the server's connection strings.

If you want to do this manually, please post back. This will involve re-creating a sgvaultuser user within SQL Server, assigning this user to the sgvault database, and reconfiguring the Server's connect string in web.config to point to the correct server.

Bradless · Post by **Bradless** » Tue May 31, 2005 10:48 am

jclausius wrote: If you want to do this manually, please post back. This will involve re-creating a sgvaultuser user within SQL Server, assigning this user to the sgvault database, and reconfiguring the Server's connect string in web.config to point to the correct server.

I have attempted to do maually but there may be something I was/wasnt doing correctly??

Post by **jclausius** » Tue May 31, 2005 11:59 am

Have you tried the shortcut method using the installer as the vehicle to make the changes?

Bradless · Post by **Bradless** » Tue May 31, 2005 11:59 am

Thanks for the info about re-installing worked like a charm all is well!!