Vault 3 & hosting vault db on Internet

[Mirza]

Hello,,

We just started to evaluate Vault and we are very pleased with this product, especialy since it uses SQL Server in backgroud, which is not the case with SourceSafe. Before we can make a decision on purchase we need to test this whole concept over Internet. We have developers that are outside our primary LAN network, and they cannot connect to our network becouse of hardware setup that we use. So, we are trying to serve everything on the Internet, including web service and db.

I have installed db and vault service on localhost and it works fine. We want to do some testing over Internet. Our provider supplied us with 300 MB database, we can connect to this with fixed IP), we have setup subdomain to be used with this: something like mytest.mydomain.com.

How to easily do this. I love the installer of this product...it is so easy to use and you can setup everything but on local server. I've the tried to deattach/attach from local server database but, I cannot add new user sgvault...plus in Web.Config file his password is encrypted.

please give some suggestions on how to do this....

Thanks in advance and sorry for my poor English...

[Guest]

Hello again,

I have just followed KB article on how to do this but the problem is with adding sgvaultuser account. Our hoster does not permit adding new users to db, after execuring db_grantaccess and addnewuser on:

Server: Msg 15247, Level 16, State 1, Procedure sp_addlogin, Line 17
User does not have permission to perform this action.

is there any chanhe that in Web.config i could setup something (password is encrypted and I cannot use integrated security) in order that I can connect to vault db.

thanks

[jclausius]

First things first. How is your hosting provider allowing you to connect to the database? SQL Auth or Windows Auth?

[Mirza]

Hello,

SQL Server authorization. We have received Server IP address, username and password. I can connect to this DB using Enterprise Manager, but this account is not part of Securtiy Administrator role, which means that I am unable to add new accounts to this database, including sgvaultuser.

Thanks

[jclausius]

You do not necessarily need an sgvault user.

You should modify Vault's web.config to something like:

<add key="ConnectString" value="Application Name='SourceGear Vault Server'; Connection Reset='false'; Server=NAME-OF-SQLSERVER-AND-NAMED-INSTANCE-IF-USED; Database=sgvault; User ID=USER-NAME-GOES-HERE; PASSWORD=PLAIN-TEXT-PASSWORD" />

Note the use of PASSWORD instead of PWD.

[Mirza]

Hi,

The problem is solved and the Product is awesome

Thank You for fast reply.