Installing the Alpha Release of Archaeology Note Book

You can install the software in two scenarios. First as a single install for your own personal use. Second you can install this for use with a server.

Single System Install

If you would like to install this for testing, please contact Dr. Anderson at scot@southern.edu to obtain binarys.

1. You must install Sql Server 2008. This is available on the CD we distributed at the training.

2. Run the InstallSQL.bat first This will silently install SQL Server in the right location.

3. Run the setup.exe. This will install the Archaeology Note Book application.

4. After the setup completes you will have a Sql Scripts directory on your desktop. These must be run in SQL Management Studio in the following order:

   1. 00_CLR_INTEGRATION_ON.sql

   2. 00_ConAggregate.sql

   3. 00_CREATE_ALL_v3.sql

In future versions we will make this into one install process. You do not need 00_DESTROY_ALL.sql, but it is included in case you need or desire to wipe out the tables and views and start with a fresh database.

Once that is completed, you can start the application from your start menu.

Server Install

This scenario uses a server that clients can synchronize the photos and database records to.

Server setup

We used a virtual machine just in case we needed to move the server to another physical machine plus it makes an easy backup point.

1. Install windows server on a virtual machine:
   1. Install windows server
   2. Install Virtual Box guest additions or VMware tools if you are using a virtual machine.
   3. Install a windows domain (let the install put in the DNS server as well).

   4. Create two shares on the server, one for photos and one for drawings. Note the two share paths for later.

2. Install SQL Server on the windows server. Make sure to install all components having to do with replication as later we will setup the clients to subscribe to this database.
3. Install the database by running the scripts:

   1. 00_CLR_INTEGRATION_ON.sql (Turns on CLR integration so that you can install SQL extensions)

   2. 00_ConAggregate.sql (This installs ConcatAggr.dll as an extension to SQL Server)

   3. 00_CREATE_ALL_v3.sql (This creates the tables, views etc.)

4. On the server follow the directions here

Client setup

It is imperative to install an operating system that can connect to a windows domain (no starter editions). We are using Windows 7 Enterprise on netbooks.

1. Join the computer to the domain.

2. Add the group SquareSupervisors (or whatever group you put the users in) as administrators of the local computer. This isn't strictly necessary, but it makes the install process a bit easier.

3. Do all installs as the user from here on out. Make sure that the user you will use is in the SquareSupervisors group.

4. Make sure that \\[server]\Photos and \\[server]\Drawings are available off line.
5. Install SQL Server Express
   1. Install Database Engine Services, SQL Server Replication, Management tools, SQL Client Connectivity SDK, MS Sync Framework
   2. Install in mixed mode so that you can use the SA account.
   3. Install the service packs (if necessary).

   4. Add the group SquareSupervisors (or whatever group you put the users in) as administrators of the SQL server.

   5. Make sure the SQL Browser service is running.

6. Follow the client install directions here.

7. Run setup.exe and test the application