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.
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 -public6.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_denydatawriter8. Click Ok. The minimum SQL user permissions are configured.
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.