connect to sql server

Paul Smith · Post by **Paul Smith** » Thu Jul 22, 2004 10:10 am

I have installed the source gear server, but did not know what authentication to select on the setup screen. I picked the second radio button. When trying to open the admin software it tells me I cannot connect to the database. I am entering my windows user name and password. What am I doing wrong.

Guest · Post by **Guest** » Thu Jul 22, 2004 9:35 pm

If you install Vault using SQL Server authentication, you would provide the MS SQL Server sa for the login name and the sa password. The Vault installer will use the sa account to create the Vault database, the sgvaultuser db user and sgvaultuser SQL Server login. (This is the only time it's used).

If you don't want to use the sa account to create the database, you can use an existing account in MS SQL Server that has rights to create databases, users, and logins.

Your Windows account may not have a login for MS SQL Server or adequate rights.

For more info see the tutorial:

http://www.sourcegear.com/vault/support ... torial.asp

Linda Bauer
SourceGear
Technical Support