Because system configurations and individual company standards vary, use this section as a checklist instead of step-by-step instructions for Microsoft SQL Server. Please contact Intergraph Customer Support for specific configuration questions.
You need Microsoft SQL Server Client if:
-
The computer is an administrative workstation.
-
You plan to run Project Management on the computer.
You do not need to install Microsoft SQL Server Client if:
-
The computer is used for general design work (piping, HVAC, and so forth).
-
You are using Oracle as your database provider.
-
There are internationalization considerations concerning the SQL Server collation settings you specify that relate to reference data, using SmartPlant Enterprise integrated systems, Global Workshare Configuration, multiple locales, backup/restore, reports, and upgrading to future releases. Please contact Intergraph Customer Support for specific configuration questions.
-
If you are using a XenApp 6.5, XenApp 7.6, or XenDesktop 7 RDS local data store (farm), you must install Microsoft SQL Server Client before installing XenApp 6.5, XenApp 7.6, or XenDesktop 7 RDS.
-
Insert your Microsoft SQL Server DVD, and start the setup program.
-
From the Planning page, select System Configuration Checker to check for pre-requisite applications and identify potential installation problems. You might have to restart your computer if any pre-requisite applications were installed.
-
Click Installation, and then select the New SQL Server stand-alone installation or add features to an existing installation option.
-
Enter your SQL Server 2014 product key provided by Microsoft, and click Next.
-
Accept the license terms, and click Next.
Wait while the SQL Server Setup files are installed on the computer.
-
Click Next.
-
On the Microsoft Update page, check Use Microsoft Update to check for updates based on your company's policy. Click Next.
Wait while the setup files are installed.
After the setup files are installed. Review the results for any failures that must be fixed before you continue. Click Next.
-
On the Setup Role page, select SQL Server Feature Installation, and click Next.
-
Select these client features:
-
Client Tools Connectivity
-
Management Tools - Basic
-
Management Tools - Complete
-
-
When you get to Installation Rules, make sure all operations have passed.
-
From Ready to Install, click Install.
-
When the installation has been completed, review the summary log file for any problems.