Page Comparison

...

In order to set up the database in SQL Server, log in to your Microsoft SQL Server Management Studio and do the following:

Create a new Security Login as shown here:

Right click on Security and select New, then Login. The user name is pacs, with a password of pacs. Do not enforce the credential policies, and select English as the language.

Create the database as shown here:

Right click on Databases and select New Database. You can get fancy with the database files, but that is not addressed here.

Create the database user as shown here:

Expand the pacsdb database, and right click on Security. Select New, and then User. User name of pacs, Login name of pacs, and select the Database Role Membership options of db_datareader, db_datawriter, and db_owner.

Create the dcm4chee schema:

1. Log out of the SQL Server Management Studio, and log back in as the pacs user.
2. Right click on the pacsdb databse, and select New Query.
3. In the query window, paste the entire contents of dcm4chee/sql/create.mssql.
4. Highlight/select all of the SQL statements, and click on Execute.

Create the Audit Record Repository (ARR) artifacts:

If you did not modify the ARR datasource file (dcm4chee/server/default/deploy/arr-mssql-ds.xml) to use the same pacsdb database, you'll need to perform some of the above steps to create the ARR database.

...