Ok, I didn't follow the suggested backup and restore procedure for my Vault database. I wasn't really thinking of it at the time. I knew I had a database and wanted to move it to another machine.
So I backed up the database and moved the backup file to the new machine. Installed Vault 3.1.8 and set the Admin password and chose SQL authentication for the database. I then restored my backed up database over the one created during the install.
I fired up the Admin tool and kept getting a SQL login failure for user 'sgvault'. Hrm..I knew what the original database password was (I thought) and so I setup the user in SQL server and tested. No problemo! Still no dice when trying to fire up the Admin tool or the Client tool.
Here was my problem - I didn't remember what the database password was. During the setup process the Admin password that you set is also set as the database password. From step 6a in the setup guide:
Create a password for the Admin user. If using SQL Server authentication, this password will also be used for the SQL Server login, 'sgvaultuser'. This value is encrypted in the Vault Server's web.config file.