moving vault database to different sql server

[kha]

I need to move the existing sgvault and sgmaster dbs to different sql server.
What should i do? I already restored the sgmaster to new slq server, but it seems like there are something else in web.config file that i need to change.

[kha]

i just tried and it looks like it's working for me.

I just changed the dbs from one sql server to another. Username and password are kept the same. So, in web.config file I just changed the db server name from old one to new one. And now I can login as admin on the web based GUI

Please let me know if i suppose to change something else

[kha]

i think i spoke too soon.

I could login but it said "You are not an admin user."
I don't see anywhere I can create/delete repository or add/remove users as I usually could before the db move

[Beth]

You probably need to recreate the db-owner. Check out this KB article on moving the Vault databases: http://support.sourcegear.com/viewtopic.php?t=924.