SOLIDWORKS Enterprise PDM SQL 2014 Installation Guide

This article provides step by step instructions for installing Microsoft SQL 2014 for use with SOLIDWORKS Enterprise PDM.

Assumptions

• You are using the Microsoft SQL 2014 DVD included in your purchase of SOLIDWORKS Enterprise PDM
• This is the first installation of Microsoft SQL 2014 and no previous versions of Microsoft SQL have been installed on the machine
• This installation of Microsoft SQL 2014 is only for use with SOLIDWORKS Enterprise PDM
• All software prerequisites are installed and all system requirements are met

For SOLIDWORKS Enterprise PDM system requirements please visit the SOLIDWORKS PDM System Requirements page.

Installation

Insert the Microsoft SQL 2014 DVD provided in the SOLIDWORKS Enterprise PDM installation media kit.

The SQL Server Installation Center window will appear automatically. If the window does not appear automatically, Auto-Run might be disabled on the machine. Double click on your DVD/CD device and or run the setup.exe application to start.

1. Select Installation in the SQL Server Installation Center window.
   
   
2. Click New SQL stand-alone installation or add features to an existing installation.
   
   
3. On the Product Key window, your product key will be filled in automatically. Click Next.
   
   
4. Read the License Terms. Select I accept the license terms. Click Next.
   
   
5. If the Global Rules wizard does not identify any problems, the wizard will automatically skip to the Microsoft Update section (step 6 below). However, this window will appear if there is an issue. You must correct the problem of any rules that did not pass and click Re-run. When finished, click Next.
   
   
6. Your choice here: decide if you would like to Use Microsoft Update to check for updates and click Next.
   
   
7. The Product Updates window will automatically be skipped if there are no updates to apply. Otherwise, apply any available updates.
   
   
8. If Install Rules wizard does not identify any problems, the wizard will automatically skip to the Setup Role section (step 9 below). However, this window will appear if there is an issue. You must correct the problem of any rules that did not pass and click Re-run. When finished, click Next.
   
   
9. Select SQL Server Feature Installation and click Next.
   
   
10. In the Feature Selection window, select the following features
    • Database Engine Services
    • Client Tools Connectivity
    • Integration Services
    • Client Tools Backwards Compatibility
    • Documentation Components
    • Management Tools - Basic
    • Management Tools - Complete
      
      Click Next.
      
      
      
      
11. If Feature Rules wizard does not identify any problems, the wizard will automatically skip to the Instance Configuration section (step 12 below). However, this window will appear if there is an issue. You must correct the problem of any rules that did not pass and click Re-run. When finished, click Next.
    
    
12. Select the Default instance and click Next.
    
    
13. In the Server Configuration section, under the Service Accounts tab, select the following Account Names:
    • For SQL Server Agent - select NT Service\SQLSERVERAGENT
    • For SQL Server Database Engine - select NT Service\MSSQLSERVER
    • For SQL Server Integration Services 12.0 - select NT Service\MsDtsServer120
    • For SQL Server Browser - select NT Authority\LOCAL SERVICE
      
      *Set all Startup Types to Automatic.
      Click on the Collation tab and continue to step 14 below.
      
      
      
14. Under the Collation tab, click Customize...
    
    
    
    Select the Windows collation designator and sort order.
    Select Latin1_General under the Collation Designator dropdown box.
    Click OK.
    
    
    Back in the Collation tab, Latin1_General_CI_AI is now selected. Click Next.
    
    
    
    
15. Select the Mixed Mode (SQL Server authentication and Windows authentication).
    
    Enter and confirm a strong password for the SQL Server system administrator 'sa' account.
    
    Your choice here: under Specify SQL Server administrators, click on Add Current User or click Add... to enter domain users and or groups that can
    have access to administrate SQL.
    
    Click Next when finished.
    
    
    
    
16. If the Feature Configuration Rules wizard does not identify any problems, the wizard will automatically skip to the Ready to Install section (step 17 below). However, this window will appear if there is an issue. You must correct the problem of any rules that did not pass and click Re-run. When finished, click Next.
    
    
17. Click Install. This process may take a while to complete.
    
    
18. Once the installation completes successfully, click Close.
    
    
19. Your installation of Microsoft SQL 2014 for SOLIDWORKS Enterprise PDM is now complete! You can now close the SQL Server Installation Center window and remove the installation DVD.
    
    

RElated Articles

Enterprise PDM SQL Maintenance Plan: Reorganizing and Rebuilding Database Indexes

Non-PDM File Management Recommendations

Workgroup PDM Installation/Upgrade