Option 2: Database user with "DB_Owner" authorizations
The second way to prepare the database is to use a previously created database user with the database role DB_Owner. A database user must be created for this purpose (default user name: xSuiteService).
The database for xSuite Bus Prism must be created manually. Once created, the database user xSuiteService must be assigned to this database as DB_Owner.
Notice
Merely setting up a database user account will not suffice. The user must explicitly be assigned the xSuite Bus database with the role DB_Owner.
Notice
The collation of the xSuite Bus Prism database must be Latin1_General_CI_AS.
When testing the connection to the database during the xSuite Bus setup, the following dialog will appear:
 |
This dialog informs the user that it was possible to connect to the database server and to the database.