When you start the WhosOn Administrator for the first time the Create Database Wizard will automatically start. This Wizard will create a new empty WhosOn Database. The WhosOn database must be created before you can start using WhosOn.

 

 

You now need to select the Database to use to store your WhosOn Data. Currently WhosOn supports SQL Server 2005 or SQL Server 2008 (full or 'express' editions).

 

Note: The database server must be installed and running before you proceed any further.

 

See: Installing A Database Server

 

Click Next to continue.

 

 

The following settings do not normally need to be changed. They only need to be changed if you want to use a database server that is running on a different PC than WhosOn.

 

For SQL Server you must select the SQL Server Instance – this is the computer name on your network that’s running the SQL Server you want to use. It defaults to your current PC name. Note: If you want to use a SQL Server that is on another PC you may need to enter the instance as PCNAME\SQLServerInstanceName

 

Check the Use NT Authentication option if you want WhosOn to use Windows integrated login security (this is the default and should always be used unless you have changed the security settings on the WhosOn Database). Otherwise you must specify the User Name & Password.

 

Click Next to continue.

 

 

Enter the Database Name. This defaults to WhosOnV6 and normally does not need to be changed. At this stage you can also change the default location of the database.

 

Click Next to create the database.

 

 

The Wizard will then display the Current Database Configuration once the database has been successfully created.

 

You can start the wizard again by selecting Configure WhosOn Database from the File menu. You can then remove the database by clicking the Remove Database button.

 

Click Finish to close the Wizard.

 

Notes: For the simplest and quickest way of setting up WhosOn, we recommend using SQL Server 2005 or 2008 Express Edition on the same PC as WhosOn. Then you can simply run through this wizard and accept the defaults.

 

Now See: Quick Start