SQL Server 2005 SP2

[glt]

Hi,

We will shortly be moving our Vault databases to a new database
server. Because of other applications that have their databases
stored on the new server, it must be SQL Server 2005 SP2. Is our
Vault configuration compatible with SQL Server 2005 SP2? The
full Vault configuration is given below. I couldn't find mention of
SQL Server 2005 SP2 anywhere on this site.

Cheers,
Geoff


Client Information
Vault Client Version: 3.1.5.3546
.Net Framework Version: 2.0.50727.312
Operating System: Microsoft® Windows Vista™ Enterprise
Service Pack: 0.0
OS Version: 6.0.6000
Total Physical Memory: 2 GB
Time Zone: (GMT-05:00) Eastern Time (US & Canada)

Server Information (This is the old, current server. Not the new server)
Vault Server Version: 3.1.5.3546
.Net Framework Version: 1.1.4322.2407
Operating System: Microsoft(R) Windows(R) Server 2003, Standard Edition
Service Pack: 1.0
OS Version: 5.2.3790
Timezone: (GMT-05:00) Eastern Time (US & Canada)
SQL Version: Microsoft SQL Server 2000 - 8.00.679 (Intel X86)
Aug 26 2002 15:09:48
Copyright (c) 1988-2000 Microsoft Corporation
Enterprise Edition on Windows NT 5.0 (Build 2195: Service Pack 4)

[jclausius]

It might work, but Vault did not add support for SQL Server SP 1 until Vault 3.5. See the SourceGear Vault 3.5 Release Notes.

SQL Server SP2 was tested and supported on Vault Server 3.5.1, 3.5.2, and 3.5.3.

[glt]

Hi Jeff,

Thanks for the response. I guess we'll be doing SourceGear's
testing for them then. I'll post results when we have them.

Cheers,
Geoff

[jclausius]

Please do so with extreme caution as this is an unsupported configuration. There were changes in Vault 3.5 to work around some of the changes in the SQL Server Service Pack 1 release.

You might also want to test out the other Vault upgrades as well. There have been significant changes in the 22 months since the release of Vault 3.1.5.