Bentley Communities
Bentley Communities
  • Site
  • User
  • Site
  • Search
  • User
  • Welcome
  • Products
  • Support
  • About
  • More
  • Cancel
Licensing and Activation
  • Product Communities
  • More
Licensing and Activation
Licensing and Activation Wiki Database Setup Tool Configuration and Explanation [FAQ]
    • Sign in
    • License Flowchart for Subscription Entitlement Service (SES) and legacy SELECTserver
    • +Understanding the Subscription Entitlement Service (SES) Workflow
    • Working from Home using Bentley Licensing
    • EVD Reporting Guide
    • -Understanding the (Legacy) SELECTserver Workflow
      • -SELECTserver TechNotes and FAQs
        • "An Error Has Occurred" when manually transmitting usage logs using a preconfigured URL
        • About SELECTserver
        • Connecting to the Bentley servers through Firewalls and Proxy Servers [FAQ]
        • Could not load type 'System.ServiceModel.Activation.HttpModule' from assembly 'System.ServiceModel...'
        • Data Update Service Warning [TN]
        • Database Maintenance
        • Database Setup Tool Configuration and Explanation [FAQ]
        • Deployed SELECTserver Database and Internet Connectivity Insight [TN]
        • Deployed SELECTserver issue with new Bentley SSL certificate
        • Deployed SELECTserver Knowledge Requirements [TN]
        • Deployed SELECTserver Technical Requirements [TN]
        • Enabling Diagnostic Logging for SELECTserver
        • Error 1068: Cannot start the Bentley SELECTserver service
        • Error 417 : in SELECTserver and GateWay logs
        • Glossary Of Licensing Terms [FAQ]
        • Group Policy Administration (ADM) files
        • How do I keep usage reports current?
        • How do I set up or prevent license checkouts?
        • How to create a new website in IIS7
        • How to create a Virtual Directory in IIS7
        • How To Install a Gateways on Vista and Windows 7, Server 2008
        • How to Install the SELECTserver application
        • How to migrate users to a custom activation group
        • HTTP Error 404.13 "The request filtering module is configured to deny a request that exceeds the request content length" when importing response file
        • HTTP Error 500.21 - Internal Server Error on SELECTserver Administrative Site
        • Import xml File on Deployed Server
        • IP Address Hosted Server
        • License and SELECTserver Administration [FAQ]
        • +License Manager
        • License Tool Command Line Options
        • Manual Installation of SQL Express (2008 - 2012)
        • Moving (relocating) the SELECTserver application to a new server.
        • Moving Your SELECTserver Database
        • +Older SELECTserver Versions
        • Opening Admin site pager starts (runs) installer process
        • Opening Administration Site
        • Restricting access to a deployed SELECTserver Administration Site. Configuration example (video).
        • Running the Data Update Service and restarting IIS in order to immediately update a deployed license
        • Schedule Report - no Parameter selectable
        • Security [FAQ]
        • SELECT Server 08 11 Series [CS]
        • +SELECTserver
        • SELECTserver 9 Known Issues
        • SELECTserver 9.xx.xx.xx Gateway Update Process [FAQ]
        • SELECTserver 9.xx.xx.xx Upgrade Information [FAQ]
        • SelectServer Client Access Restrictions technical overview (video).
        • SELECTserver Database Backup [TN]
        • +SELECTserver Gateway
        • SELECTserver Gateway error 1053
        • SELECTserver Gateway Explained
        • SELECTserver Gateway License Server Revoked License [TN]
        • SELECTserver Gateway Service Fails To Connect through Proxy Server [TN]
        • SELECTserver General [FAQ]
        • SELECTserver in a IPV6 Environment
        • SELECTserver Notifications
        • SELECTserver Online Technical Requirements [FAQ]
        • SelectServer V9 without connectivity and Bentley Passport
        • SELECTserver XM Database Backup [TN]
        • Server status - Log file
        • SQL Server 2005 Cachestore Flush Error
        • SQL Server Compatibility Mode - Internal Query Processor Error
        • Support Path User Registration [FAQ]
        • The response file corresponding to the following logs is not processed.
        • The SQL transaction logs are full
        • Transmit Usage Logs - 0 Logs Found To Process [TN]
        • Trust Licensing Basics [FAQ]
        • Unlock the SQL Server SA Account
        • Upgrading to SELECTserver 08 11 series [CS]
        • Upgrading to SELECTserver 08.11.xx.xx [TN]
        • Uploading SELECTserver Usage And Client Logs [TN]
        • Usage Log Processing - ERROR with status code 15014
        • Using Active Directory Group Policy Objects to Configure Licensing for Users Centrally (video).
        • What options are available to allow the external (WAN) user to access a Locally Deployed SELECTserver?
        • What's New in the latest SELECTserver?
    • +Product Activation TechNotes and FAQs
    • +Application Usage TechNotes and FAQs
    • +SELECTservices TechNotes and FAQs

    You are currently reviewing an older revision of this page.

    • History View current version

    Database Setup Tool Configuration and Explanation [FAQ]

       
      Applies To 
       
      Product(s): SELECTserver
      Version(s): All
      Environment:  N/A
      Area:  N/A
      Subarea:  N/A
      Original Author: James White, Bentley Technical Support Group
       

    The SELECTServer application is really two separate parts working in conjunction with each other. One part is the SELECTServer Administration Site interface. This is where all actions concerning the SELECTServer application are viewed and completed. The other is the actual SQL Database. This contains your physical licensing information along with your specific site configurations and usage information. When viewing the SELECTserver Administration site the bulk of the information in front of you is pulled directly from the SQL database and presented on the page. The rest is static information to allow you to navigate to the requested information. All of this brings us to the connecting and often forgotten piece of the SELECTserver application the DATABASE SETUP (DSU) tool.

    The Bentley SELECTserver Database Setup (DSU) tool is the interface for connection to your SQL Database for both the Express and Fully Deployed versions. The DSU defines the user that has permission to actually do the work in the database. The default and preferred method of defining this user is to us a “Specific Username and Password”. This is configured by using a radio button under the SERVER section of the DSU. The other option is the “Use windows NT Integrated Security”. More information concerning that configuration is located in the SELECTserver HELP file.

    Please keep in mind for the conversation concerning this document that this utility we are viewing is for the most part “automatically filled in” during the SELECTServer installation process with the default configurations being the “sa” user and a password implemented by the Administrator during the install. The point of this document is to explain the utility and the configurations. Please note that the database “password” is entered by the administrator and is “NEVER” transmitted to Bentley Systems. The technical Support analyst will not be able to “tell you your password” for the database connection. When using your own privately purchased SQL Server Database or connecting to a different DB this information will help you understand the connections involved. With that said let’s get started.

    UNDERSTANDING THE DATABASE SETUP TOOL

    At the end of the installation process the installer will launch the SELECT Server Database Setup Utility. You will need to provide the following information about your database installation:.

    • Database Server Name and Instance name
    • Username and password of a database user with rights to create tables
    • Username of the user to run the service as (only needs insert rights, this is an optional setting)
    • Name of the database you wish to use.

    Let's review the componets.

    1. Upon completion of the installation process, the Bentley SELECT Server  Database Setup dialog box opens.

      or
    2. From the Start Menu, select All Programs > Bentley > SELECT Server > SELECTserver Database Setup.

    The Bentley SELECT Server Database Setup dialog box opens.

    This dialog box may appear slightly different between versions but the functionality remains the same. It will contain the following sections

     SERVER:
    Where you defined the server name, instance, and the account in charge of communicating with the Database

    Specific user:                           Default setting.
    Windows NT integrated security:       Optional

     Create Database As User:
    User Name:     (sa) The default user for a SQL Express installation
    Password:        Defined by the administrator during installation

      Run As User:
    Use the Same user as above:  Default setting when implementing a specific user

     This can be changed to run as a user with fewer privileges than the administrator (usually Database Owner “DBO”) but that would be left up to the Database Administrator for the site. Bentley Systems recommends the default settings and offers no guide lines on this alternate configuration. On a site where a fully developed SQL Server is deployed there should be a Database administrator (DBA) who will understand and be tasked with supporting this option internally for you.

     Database:
    The actual “room” defined in the database instance where your specific information will be stored and maintained.

     Database Information:
    Three notched tabs that contain specific information about the overall status, database details and server details. This information “cannot” be edited from this location.

    Let's review a real-world DSU Configuration

    This is a default install of SELECTServer 09.00.00.99 with a default SQL Express installation “delivered” during the install.

     SERVER:
    My server name is WHITJ1530EXT. The database instance is named SELECTSERVER

    Specific user:                                       Selected the “Use a specific username and password” option
    Windows NT integrated security:        (not implemented)

     Create Database As User:
    User Name:     sa The default user for a SQL Express installation system administrator
    Password:        Defined by the administrator during installation

     Run As User:
    Use the Same user as above:  Default setting when implementing a specific user
    The default installation has no need to implement the “run as user” option

     Database:
    Bentley03:  Just a name I choose when I selected the “NEW” button and created the database, There is no significance to the name. If connection to a fully deployed SQL Server there could be options available here.

          

    Database Information:
    Three notched tabs that contain specific information about the overall status, database details and server details of the defined database. This information “cannot” be edited from this location.

    To configure your SQL database

    1. Upon completion of the installation process, the Bentley SELECT Server Database Setup dialog box opens.

      or

      From the Start Menu, select All Programs > Bentley > SELECT Server > SELECTserver Database Setup.

          2.  Enter your SQL Server name in the Server text box.

               If you are not using the Default instance of SQL Server, you will need to provide the instance name (format
              of SERVERNAME\INSTANCENAME). You can always safely identify the INSTANCE and DATABASE name.

     

          3. Select the “Use a specific username and password” option.

              The SELECT Server service runs as system service; therefore it is not recommend you use
              Windows NT Integrated security.

         4. Enter the password for your database user in the Password field

         5. (Optional) If you are running SQL Server, you can set the Run As User option.
            The Database setup utility requires a user with administrative rights on the SQL Server in order to create the
             required tables and stored procedures. However when the SELECT Server application is running, you only
             need to have select, insert and delete rights to the database. If you do not want the SELECT Server application
             to run as the SQL Admin account, uncheck the “Use the same user as above check box and enter the
              User name and Password in the fields provided.

         6. Select the Database to be used by the SELECT Server application from the drop down list or click “New”
              and enter a new database name in the Create Database dialog box for example “bentley03”.

          

         7. Click “OK” to return to the Bentley SELECTServer application’s Database Setup dialog box. Allow the application 
             few minutes to complete its database task if needed. New databases have to create an appropriate working 
             area (database schema) for its license and usage storage.

         8. Clicking the ”OK” button once more completes the configuration process.

    Please feel free to contact Bentley Technical Support if you have questions or require additional assistance.

     

    See Also

    Product TechNotes and FAQs

    Licensing TechNotes and FAQs 

    External Links

    Bentley Technical Support KnowledgeBase

    Bentley LEARN Server

    SELECTservices page on Bentley website

    TechNotes and FAQ archive

    Comments or Corrections?

    Bentley's Technical Support Group requests that you please confine any comments you have on this Wiki entry to this "Comments or Corrections?" section. THANK YOU!

     

    Communities
    • Home
    • Getting Started
    • Community Central
    • Products
    • Support
    • Secure File Upload
    • Feedback
    Support and Services
    • Home
    • Product Support
    • Downloads
    • Subscription Services Portal
    Training and Learning
    • Home
    • About Bentley Institute
    • My Learning History
    • Reference Books
    Social Media
    •    LinkedIn
    •    Facebook
    •    Twitter
    •    YouTube
    •    RSS Feed
    •    Email

    © 2021 Bentley Systems, Incorporated  |  Contact Us  |  Privacy |  Terms of Use  |  Cookies