Web service on seperate server than database?

ajj3085 · Post by **ajj3085** » Tue May 16, 2006 7:12 am

HI all,

I'd like to move the sgvault and sgdragnet databases to our new production database server, but keep the web applications on the current server.

I started to look into how this can be done, but I hit a block as it seems that machinename\ASPNET user is granted DBO (and I assume this is the user that accesses the databases) and this account won't be reconized on the database server.

Do you support this configuration?

Thanks
Andy

Post by **jclausius** » Tue May 16, 2006 7:39 am

The machine's ASP.Net process account requires access to the database. By default, this is a LOCAL machine account, and won't be recognized on another machine.

In order to configure Vault/Dragnet in this manner, you will either need to use SQL authentication (the easiest configuration) or Windows authentication.

With SQL authentication, you will configure SQL Server to accept SQL Server authentication, and then upon Vault/Dragnet re-installation, tell the installer to use SQL Auth.

With Windows authentication, you will need to place both the Vault Server and SQL Server on the same domain, create a domain account, and then configure the Vault/Dragnet re-installation to use use a custom ASP.Net account. Configuration of the domain account is tricky, but the details can be derived from this post http://support.sourcegear.com/viewtopic.php?t=188

lbauer · Post by **lbauer** » Tue May 16, 2006 7:40 am

Vault and Dragnet do support having the web service on one machine, with databases on a separate SQL Server machine. For this to work, Vault/Dragnet needs to use either a custom account (usually domain account) that has access to the SQL Server machine, or use SQL Server authentication, rather than Windows Authentication for SQL Server.

The easiest way to do this would be to uninstall Vault/Dragnet, keeping the databases, then move your databases by backup/restore or detach/attach. Then reinstall, using either a custom account for the IIS Process Model or use SQL Server authentication, which creates an sgvaultuser/sgdragnetuser account in SQL Server. For details on these configurations, see the installation guides:
http://www.sourcegear.com/vault/support ... orial.html

http://www.sourcegear.com/dragnet/suppo ... tall1.html

You can also move the databases, then manually make all the changes.

To change to a custom account, use the Identity Switcher:
http://support.sourcegear.com/viewtopic.php?t=2953

Then make changes to SQL Server and to the respective web.config files per this KB article. If you're going to use SQL Server authentication, modify the instructions for Dragnet by creating the sgdragnetuser, rather than sgvaultuser.

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

ajj3085 · Post by **ajj3085** » Tue May 16, 2006 7:45 am

Great,

Thanks for the help!

Andy