Move Vault Web

[btd]

We are on Vault 5.1.1(19215) and currently running just fine.
The web server is Windows Server 2003 standard that houses the Vault service Vault shadow folder web sites

What are the steps involved in installing Vault web on a different web server (Windows Server 2008 R2) and shutting down the existing? And do we have to know the existing passwords or can we create a new one during the installation?

Note: When we do this, I realize that all Vault clients will have to point to the new web server when logging in.

Thanks

btd

[lbauer]

I need a little more information before I can answer:

Is SQL Server on the same machine as your Win 2003 web server? Or is it on a different machine?

When you move Vault Server, will you move to a different SQL Server?

Will the SQL Server be on the same machine as Vault Server?

[btd]

Sorry about that.
The Vault database is on a separate server.
So I have 30+ client installations
1 db server
1 web server to house the vault virtual directories.

The SQL Server will not change. Just the application server where the vault virtual directories live.

btd

[lbauer]

Backup your Vault databases, sgmaster and sgvault. Make sure you have a good backup.

Then uninstall Vault on the Windows 2003 machine. Keep the databases when prompted.

Then install Vault on the new Windows Server 2008 R2. In the SQL Server setup portion of the installation, enter the the name of your SQL Server machine. For easiest installation, use SQL Server authentication.

When you install, you'll be able to create a new Vault Admin password. All your code, user info, user passwords, etc. are stored in the database, so those will not change.

More installer help here:

http://sourcegear.com/vault/documentati ... index.html

Let me know if you have additional questions.

[btd]

Thanks very much.

[lbauer]

You're welcome.

Let me know if you need anything else.

[btd]

We would like to do the SWITCH during the day, so we don't have to work after hours.

So, Is there any harm in LEAVING the current web installation on the first web server. performing an NEW install on a new server. Then after installation on the new server, we would launch Vault, change the server to the new one, and if all checks are valid, we then go back and remove the web installation from the first server?

Thinking here is we allow our developers to continue throughout the day connecting to the existing web server, then have them make the change to the new web server the next morning.

Or is this just not recommended!

Also, what happens if some of my developers leave files checked out during the migration? Are changes lost?

Thanks

Tom

[lbauer]

While it's technically possible to install two Vault servers to use the same database, it's not supported and we don't recommend it.

During a Vault server installation, the installer connect to the SQL Server database and makes changes. Depending on what it changes (database user, login, database permissions) users may not be able to connect anymore from the old server. Also, while the installer is connecting to the Vault databases, it puts them in single-user mode, and that will lock users out for a short time.

Regarding checked out files --checkout information is stored in the database, so users don't necessarily need to check in their files.

Are your users using Visual Studio? Visual Studio writes connection information into solution and project files. Users will need to unbind their projects from the old server and rebind to the new server.

Let me know if you need instructions for this.

[btd]

Thanks Linda.

Can the Vault WebServices piece be installed on a Windows 2008 R2 IIS 7.0 server?

[lbauer]

Yes, Vault Server 5.1.2 is supported on Windows 2008 R2.

[btd]

Uh, we are on Vault 5.1.1(19215). Will this work or do I have to download 5.1.2 Std ?

[lbauer]

That's fine, though as long as you're reinstalling, might as well upgrade to the last 5.1.x release, which 5.1.2. It's a free upgrade from any 5.x verson.

[btd]

During the installation of Vault Web Services, I am prompted for credentials when connecting to the database server.
If I choose Windows Authentication, I am presented with this message.

“You must use an account that is common to both machines to execute the IIS Process. Press OK to continue the install anyway, or Cancel to Abort this installation.”

If I proceed, it installs but I can't connect to Vault using the Admin account.

But if use SQL account it works?

Why am I forced to use SQL account?
And is this SQL account used or referenced anywhere (I.e. web.config)?

Also, when I install using a SQL account, I notice the web.config has a connection with user ID=sgvaultuser;
Where did this come from?

Thanks

Tom

[lbauer]

If SQL Server is on a different machine than the Vault Server you need to either use a custom domain account for the IIS process model, or you can use SQL Server authentication.

For Windows authentication, the Vault installer create a login for the custom domain account in SQL Server, and that login is used by Vault Server to connect to the database.

If you use SQL Server authentication, the Vault installer asks to temporarily use SQL Server SA credentials so the installer can create the sgvaultuser account in SQL Server. Vault server then uses sgvaultuser to connect to the database.

Details in our installation guide:
http://www.sourcegear.com/vault/documen ... index.html

If you want to install using Windows Authentication you also should run the Vault Server installer from a command prompt as Administrator to make sure it has adequate permissions to create the login in SQL Server.

To run Command Prompt as Adminstrator click the Start button and type "cmd" in the search box. You should see "cmd.exe" listed in the search results. Right click on cmd.exe and select "Run as Administrator."

Then cd to the Vault Server installer directory and type the name of the installer and hit return. The installer will run as Administrator.

If you need further help we can schedule a remote assist session where I can take a closer look. Email me at support at sourcegear.com, ATTN: Linda.

Please include a link to this forum post.

[btd]

Linda:

When I try running the Installer from command prompt, I am getting this error:

Windows Cannot open the file specified.

I checked the file and is not blocked.

So what else do I have to do to install Vault from command prompt?