FailDBConn

phowatt · Post by **phowatt** » Mon Apr 04, 2005 7:46 am

I followed the instructions as advised in the help text for the following error when trying to make a Vault connection.

"The Vault Server could not establish a connection to the database. Please check the server's log for detailed information. (FailDBConn)"

I checked the log and the following is the log content.

"----4/4/2005 7:29:21 AM sgvaultsystem--()--
System Started
Version 3.0.5.2833
Cache Level = 1
DataBase Buffer Size (KB) = 256
LogFile Path = C:\WINDOWS\Temp\sgvault
Log Level = Quiet
Archive Log = Weekly
ReverseDNS Lookup = True
Maximum HTTP Request Length = 102400
Overwrite Log on Startup = False
Session Timeout = 4320
Active Directory Domain =
SGVault Working Directory = C:\WINDOWS\Temp
SGVault Server URL = http://dellfvbz211/VaultService
Identity = NT AUTHORITY\NETWORK SERVICE
----4/4/2005 7:29:22 AM --()-- Vault Failed to establish a connection to the database.
----4/4/2005 7:29:22 AM --()-- Login failed for user 'NT AUTHORITY\NETWORK SERVICE'.
----4/4/2005 7:29:22 AM --()-- Vault Failed to establish a connection to the database.
----4/4/2005 7:29:22 AM --()-- Login failed for user 'NT AUTHORITY\NETWORK SERVICE'.
----4/4/2005 7:29:22 AM --()-- The session information was not removed from the database. Please check sgvault.dbo.tblsessions within SQL Server. There may be orphaned sessions stored within the database. Error: FailDBConn
----4/4/2005 7:29:25 AM --dellfvbz211.hsd1.mn.comcast.net.(192.168.1.108)--SSL Disabled Vault Failed to establish a connection to the database.
----4/4/2005 7:29:25 AM --dellfvbz211.hsd1.mn.comcast.net.(192.168.1.108)--SSL Disabled Login failed for user 'NT AUTHORITY\NETWORK SERVICE'.
----4/4/2005 7:29:32 AM --()-- Access is denied.

----4/4/2005 7:31:27 AM --dellfvbz211.hsd1.mn.comcast.net.(192.168.1.108)--SSL Disabled Vault Failed to establish a connection to the database.
----4/4/2005 7:31:27 AM --dellfvbz211.hsd1.mn.comcast.net.(192.168.1.108)--SSL Disabled Login failed for user 'NT AUTHORITY\NETWORK SERVICE'.
----4/4/2005 7:31:34 AM --()-- Access is denied.

----4/4/2005 7:33:52 AM --dellfvbz211.hsd1.mn.comcast.net.(192.168.1.108)--SSL Disabled Vault Failed to establish a connection to the database.
----4/4/2005 7:33:52 AM --dellfvbz211.hsd1.mn.comcast.net.(192.168.1.108)--SSL Disabled Login failed for user 'NT AUTHORITY\NETWORK SERVICE'.
----4/4/2005 7:33:53 AM phowatt--dellfvbz211.hsd1.mn.comcast.net.(192.168.1.108)--SSL Disabled Vault Failed to establish a connection to the database.
----4/4/2005 7:33:53 AM phowatt--dellfvbz211.hsd1.mn.comcast.net.(192.168.1.108)--SSL Disabled Login failed for user 'NT AUTHORITY\NETWORK SERVICE'.
----4/4/2005 7:37:31 AM --dellfvbz211.hsd1.mn.comcast.net.(192.168.1.108)--SSL Disabled Vault Failed to establish a connection to the database.
----4/4/2005 7:37:31 AM --dellfvbz211.hsd1.mn.comcast.net.(192.168.1.108)--SSL Disabled Login failed for user 'NT AUTHORITY\NETWORK SERVICE'.
----4/4/2005 7:37:31 AM phowatt--dellfvbz211.hsd1.mn.comcast.net.(192.168.1.108)--SSL Disabled Vault Failed to establish a connection to the database.
----4/4/2005 7:37:31 AM phowatt--dellfvbz211.hsd1.mn.comcast.net.(192.168.1.108)--SSL Disabled Login failed for user 'NT AUTHORITY\NETWORK SERVICE'.
----4/4/2005 8:03:20 AM --dellfvbz211.hsd1.mn.comcast.net.(192.168.1.108)--SSL Disabled Vault Failed to establish a connection to the database.
----4/4/2005 8:03:20 AM --dellfvbz211.hsd1.mn.comcast.net.(192.168.1.108)--SSL Disabled Login failed for user 'NT AUTHORITY\NETWORK SERVICE'.
----4/4/2005 8:03:21 AM phowatt--dellfvbz211.hsd1.mn.comcast.net.(192.168.1.108)--SSL Disabled Vault Failed to establish a connection to the database.
----4/4/2005 8:03:21 AM phowatt--dellfvbz211.hsd1.mn.comcast.net.(192.168.1.108)--SSL Disabled Login failed for user 'NT AUTHORITY\NETWORK SERVICE'.
----4/4/2005 8:04:10 AM phowatt--dellfvbz211.hsd1.mn.comcast.net.(192.168.1.108)--SSL Disabled Vault Failed to establish a connection to the database.
----4/4/2005 8:04:10 AM phowatt--dellfvbz211.hsd1.mn.comcast.net.(192.168.1.108)--SSL Disabled Login failed for user 'NT AUTHORITY\NETWORK SERVICE'.
----4/4/2005 8:17:30 AM --dellfvbz211.hsd1.mn.comcast.net.(192.168.1.108)--SSL Disabled Vault Failed to establish a connection to the database.
----4/4/2005 8:17:30 AM --dellfvbz211.hsd1.mn.comcast.net.(192.168.1.108)--SSL Disabled Login failed for user 'NT AUTHORITY\NETWORK SERVICE'.
----4/4/2005 8:17:30 AM phowatt--dellfvbz211.hsd1.mn.comcast.net.(192.168.1.108)--SSL Disabled Vault Failed to establish a connection to the database.
----4/4/2005 8:17:30 AM phowatt--dellfvbz211.hsd1.mn.comcast.net.(192.168.1.108)--SSL Disabled"

I followed the instructions in the help text and ran the following SQL script.

USE [master]
IF ( NOT EXISTS (SELECT sid FROM syslogins WHERE name = 'DELLFVBZ211\NETWORK SERVICE') )
EXEC sp_grantlogin N'DELLFVBZ211\NETWORK SERVICE'

-- next access should be granted in the vault database
USE [sgvault]
EXEC sp_grantdbaccess N'DELLFVBZ211\NETWORK SERVICE'
EXEC sp_addrolemember N'db_owner', N'DELLFVBZ211\NETWORK SERVICE'
GO

This resulted in the following error message.

Server: Msg 15401, Level 11, State 1, Procedure sp_grantlogin, Line 41
Windows NT user or group 'DELLFVBZ211\NETWORK SERVICE' not found. Check the name again.
Server: Msg 15401, Level 11, State 1, Procedure sp_grantdbaccess, Line 99
Windows NT user or group 'DELLFVBZ211\NETWORK SERVICE' not found. Check the name again.
Server: Msg 15410, Level 11, State 1, Procedure sp_addrolemember, Line 66
User or role 'DELLFVBZ211\NETWORK SERVICE' does not exist in this database.

Then I attempted to add the group NETWORK SERVICE to the Local Users and got the following message.

Error when attempting to add NETWORK SERVICE to NT Groups.

"The following error occurred while attempting to create the group NETWORK SERVICE on COMPUTER DELLFVBZ211;
The account already exists.

However this account does not show up on the list of groups or users. I do not know what to try next. Any help would be appreciated as I will not be able to evaluate Vault if I cannont get it to work. Thanks much.

Post by **jclausius** » Mon Apr 04, 2005 8:34 am

In order to use Windows Authentication within SQL Server, the Vault / ASP.Net account must be available on your SQL Server machine.

What is the setup of your configuration? Is the SQL Server on the same machine as the Vault server?

If so, then there is some sort of permissions issue we will need to trouble shoot. We'll have to figure out why the local .Net Process account cannot be granted access to the database.

If the SQL Server is on a different machine, then you will not be able to connect to the SQL Server as the ASP.Net process account is a Local account, and will not be available on the other machine.

In cases like these, you will need to make sure your SQL Server is configured to use SQL Server Authentication and use that as the login for installation. If you must use Windows authentication, we will have to go through the steps to create a Custom .Net Domain account, which will have access to the SQL Server.

Having more information of your setup will help us figure out which path to choose.

phowatt · Post by **phowatt** » Mon Apr 04, 2005 8:47 am

I thought I had included everything but the best laid plans. The client and server are on the same machine.

phowatt · Post by **phowatt** » Mon Apr 04, 2005 8:53 am

Sorry still not clear. The Vault Server, Vault Client, and MSDE are all on the same machine.

Post by **jclausius** » Mon Apr 04, 2005 9:05 am

Can you see if MSDE is running? Try the following from a command prompt (type in exactly as I've specified):

Code: Select all

osql -S (local) -E

What are the results?

phowatt · Post by **phowatt** » Mon Apr 04, 2005 9:12 am

I typed "osql -S (local) -E" from the command prompt and the response was:
1>

I am able to use MSDE for other things I am doing. The icon in the tray shows a green arrow. I can run Enterprise Manager, Query Analyzer as well as access my databases from the Visual Studio IDE. MSDE is definately started.

Post by **jclausius** » Mon Apr 04, 2005 9:21 am

The database is running, so let's attack this from the ASP.Net process account side of things.

Re-examining the error you showed later in the original post - "Windows NT user or group 'DELLFVBZ211\NETWORK SERVICE' not found." It's as if the ASP.Net process account does not exist on your machine.

Which version of Windows are you using to host IIS / Vault? Are you using Windows 2003 Server? If so, have you gone through the steps related to configuring IIS 6 to work with ASP.Net?

Post by **jclausius** » Mon Apr 04, 2005 9:26 am

OK... From a previous post you have made, I've been able to confirm you are running Win 2003 Advanced Server.

Is it safe to assume all the extra .Net installation configuration was performed on this machine?

phowatt · Post by **phowatt** » Mon Apr 04, 2005 9:27 am

Yes I am running Windows Server 2003 and I am afraid I am an ISS newbie and have not done any ISS setup other than what was done via the Windows install.

Post by **jclausius** » Mon Apr 04, 2005 9:29 am

Let's start here in our Knowledge Base -

Installing Vault Server on Windows 2003 Server

Let me know what information you had to change ( if any ) for the server.

phowatt · Post by **phowatt** » Mon Apr 04, 2005 9:42 am

Everything was as supposed to be. I did not have to change anything.

Post by **jclausius** » Mon Apr 04, 2005 9:52 am

OK. Let's try to see why this is not working correctly.

From a command prompt, can you try the following:

Code: Select all

%windir%\microsoft.net\framework\v1.1.4322\aspnet_regiis -i

Did IIS re-set up ASP.Net correctly?

Also, can is it safe to assume, DELLFVBZ211 is the name of the machine?

Post by **jclausius** » Mon Apr 04, 2005 10:19 am

[Edit -for some minor typos]

A colleague just reminded me of something. In Windows 2003 server, the ASP.Net process account does not show up in the MACHINE\USER configuration. The account usually is of 'NT AUTHORITY\NETWORK SERVICE' ( at least on English based Win 2003 Server installations ).

Instead of going through and checking permission on each and every detail, it might be worth it to re-attempt your installation one more time. The other post you had made seemd to indicate some sort of problem in the installation.

Can we try an uninstall / reinstall? In fact, you may want to contact the support department for additional guidance with the installation.

phowatt · Post by **phowatt** » Mon Apr 04, 2005 1:35 pm

I did the uninstall and then ran the install again. This time I did not install the client during the server install but installed it later. I came to a screen that prompted me to select the account under which the service would run. I selected the first choice which was Machine - NT AUTHORITY\NETWORK SERVICE. I believe that in my first attempt I may have selected the 2nd choice which was System - DELLFVBZ211\DELLFVBZ211$. The messages that displayed during the install indicated that the Database was successfully built and that the necessary foldders were given the necessary permissions. This time when I tried to connect to the Vault server it worked. So far I have been able to add my development solution to Vault so it seems to be working correctly. I think the problem was the choice I made in the initial install. Thanks so much for you help.

Post by **jclausius** » Mon Apr 04, 2005 2:00 pm

Glad you are up and running.

SourceGear Support

FailDBConn

FailDBConn

Failed DB Conn

Failed DBConn

Failed DBConn

Failed DBConn

Failed DBConn

Failed DBConn