Repointing Databases

Ken T (33 posts)
January 30, 2015 12:52 PM
Accepted Answer

I have my default adtempus instance pointing to my Sales database.

I went ahead and created a Sales adtempus instance pointing to a adtempus_default database. :)

How do I repoint the adTempus instances so they point to the other database? I tried adtdbutil, but that looks like just a query tool.

Thanks for all your help.

Bill Staff (601 posts)
January 30, 2015 01:20 PM
Accepted Answer

If the databases don't already exist for the other instances, you need to run the Database Configuration Wizard. When you start it, it will ask you which instance you want to work with, and you can then create the database and configure adTempus to use it.

If you already have existing databases that you want to use, you can still use the Database Configuration Wizard to point adTempus to the right database, and have it create a login for adTempus to use, if necessary.

Alternatively you can edit the configuration directly in the Registry under "HKEY_LOCAL_MACHINE\Software\Arcana Development\adTempus\Instances\[instance name]\Database". If you're using integrated security and SQL Server is local, all you need are the "database" and "server" values. If SQL Server is on a different computer or you're using SQL Server security, you will need to configure accounts and permissions as described in the Security Setup section of this topic. If you use the Database Configuration Wizard it should handle all this for you.

Replies are disabled for this topic.