Product(s):	Bentley Raceway & Cable Management
	Version(s):	CONNECT Edition.
	Environment:	N/A
	Area:	Installation and Configuration
	Subarea:	SQL database configuration.

Background

For users to successfully connect and use a SQL project database with Bentley Raceway and Cable Management, SQL server requires minimum permissions to be assigned.
Various issues and error messages can occur when the SQL server is not configured properly.
The typical username used in Bentley Raceway and Cable Management is BRCMUser.
The login used for a particular project is specified by the value of UID in the configuration variable BRCM_DB_CONNECTSTRING defined in the BRCM.cfg file for the WorkSet or in the ProjectWise Configuration Block.
This article describes how to configure the SQL server with the minimum permissions for connecting to the database.

Steps to Accomplish

1. Launch the SQL Server Management Studio and connect to the server.



2. In the Object Explorer tree expand Security and then expand Logins.


3. Create the login if does not exists.

4.Right Click the login and select Properties.


5.On the Server Roles page enable the following:
-bulkadmin
-public



6.On the User Mapping page, select the database used by the application and specify ‘dbo’ in the default schema column.


7. In the Database role membership area enable:
-db_datareader
-db_datawriter
-ddl_admin
-public

Or enable:
-db_owner
-public

disable:
-db_denydatareader
_db_denydatawriter

8. Click Ok. The minimum SQL user permissions are configured.

Still a Problem?

If above problem still persists, then please create a Service Request and contact the Bentley Product Advantage group.  Please include a list of all relevant details to get in depth analysis for a solution or workaround.