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 Manual Installation of SQL Express (2008 - 2012)
    • 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

     
     Questions about this article, topic, or product? Click here. 

    Manual Installation of SQL Express (2008 - 2012)

       
      Applies To 
       
      Product(s): SELECTserver
      Version(s): 09.00.00.113
      Environment:  Window Server 2008 64 bit, Windows 7 32 bit, Windows 7 64 bit, Windows Vista 32 bit, Windows Vista 64 bit
      Area:  Installation / Configuration
      Subarea:  SQL Installation
      Original Author: James White, Bentley Technical Support Group
       

     

     

     

     

     

     

     

     

     

     

    The SQLExpress application is developed  by the Microsoft corporation. There is no "special "Bentley" build of the SQL Express application. The application delivered is the exact same version available for free from Microsoft.  The nameing conventions discussed in this docuement are generic. You can use names more specifc to your environment. For example naming the databse SQLExpress_2012 was just a choice. You can very well name the databse (abc123) as long as you are consistent with identifying the databes by that desginated name.

     

    Creating an Instance of an SQL Database

     

    Navigate to the SelectServer_09_xx_xx_xx folder (by default this is
    found at c\bentleydownloads) and choose the SQLEXPR3_2.EXE OR SQLEXPR_64.EXE and
    take the following steps.

     

    For this example I am iinstalling SQL 2012 on a Server 2008 R2 64 bit.. The process is exactly the same for SQL server 2008 and 20012.

    Run SQLEXPR_x64_ENU.exe:  Right-Click (RUN AS ADMINISTRATOR). Be Patient.

     

    GO to OPTIONS and ensure you install the version that matches your System (32 or 64 ) bits.

     

     

    Go to INSTALLATION and SELECT: New SQL Standalone installation (upper right)

     

    Accept the Licensing

    Terms:

     

     

    Instance Configuration: Name the instance: NEXT. For this example I choose SQLExpress_2012

     

     

    Server configurations: Take the Defaults and NEXT

     

     

    Database Engine Configuration:
    Choose MIXED Mode and enter a “STRONG WINDOWS “password.  Select NEXT

     

     

     

    Error Reporting:  (DEFAULT) NEXT

     

     

    Installing Progress:

     

     

    Complete:  CLOSE

     

     

    CLOSE THE SQL SERVER INSTALLER CENTER!!!!!

     

     

    Configuring the installed SELECTServer application to use the the new SQL Express instance.

    Open the Database Setup Tool for the START button.

     

     

    Direct the application to the new INSTANCE NAME in our case "SQLExpress_2012" and enter the proper password for the INSTANCE. The user name is still “sa”.  SELECT OK

     

     

    Create a new Database: Select the “NEW” button and name the database.

     

     

    It will now tell you the database is not configured so select “OK” to allow the system to build the database schema.

     

     

    You’ll see the scripts run

     

     

    Database Setup Tool dialog box closes.

     

    Open the Administrative site and follow normal configurations steps using the SELECTServer installation wizard.

     

     

     

     

    • FAQ
    • Windows 7 32 bit
    • Installation / Configuration
    • Windows 7 64 bit
    • Windows Vista 32 bit
    • 09.00.00.113
    • Windows Vista 64 bit
    • Window Server 2008 64 bit
    • SELECTserver
    • SQL Installation
    • SELECTsupport
    • Share
    • History
    • More
    • Cancel
    • James White Created by Bentley Colleague James White
    • When: Mon, Aug 12 2013 10:49 AM
    • James White Last revision by Bentley Colleague James White
    • When: Mon, Aug 12 2013 11:02 AM
    • Revisions: 3
    • Comments: 0
    Recommended
    Related
    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