Installing SQL Server

To install SQL Server:

1. Download and install the Archivists' Toolkit client available from http://archiviststoolkit.org/download/release/2_0
2. Download and install MS SQL Server
3. Create a blank database in SQL Server
4. Initialize the blank database to work with the Archivists’ Toolkit client (using the AT Maintenance Program, located in the AT Program folder) Link to more information on the AT Maintenance Program: http://archiviststoolkit.org/support/InitializeDatabase
5. Launch the AT client and point to the SQL Server database

For MS SQL Server the connection URL should be in the form of jdbc:sqlserver://[host]:[port];databaseName=[database name]

A helpful link for installing AT with SQL Server as backend database (please note that the AT already includes the JDBC driver for SQL Server, so it is not necessary to install one or configure anything with Java) http://infolookup.blogspot.com/2010/01/installing-and-configuring-archivists.html