Is VAULT right for me? Not if it won't install...

danthman · Post by **danthman** » Thu Dec 21, 2006 6:33 pm

Just ran the Vault Server installer (version 3.5.1) on my desktop machine.

* Attempted a full install (server, client, default SCC provider, and admin tool)
* Set "Login used in ISS Process Model" to Machine (also tried System on second try)
* Entered admin passwords
* Connected (successfully) to SQL Server Express
* Chose default collations
* Hit OK
* ERRRP!

Installer errors out with following message:

Upgrading SourceGear Vault database...Invalid object name 'master.dbo.spt_values' [see the full log below]

I guess there's no help from SourceGear until you've paid, but if anyone has a fix for this, would love to hear it.

Thanks,

-Dan

Installer log:

OK
Configuring your new Vault Installation
Checking for IIS Version...Requesting Vault Admin user password...OK
Connecting to the SQL Server...OK
Verifying the SQL Server requirements...OK
Checking for an existing Vault database...Found.
Asking for database's fate...Dropping database
Dropping Existing database...OK
Creating a new Vault database on DANSLAPTOP\SQLEXPRESS...
Creating the SourceGear Vault database...OK
Upgrading SourceGear Vault database...Invalid object name 'master.dbo.spt_values'.
Invalid object name 'master.dbo.spt_values'.
Invalid object name 'master.dbo.spt_values'.
Invalid object name 'master.dbo.spt_values'.
Invalid object name 'master.dbo.spt_values'.
Invalid object name 'master.dbo.spt_values'.
Vault Setup is exiting due to a failure or cancellation. Error Code = 402

Post by **jclausius** » Fri Dec 22, 2006 8:18 am

Are you logging on to SQL Server express with a privileged account?

See http://sqlserver2000.databases.aspfaq.c ... alues.html for one possible solution to this problem.

danthman · Post by **danthman** » Fri Dec 22, 2006 12:33 pm

I don't think it's a problem with permissions. The master simply doesn't have an object called spt_values.

DBCC CHECKTABLE('spt_values')
Cannot find a table or object with the name "spt_values". Check the system catalog.

The next step, according to the above link, would be to rebuild the Master, but I have SQL Server Express 2005, not SQL Server 2000, so I'm not sure the instructions pertain to my situation.

Interestingly, doing a query of sys.all_objects for the master database doesn't return *any* objects containing "spt" (although there are 1353 with "sp").

Anyone have any other ideas? Is it possible Vault doesn't work with SQL Server Express?

Thanks,

-Dan

Post by **jclausius** » Fri Dec 22, 2006 2:49 pm

You may not see it there because it is an undocumented table.

The following query works on a SQL Server Express machine where the user has rights to the master database.

Code: Select all

select * from master.dbo.spt_values

spt_values is an undocumented table which looks up objects within the database. While not explicitly called by the Vault installation, some dependencies must exist which require you to have access within the master database to look up databases and create a stored procedure within the database.

They key will be finding out why the login method you choose to connect to SQL Server Express does not have rights to run that query.

If it is a permissions issue, one option is to configure SQL Server Express to run with both SQL Server and Windows authentication through SQL Server Express Manager, and then use SQL Server Auth with the 'sa' account during the Vault installation.

danthman · Post by **danthman** » Fri Dec 22, 2006 4:48 pm

Hi Jeff,

Tried setting to mixed mode, logging is as sa, and trying your query again, but it still didn't work. Also, now I notice, no matter how I log in, I get the same error if I try to get properties on any of my databases using the Management Studio GUI. So, I'm beginning to think I might need to reinstall SQL Server Express.

danthman · Post by **danthman** » Tue Dec 26, 2006 6:29 pm

UPDATE: Reinstalling SQL Server Express solved the problem. Phew! Now I just have to figure out what to type for "Vault Server" when I start up the Vault Admin Tool

Post by **jclausius** » Wed Dec 27, 2006 11:09 am

Use the machine name / web site 'alias' for the Vault Server. Password will be 'admin' with the password you used during installation.