(FailDBConn), but SQL server is fine

glt · Post by **glt** » Fri Mar 03, 2006 9:56 am

Hi,

We can't log in to our Vault system. This occurred after a
power failure on our SQL server. That server is up and
working fine now. (Lots of other applications are using it
without problems).

Below is a typical section from the log file during attempted
login. What can we do to fix this?

Cheers,
Geoff

----3/3/2006 10:55:16 AM admin--geoff.microcal.com(10.10.10.77)--SSL Disabled Vault Failed to establish a connection to the database.
----3/3/2006 10:55:16 AM admin--geoff.microcal.com(10.10.10.77)--SSL Disabled System.Data.SqlClient.SqlException: SQL Server does not exist or access denied.
at System.Data.SqlClient.ConnectionPool.GetConnection(Boolean& isInTransaction)
at System.Data.SqlClient.SqlConnectionPoolManager.GetPooledConnection(SqlConnectionString options, Boolean& isInTransaction)
at System.Data.SqlClient.SqlConnection.Open()
at VaultServiceSQL.VaultSqlConn.OpenConn()
at VaultServiceAPILib.VaultServiceAPISystem.GetOpenSqlConn(HttpApplicationState has, VaultLoginInfo vli, VaultSqlConn& conn) at System.Data.SqlClient.ConnectionPool.GetConnection(Boolean& isInTransaction)
at System.Data.SqlClient.SqlConnectionPoolManager.GetPooledConnection(SqlConnectionString options, Boolean& isInTransaction)
at System.Data.SqlClient.SqlConnection.Open()
at VaultServiceSQL.VaultSqlConn.OpenConn()
at VaultServiceAPILib.VaultServiceAPISystem.GetOpenSqlConn(HttpApplicationState has, VaultLoginInfo vli, VaultSqlConn& conn)

Post by **jclausius** » Fri Mar 03, 2006 9:58 am

Due to a bug in the .Net Database pooling if SQL Server is recycled, you will need to restart the Vault server. The easiest way to do this is restart IIS From Start -> Run execute "iisreset.exe"

glt · Post by **glt** » Fri Mar 03, 2006 10:05 am

Hi Jeff.

Thanks for the swift response!
That worked great. If what you say is true, then
this must surely be an FAQ? If so where should
I look for things like that next time?

Cheers,
Geoff.