ConstructSim Work Package Server Setup Guide

To Set Up a Database with Snapshot Isolation Enabled

This procedure only applies to the App Server Database.

  1. Go to the Start menu > All Programs > Microsoft SQL Server 2012 > SQL Server Management Studio and in the dialog that opens, connect to the server.
  2. In the Object Explorer pane, right-click Databases and from the pop-up menu select New Database. The New Database dialog opens.
  3. In the Database name, enter a logical name for the new database.
  4. Click OK to create the new database. The new database is created and is located under the Databases node in the Object Explorer.
  5. Select the new database you created and from the toolbar, click New Query.
  6. In the new query window, enter the command: ALTER DATABASE [new database name] SET ALLOW_SNAPSHOT_ISOLATION ON
  7. Click Execute to run the query.
    The "Command(s) completed successfully" message appears. The database now supports SNAPSHOT_ISOLATION.
  8. In the Object Explorer pane, under the Security node, right click Logins, and from the pop-up menu select New Login. The Login - New dialog opens.
  9. In the Login name, enter YourDomain\, followed by the user name you will use for setup. For more information about the default login, refer to the administrator of your environment. If you set up a local project, this is your account.
  10. Close Microsoft SQL Server Management Studio.