Unable to connect after moving database

jayritchie · Post by **jayritchie** » Fri Mar 17, 2006 10:29 am

I move my database to a hosting provider from a local instance following the instructions here:

http://support.sourcegear.com/viewtopic.php?t=924

After moving, I cannot use any login to get into the Web client. I simply get a Login Error. If I try logging is using the Admin tool, I get the error "The Vault Server could not establish a connection to the database. Please check the server's log for detailed information. (FailDBConn)".

These instruction differed somewhat from those I found when searching the forums for instructions on how to install Vault at a hosting provider. What am I missing?

lbauer · Post by **lbauer** » Fri Mar 17, 2006 10:40 am

Did you modify the Vault web.config file to change the connection string to point to the new database location?

jayritchie · Post by **jayritchie** » Sat Mar 18, 2006 1:39 pm

Yes, that was in the instructions I said I followed.

Here is a snip from the log file:

Code: Select all

----3/17/2006 10:26:04 AM    Admin--165.125.144.16(165.125.144.16)--SSL Disabled	Vault Failed to establish a connection to the database. 
----3/17/2006 10:26:04 AM    Admin--165.125.144.16(165.125.144.16)--SSL Disabled	System.Data.SqlClient.SqlException: Login failed for user 'sgvaultuser'.
   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)

lbauer · Post by **lbauer** » Sat Mar 18, 2006 5:32 pm

Verify that there is a login in SQL Server for sgvaultuser, and that this account has the roles of public and dbowner.

The error indicates sgvaultuser can't log into the database. Can you log into the sgvault database as sgvaultuser, using Query Analyzer?

Did you use the Vault Admin password when you ran the queries to recreate sgvaultuser?

When you use SQL Server authentication during the Vault Server installation, the installer creates the sgvaultuser account and uses the Vault Admin password for sgvaultuser and encrypts the Admin password in the web.config file for the SQL Server connection string.

If the password is the problem, you could try changing PWD to PASSWORD in the Vault web.config file, and then enter the sgvaultuser password in plaintext.