Installation failure when trying to access remote SQL Server

[dosdemon]

Hi,

I just downloaded the eval and am trying to set it up with VS2005. Initially it asked for an SQL Server. I specified mine, which is over the network. Then it failed saying:


Looking for IIS Version
Configuring your new Vault Installation
Requesting the IIS Process User...Requesting Vault Admin user password...OK
Connecting to the SQL Server...OK
Verifying the SQL Server requirements...OK
Checking for an existing databases...Found.
Asking for database's fate...Keep existing.
Upgrading the existing source control database...
This may take a long time. Do NOT stop this process!
Could not locate entry in sysdatabases for database 'sgvault'. No entry found with that name. Make sure that the name is entered correctly.
Vault Setup is exiting due to a failure or cancellation. Error Code = -1280

On my remote database server (SQL Server 2005), I have access to only a specific database say Xyz, I cannot create tables in the Master database.

Is there someway to tell the setup to use a certain database? What are my options?

Thanks.

[lbauer]

The Vault installer creates the sgvault and the sgmaster databases. It cannot create a database by another name. If you can't create the databases on your SQL Server machine, a possible workaround would be to install Vault with SQL Server on a test machine to create the databases, then detach and reattach (or backup and restore) these databases to the SQL Server machine. Next, install the Vault server, pointing it at the database location.

You might able to rename the sgvault database, and also edit the name of the database in the connection string in the Vault service web.config file. I don't believe the name of sgmaster can be changed, as it is directly accessed from stored procedures in the sgvault database.

UPDATE: In Vault 4.x, it is no longer possible to rename the sgvault database, as the sgmaster database calls it by name.