Warning: Making these changes can cause serious, system-wide problems within your environment. Do not make these changes unless you are confident with these steps and understand the impact to your system and other applications running on it.
Problem: When attempting to “Start” the Bentley SELECTserver service, you may receive the following message:
"Error 1068: Windows could not start the Bentley SELECTserver service on local Computer. The dependency service or group failed to start".
This typically happens after upgrading the SELECTserver while having additional SQL Server instances installed. The SELECTserver service assigns as dependencies for all SQL instances that exist and cannot start unless these services are also started.
Solution: To start the Bentley SELECTserver service, you can either start the service dependencies listed on the SELECTserver service or remove them if they are no longer applicable.
To remove the dependencies, first verify the SQL Service(s) that will be used as a dependency of the Bentley SELECTserver service. Open the Bentley SELECTserver service and click properties and select the Dependencies tab.
From a command prompt type the following:
sc config “Bentley SELECT Server” depend= MSSQL$SELECTSERVER
Enter the SQL service dependency name to assign. By default, in the example above we will “assign” the MSSQL$SELECTSERVER component as the dependency. This may vary depending on what version of SQL Server is installed or SQL Instance used.
· This will only assign the component entered as a dependency of the Bentley SELECTserver service and remove all others.
· Start the Bentley SELECTserver service.
**Note: See below for additional uses of the SC command
To add additional components as dependencies, you will need to enter the command with a “/” forward slash separating each component. Example:
sc config “Bentley SELECT Server” depend= MSSQL$SELECTSERVER/MSSQLSERVER
· Both services (MSSQL$SELECTSERVER and MSSQLSERVER) will need to be started in order to have the SELECTserver service running.
To remove all service dependencies and start over, enter the following command:
sc config “Bentley SELECT Server” depend= “”