Configure 3D for concurrent users on a terminal server

The setup for 3D prompts for a "storage location" which by default is a non-user-specific location like "C:\WhereScape\3D\". This configuration is intended for a single user PC and in this configuration you will not be able to start a second concurrent session of 3D on the same computer because the first session will have locked the files in this location. The second session of 3D started will detect this and automatically shut down.

Configure 3D for concurrent users during Installation

To enable multiple users to run 3D concurrently on the same computer (e.g. when the computer is being used as a Terminal Server), you need to select a user-specific storage location during the installation process so that each user has a separate profile, i.e. when installing 3D for each user select the "C:\Users\<user name>\3D" option for the "Store files in:" location.

Configure 3D for concurrent users after Installation

If you have already installed 3D and chose the "C:\WhereScape\3D\" option (or another non-user-specific location) to store files in, then you can manually change it by following these steps:

  1. Copy the content of C:\WhereScape\3D\ to a new folder of C:\Users\<user name>\3D *for each user that will log on to the computer and use 3D*
  2. Delete the original C:\WhereScape\3D\ folder

This will set up each user with their own repository and settings and they will be able to work concurrently.

Adding a New User and Connecting to a Repository

To add a new user and connect to a repository...

Tip

Before you add a new user and connect to a repository, log into the repository database you want to connect to using a SQL editing tool and using a user who has createrole permissions and can connect to the database.

  1. Run the following script to create a user...
    CREATE USER "testuser" WITH LOGIN PASSWORD 'testpass';
  2. Run the following script to grant database access to the user...
    GRANT CONNECT ON DATABASE "databaseName" TO "testuser";
  3. Run the following script to grant permissions to the above created user to access all the metadata tables...
    GRANT ALL ON SCHEMA "wsmeta" TO "testuser";
GRANT ALL ON ALL TABLES IN SCHEMA "wsmeta" TO "testuser"
GRANT ALL ON ALL SEQUENCES IN SCHEMA "wsmeta" TO "testuser"

Note

If a repository has been upgraded, it is recommended to log back into the database and reapply the above queries for all users that can connect to the database. This is required to ensure there are no permission issues that will block the general usage of WhereScape3D.


  • No labels