Creating the Database: with SQL Server Administrator Credentials
To create the CAM database when you have SQL Server administrator credentials:
- Identify the machine on which to install the CAM database. This machine must have a supported version of Microsoft SQL Server installed. See Product Requirements.
- From the machine where you installed the tools, bring up a DOS prompt from the folder where you installed the tools (typically, C:\Program Files (x86)\Cherwell Asset Management\Database Tools.
dbinstall.exe with the following parameters:
/d <cam-database-name> /U <cam-database-user> /P <cam-database-user-pwd> /S <database-server-name[\instance]> /A <SQL-server-admin-user> /B <SQL-server-admin-pwd>
The following example creates the CAM database (as CAMDB), creates the user that Cherwell Asset Management components use to connect to the database (CAMUser, mypassword), and initializes the CAM database on the
sql2014instance of the SQL server named
dbinstall.exe /d CAMDB /U CAMUser /P mypassword /S myserver\sql2014 /A sa /B sapwd
If your Windows domain account has SQL Server administrator privileges, you can use the
/Noption in place of the
/BSQL credentials options.