Vault Server Installation on Windows 2000

If you are having a problem using Vault, post a message here.

Moderator: SourceGear

Post Reply
BA
Posts: 32
Joined: Tue Mar 15, 2005 12:27 pm

Vault Server Installation on Windows 2000

Post by BA » Wed Mar 18, 2009 1:18 pm

We recently upgraded our Vault DB server from SQL Server 2000 to SQL Server 2005.

1) I reinstalled the Vault server software on a Windows 2000 machine and pointed it to the SQL Server 2005 using Windows Authentication. No errors were generated during the install. However, when accessing Vault, I got ah error 'Login failed for user '''

2)I reinstalled the Vault server software on a Windows 2003 box, however I started getting application errors.

3) Next I reinstalled the Vault server software on the Windows 2000 machine, this time using SQL authentication. It worked fine.

Are you aware of issues like these?

Thanks,
Bong

Beth
Posts: 8550
Joined: Wed Jun 21, 2006 8:24 pm
Location: SourceGear
Contact:

Re: Vault Server Installation on Windows 2000

Post by Beth » Thu Mar 19, 2009 8:09 am

What the root issue is will depend on whether your SQL Server is on the same machine as Vault or a different machine.

What is used for the SQL server depends on a combination of what you chose for the IIS Process Model and SQL authentication during install. The Machine and System process models use local accounts. The Custom IIS process model is meant for a domain user account, though one could use a local account with it. When you choose Windows Authentication, the account tied to the process model you chose is made into the SQL db_owner. If you choose SQL authentication, then Vault makes a user called sgvaultuser and makes that user the db_owner.

What I suspect has happened is that you have your SQL on another machine and installed Vault using either the Machine or System IIS process model. The only way the Vault server can connect in that case is if you use SQL authentication. During the install, it uses your credentials to connect to make the changes it needs, but after that, it uses either sgvaultuser or the user Vault is running under.
Beth Kieler
SourceGear Technical Support

BA
Posts: 32
Joined: Tue Mar 15, 2005 12:27 pm

Re: Vault Server Installation on Windows 2000

Post by BA » Thu Mar 19, 2009 11:33 am

I used Windows Authentication during the install. I actually worked on 3 Vault instances in 1 evening.

IIS Process Model used: System
SQL Authentication: Windows

2 of them were installed on Win2K3 boxes. No issues were encountered.
I ran into the issue on the Win2K box only. Checked the DB, the domain account used was made SGVault dbo.

Beth
Posts: 8550
Joined: Wed Jun 21, 2006 8:24 pm
Location: SourceGear
Contact:

Re: Vault Server Installation on Windows 2000

Post by Beth » Thu Mar 19, 2009 1:21 pm

I would suggest using Machine instead of System. Very few ever need to use system.
the domain account used
You won't have a domain account unless you use the Custom Process model.

I still don't really know if you have SQL on the same machine that you install on or not. Is it on the same or different machine from where you are installing?
Beth Kieler
SourceGear Technical Support

Post Reply