Scribd Logo
Upload

Welcome to Scribd!

  • 14 views

    MSSQL

    Uploaded by

    iam iam
    The document provides instructions for installing SQL Server Express and configuring it for use with G/Technology products. Key steps include selecting the Database Engine Services feature during installation, configuring the SQL Server service to use a local system account, and setting passwords and administrators as needed.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd

    MSSQL

    Uploaded by

    iam iam
    14 views2 pages
    The document provides instructions for installing SQL Server Express and configuring it for use with G/Technology products. Key steps include selecting the Database Engine Services feature during installation, configuring the SQL Server service to use a local system account, and setting passwords and administrators as needed.

    Original Title

    mssql

    Copyright

    © © All Rights Reserved

    Available Formats

    PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    The document provides instructions for installing SQL Server Express and configuring it for use with G/Technology products. Key steps include selecting the Database Engine Services feature during installation, configuring the SQL Server service to use a local system account, and setting passwords and administrators as needed.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    14 views2 pages

    MSSQL

    Uploaded by

    iam iam
    The document provides instructions for installing SQL Server Express and configuring it for use with G/Technology products. Key steps include selecting the Database Engine Services feature during installation, configuring the SQL Server service to use a local system account, and setting passwords and administrators as needed.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    of 2

    Setting Up SQL Server Express Page 1 of 2

    Setting Up SQL Server Express


    The following G/Technology products require SQL Server Express (unless the full version of SQL Server is
    used instead):
    n MobileViewer — Disconnected field users use SQL Server for the subset database.
    n MobileViewer Publish Subset — SQL Server is used to create the regional subset databases of feature
    attributes and connectivity data that MobileViewer uses in the field.
    n NetViewer Server — (unless Oracle is used as the NetViewer Server Web Client Context database) SQL
    Server can be used to hold user-specific context information (known as the Web Client Context Database).
    SQL Server Express database size limit
    The database size limit for SQL Server 2012 SP3, SQL Server 2014, and SQL Server 2016 is 10GB (excluding
    log files).

    To install SQL Server Express:


    1. From the Microsoft® site, select the appropriate SQL Server Express version. If you do not have the
    appropriate prerequisites installed, a message to install the missing software and restart the installation
    appears. See the G/Technology Supported Environments for more information.

    For Publish Subset or SetSubsetRoles.exe, you need to load SQL Server Management Studio.
    2. On the SQL Server Installation Center screen, click New installation or add features to an existing
    installation.
    3. Click Next.
    4. Accept the license terms.
    5. Click Next.
    6. On the Feature Selection screen, check the Database Engine Services feature only. If other boxes are
    checked, clear them.
    7. Click Next.
    8. On the Instance Configuration screen, review the instance name, and change it if necessary.
    9. Click Next.

    On the Server Configuration screen, review the credentials that are used for the created services. For
    the SQL Server Database Engine service, select NT Service\MSSQL$SQLEXPRESS from the Account
    Name column drop-down list. See the example below:

    10. On the Database Engine Configuration screen, do the following:


    n Select Mixed Mode (SQL Server authentication and Windows authentication).
    n Type a strong password and confirm it in the Specify the password for the SQL Server system
    administrator (sa) account fields. For Publish Subset, the sa password cannot contain a semicolon (;).

    mk:@MSITStore:C:\Program%20Files%20(x86)\Intergraph\GTechnology\Program\Resd... 12/16/2022
    Setting Up SQL Server Express Page 2 of 2

    n In the Specify SQL Server administrators field, review the people who should have unrestricted
    access to the database engine. Add or remove administrators as needed.

    11. Click Next.


    12. Review the Error Reporting settings and set as needed.
    13. Click Next.
    14. Click Close on the Complete screen.

    After completing installation, check the SQL Server Service to verify that the SQL Server service is set to Log
    on as Local System account.

    Database Upgrade
    If you attach a database created from an older supported version of SQL Server Express (for example, a
    MobileViewer subset or NetViewer Web Client Context database) it is automatically upgraded to the version on
    the machine.

    mk:@MSITStore:C:\Program%20Files%20(x86)\Intergraph\GTechnology\Program\Resd... 12/16/2022

    You might also like