SELECTserver 9.1: Updated OS and SQL compatibility for deployed users

Some of you may have noticed that a new version of SELECTserver has been posted in the Software Fulfillment Center for use on deployed license servers. This article is intended to explain what changed, who should upgrade, and why a move to Bentley's hosted SELECTserver is still recommended long-term.

What has changed?

Client usage reporting issue for V8i and CONNECT edition products

An issue affecting the ability of some V8i and CONNECT edition products on client machines to successfully report usage to SELECTserver has been addressed in this version. It has been known to cause rapid growth in the license database as well. The defect only affects servers with SELECTserver installed. Consequently, users of SELECTserver are strongly encouraged to upgrade when possible, especially if V8i or CONNECT edition products are in use.

Data Retention fix

In some cases, the Data Retention setting was failing to remove old usage data. A replacement stored procedure posted on Bentley Communities has been officially incorporated into this version.

Support for later operating systems

Starting with Windows 8 and Windows Server 2012, the implementation of IIS changed. SELECTserver and later has been updated to support IIS 8 and is now supported on the following operating systems:

  • Windows Server 2008
  • Windows Server 2008 R2
  • Windows Server 2012
  • Windows Server 2012 R2
  • Windows Server 2016
  • Windows 7
  • Windows 8.x
  • Windows 10

Support for later SQL Server instances

SELECTserver uses a Microsoft SQL Server instance to store the license database. SELECTserver and later now supports the following versions of SQL Server:

  • Microsoft SQL Server 2005, all editions
  • Microsoft SQL Server 2008, all editions
  • Microsoft SQL Server 2012, all editions except LocalDB
  • Microsoft SQL Server 2014, all editions except LocalDB
  • Microsoft SQL Server 2016, all editions except LocalDB

Who should upgrade?

This upgrade only applies to users who are configured to use a deployed (i.e. in-house) SELECTserver. Users of Bentley's hosted SELECTserver can disregard this update since they are always running the latest version available. Because of a usage reporting bug that affects users of SELECTserver, all users of SELECTserver are strongly encouraged to upgrade when possible. Users of SELECTserver and earlier are encouraged to upgrade as well because of the improved reporting features of SELECTserver 09.xx.

The following support solution provides detailed instructions for downloading, installing, and configuring SELECTserver For users that are performing an installation on a new server, note that SELECTserver 09.01.00.xx does not automatically install an instance of SQL Server, but the following support solution provides step-by-step instructions for downloading and installing SQL Server 2016 Express.

Why is Bentley's hosted SELECTserver still recommended?

In Q2 2016, Bentley introduced changes to the peak usage calculation used for the billing of SELECT users (i.e. not ELS or Academic users who are calculated differently). Instead of counting the number of times a product is used within a one-hour interval, product usage is now counted by a 10-minute interval. However, this change is only supported on Bentley's hosted SELECTserver, also known as SELECTserver Online or Bentley CONNECT SELECTservices. This is because SELECTserver, including version 09.01.00.xx, sends only the following information to Bentley:

  • Peak usage for products calculated using the one-hour interval
  • Hashed machine names and the dates when products were used
  • Hashed user names and the dates when products were used (for passports)

The start and stop times are not reported to Bentley from deployed servers, so there is no way to recalculate the peaks using the new 10-minute interval. Bentley has access to this data on the hosted server for recalculation efforts, hence the recommendation to migrate to the hosted server.

Other Language Sources