This topic explains how to run the scripts required to setup the Image (osImage) and Patient (ukctocs) databases required by the URA System using SQL Server 7.0.
Follow these steps using Enterprise Manager. You will find the scripts in the program's installation directory within the DbScripts subdirectory
Remove any pre-existing osImage database and any URA Stored Procedures on ukctocs
Logon to your database as a System Administrator (sa)
Create a login for URAAdmin
default database is master
access to model, master, temdb
access to ukctocs with permissions
security admin
access admin
data reader
data writer
Login as URAAdmin
Create the osImage database - accept defaults
Create the ukctocs database (if not already created)
Run the script CreateImageDbTablesSQL7.sql
Run the script CreateImageDbStoredProcsSQL7.sql
Run the script CreatePatientDbTablesSQL7.sql (if not using an existing ukctocs database)
Run the script CreatePatientDbStoredProcsSQL7.sql
Run the script PopulatePatientTablesSQL7.sql (remove these records at the end of the UAT by running CleanPatientTablesSQL7.sql)
Create the following logins
URAOperator
default database is osImage
access to ukctocs with permissions
data reader
data writer
URAGuest
default database is osImage
access to ukctocs with permissions
data reader
data writer
Grant execute permissions to all users - see Stored Proc List
Prepare the program's config file
Run UAT
Run the script CleanPatientTablesSQL7.sql
Prepare for move into production