SQL Server 2008 Installation Guide

SQL Server 2008 Installation

TITLE:

SQL Server 2008 Installation

DATE:

01/10/2014

SUBJECT:

Installation of SQL Server 2008 for an Enterprise vault

ABSTRACT:

Installation guide for SQL Server 2008 for an Enterprise vault.

This guide is written for installing a new instance of SQL Server 2008 as it relates to SolidWorks Enterprise PDM. For a complete set of installation instructions, as well as system and software requirements, please use the following link.

SQL Server is a database program, and is a required component of a SolidWorks Enterprise PDM vault installation. The SQL Server is used to manage the metadata for the files in the vault. The information in the SQL database should NEVER be manually modified. All modifications should come through the Enterprise Administration Tool or through a client interface.

2. Check compatibility with the version of Enterprise you are running.

The following table lists the compatibility between Solidworks Enterprise and SQL 2008

SQL 2008

SQL 2008 R2

SolidWorks Enterprise PDM 2009

YES

NO

SolidWorks Enterprise PDM 2010

YES

YES

SolidWorks Enterprise PDM 2011

YES

YES

SolidWorks Enterprise PDM 2012

YES

YES

SolidWorks Enterprise PDM 2013

YES

YES

SolidWorks Enterprise PDM 2014

YES

YES

3. For local installations, be sure to run Setup as an administrator. If you are installing from a network folder, you will need to use a domain account that has read and execute permissions for that folder.

4. If Enterprise PDM is already installed on the system you will need to uninstall the Microsoft SQL Server 2005 Backward Compatibility package before you install SQL Server 2008.

5. Microsoft .Net 3.5 SP1 and Windows Installer 4.5 are required for installing SQL Server 2008. If they are not installed, the Installation Wizard will install them before launching the SQL Server 2008 installation. You may need to restart the system after these installations.

Right click Computer and select Manage. Under Features, click Add Features to open the Add Features wizard

In the Add Features Wizard, on the Features page, expand .Net Framework 3.5.1 Features and select .Net Framework 3.5.1 (Installed).

7. All installations should be done from the files supplied by SolidWorks.

8.Port 1433 will need to be opened, for TCP and UDP traffic, on any firewalls between the SQL server system and the Enterprise Archive server and clients

Installation

1. Close all Windows applications, including Windows Explorer

2. Launch the installation wizard by inserting the SQL Server 2008 media, or browsing to the install files, and launching Setup.exe. Use the default settings in this wizard unless otherwise specified.

3. In the SQL Server Installation Center window, click on Installation in the left pane. Then click New installation or add features to an existing installation. This should bring up the SQL Server 2008 Setup window.

4. In the Setup Support Rules screen, the installer checks for problems that might prevent the installation of the SQL Server support files.

If no problems are found, click OK.

If there are problems;

-Click Show details to list the failed components.

- Make note of the failed components, then click Cancel to stop the installation and fix the problems.

5. On the Product Key screen, if you are installing form the media supplied from Solidworks the product key should already be entered. Click Next on this screen.

6. Read and accept the license agreement. Click Next.

7. On the Setup Support Files screen click Install.

8. The installer runs another check for Setup Support Rules.

If no problems are found, click OK.

If there are problems;

-Click Show details to list the failed components.

- Make note of the failed components, then click Cancel to stop the installation and fix the problems.

Type a strong password for the system administrator (SA) account. Do not leave the password blank. For password rules, click Help.

Retype the password to confirm it.

Under Specify SQL Server Administrators, click Add.

In the Select Users, Computers, or Groups dialog box, enter the name of the local administrators of the system or the Administrators group.

Click Next

16. ***Optional***

On the Database Engine Configuration/Data Directories tab, you have the option of changing the default folder where the databases created by Enterprise PDM are stored. To do this, change the location for User database directory and User database log directory.

17. Do not change the settings on the Filestream tab.

18. On the Error and Usage Reporting screen click Next.

19. The installer runs another check for Setup Support Rules.

If no problems are found, click OK.

If there are problems

- Click Show details to list the failed components.

- Make note of the failed components, then click Cancel to stop the installation and fix the problems.