Creating a database from the command line

Question:
I am following the instructions in the ConfigControl guide to create a database using MSSQL from the command line but it is not working. What am I doing wrong?

Answer:
The earlier versions of the documentation are incorect. The correct way is like this:
Execute this set of code first to create the database

CREATE DATABASE ConfigControl ON PRIMARY (NAME = N'ConfigControl',
FILENAME = N'c:\ConfigControl.mdf', SIZE = 50MB, FILEGROWTH = 10%)
COLLATE Latin1_General_CI_AS;

Then Execute this set of code to create the user
CREATE LOGIN ConfigControlUser
WITH PASSWORD='ConfigControlpw',
DEFAULT_DATABASE = ConfigControl;
USE ConfigControl;
EXEC sp_changedbowner ConfigControlUser;

What database does ConfigControl use

Question:
What database does ConfigControl use? I noticed that you do not specify a database on the command line.

Answer:
ConfigControl uses the default database for the user that you specify on the command line. That is why you want to create a specific database user.

Intilizing the ConfigControl Database

Question:
How do I initialize the ConfigControl Appliance:

Answer:
This can only be done from the Appliances command line, and you MUST be logged on as the user configcontrol. If you try and initialize ConfigControl as "root" unexpected errors will occur.

You can use two different to initialize the appliance, the first is by typing all the switches/variables from the command line, the other is to create a file with the switches/variables pairs and then reading this file.

Doing it all from the command line:

configcontrol -initialize -dbType SQLServer -dbHost 10.22.71.25 -dbUser ConfigControlUser -dbPassword xyz123 -vcName TFentonVCA -vcHost 10.22.71.20 -vcUser administrator -vcPassword 123xyz

Doing it with a file:
Create a file called ConCon.cnf with the following:
dbtype=SQLServer
dbhost=10.22.71.25
dbport=1433
dbuser=ConfigControlUser
dbpassword=xyz123
vchost=10.22.71.20
vcuser=administrator
vcpassword=123xyz

b. Then run the following (capitalization matters)
configcontrol -initialize -configFile ConCon.cnf