DB Connection Failures

gsieber · Post by **gsieber** » Tue Jun 07, 2005 10:24 am

Hi.

Our Vault server 2.2 has recently started locking up. Problems start with a failed DB connection error when trying to login with a client, then it progresses to not allowing us to even login to the OS.

We have installed Vault on two servers now and moved the Vault repository to both and the problem happens each time.

The MDF is 2.5GB. That is big, but not that big. Could that be the problem? Any ideas of what causes this?

Thanks,

Greg

lbauer · Post by **lbauer** » Tue Jun 07, 2005 11:15 am

It would be helpful to see a copy of the sgvault.log file from your %windir%\temp\sgvault directory. Email it to linda at Sourcegear.com and we'll go from there.

Also, let me know what operating system Vault is installed on.

Post by **jclausius** » Tue Jun 07, 2005 11:25 am

I believe the log that Linda asked for should contain some information related to the problem. Also note, if you are using MSDE 2000 as your data store, the database overall size is limited to 2 GB.

gsieber · Post by **gsieber** » Tue Jun 07, 2005 12:52 pm

Here is the log file

lbauer · Post by **lbauer** » Tue Jun 07, 2005 1:26 pm

The log file has several of these error messages:

"Cannot generate SSPI context"

This appears to be a network/MS SQL server issue. Here are some links that discuss this:

http://support.microsoft.com/?id=814401
http://www.sql-server1.org/detail-10046875.html

There's also this lengthy KB article:
http://support.microsoft.com/?id=811889

Perhaps Jeff has some ideas to add.

lbauer · Post by **lbauer** » Tue Jun 07, 2005 1:31 pm

What service pack of Windows do you have? This KB article suggests upgrading to SP1 if you have Windows 2000.

http://support.microsoft.com/kb/267588/

gsieber · Post by **gsieber** » Wed Jun 08, 2005 7:32 am

The server was up to SP3. Added SP4 this morning.

gsieber · Post by **gsieber** » Wed Jun 08, 2005 9:43 pm

Well, we have tried the Windows patches and shrinking the DB. Any other suggestions?

Thanks

lbauer · Post by **lbauer** » Thu Jun 09, 2005 7:14 am

Did you review these links which deal with network connectivity and possible DNS issues?

http://support.microsoft.com/?id=814401

http://www.sql-server1.org/detail-10046875.html

If so, did any of the suggestions help?

gsieber · Post by **gsieber** » Fri Jun 10, 2005 9:15 am

Yea, we reviewed that stuff and none of it seems to apply.

Our network has not changed, not has the server configuration. Also, the system will work for about three or four hours and then locks up. We are convinced it has something to do with the database size issue. Nothing else has changed other than the DB growing.

This Vault installation has run flawlessly for two years and now suddenly it is doing this.

We are considering the following:

Upgrade to the latest version of Vault.
Upgrade to Windows Server 2003
Start a fresh Vault repository and manually re-add only the current projects

Post by **jclausius** » Fri Jun 10, 2005 9:45 am

One other suggestion. You may want to have a look at the Event Viewer and SQL Server activity log. Perhaps they are generating something that may indicate a problem.

Also, what does the following query return:

SELECT SERVERPROPERTY('EngineEdition')

SourceGear Support

DB Connection Failures

DB Connection Failures

Log File

SP 4

Still not solved

DNS etc.