Installing Microsoft SQL Server Standard Edition

This procedure describes how to install Microsoft SQL Server Standard Edition for use with ArtiosCAD. You should only use this version if you have a dedicated database administrator available.

  1. Log in to your database server as an administrator.
  2. Run the setup program on the Microsoft SQL Server media.
  3. On the left side of the SQL Server Installation Center dialog box, make sure Planning is selected.
  4. On the right side, click System Configuration Checker.
  5. The checker will launch and automatically run. In the Global Rules dialog box, click Details, make sure all the items passed, and click OK.
  6. On the left side of the SQL Server Installation Center dialog box, click Installation.
  7. At the top of the content pane, click New SQL Server stand-alone installation or add features to an existing installation.
  8. In the Product Key dialog box, enter the product key and click Next.
  9. In the License Terms dialog box, check I accept the license terms and Privacy Statement and click Next.
  10. The setup program will automatically run the Global Rules checks (which you have already done) and advance to the Microsoft Update dialog box if it finds no issues needing further attention.
  11. In the Microsoft Update dialog box, check Use Microsoft Update to check for updates (recommended) and click Next.
  12. The Install Setup Files dialog box will show an action list and progress bar.
  13. The setup program will check for additional conditions which could affect operation or performance in the Install Rules dialog box. If any status says Warning, click Warning to see the issue. In this case it was a reminder to open the appropriate ports in Windows Firewall. Click Next.
  14. In the Setup Role dialog box, click SQL Server Feature Installation and click Next.
  15. In the Feature Selection dialog box, check the checkboxes for the following features. You may have to scroll down to see all the items in the list. You may also change the installation directories. Click Next when you are done selecting features. In the Instance Features group, select the following features in the Database Engine Services group:
    • Database Engine Services
    • SQL Server Replication
    • Full-Text and Semantic Extractions for Search
    • Data Quality Services
    In the Shared Features group, select the following features:
    • Client Tools Connectivity
    • Client Tools Backward Compatibility
    • Client Tools SDK
    • Documentation Components
    • Distributed Replay Controller
    • Distributed Replay Client
    • SQL Client Connectivity SDK




  16. The setup program displays a Please Wait banner while it runs the feature rule checks, and if all the rules pass, it skips the Feature Rules dialog box.
  17. In the Instance Configuration dialog box, you may use the Default instance if desired. To use a custom instance name, click Named instance and enter a sensible name. Do not use ArtiosCADDB, ArtiosCADExp2005, or Esko, as these will interfere with the installation of ArtiosCAD. If you use a custom instance name, make a note of the Instance ID as you will need it for the database scripts batch file later. Click Next.
  18. In the Server Configuration dialog box on the Service Accounts tab, review the service startup types and change them if desired.



    On the Collation tab, if you do not want to use the default collation (a group of location-related settings), click Customize and change it. Make sure to choose one that supports Unicode, is case-insensitive, and is accent-sensitive.



    Click Next.
  19. In the Database Engine Configuration dialog box, click Mixed Mode (SQL Server authentication and Windows authentication). For the password, enter a password of your own choosing that complies with your local password policy in both password fields. Make sure to record this password in a secure location as you will need it later. In the Specify SQL Server administrators group, click Add Current User to add yourself as a database administrator, or click Add to add other users or groups as database administrators. You must add at least one account. Click Next.
  20. Click Next in the Distributed Replay Controller and Distributed Replay Client dialog boxes. The setup program will run the rules in the Feature Configuration Rules dialog box automatically and if everything successfully passes, will proceed to the Ready to Install dialog box.
  21. In the Ready to Install dialog box, scroll down the list of actions and verify them for accuracy. Click Install to begin installing the software.



    A progress bar will appear.
  22. In the Complete dialog box, review the list of features to make sure they succeeded. Click Close.
  23. Click Install SQL Management Tools.
  24. In the Web page that opens, follow the instructions to download and then install SQL Server Management Studio if it is not already installed on this machine.
  25. Restart the computer if prompted. If not, close the SQL Server Installation Center.
  26. Open Windows Update and install updates for Microsoft SQL Server and related programs if it finds any.
Microsoft SQL Server Standard Edition is now installed and ready for you to configure it for use with ArtiosCAD.
Parent topic: Using Microsoft SQL Server Standard Edition with ArtiosCAD Standard Edition