installation - ms sql server 2008

8/13/2019 Installation - MS SQL Server 2008

1/26

A Rohde & Schwarz Company

Microsoft SQL Server 2008Installation Manual

December 2012

SwissQual License AGAllmendweg 8 CH-4528 Zuchwil Switzerland

t+41 32 686 65 65 f+41 32 686 65 66 [email protected]

Part Number: 14-001-200909-1 Rev 1


2/26

SwissQual has made every effort to ensure that eventual instructions contained in the document are adequate and freeof errors and omissions. SwissQual will, if necessary, explain issues which may not be covered by the documents.SwissQuals liability for any errors in the documents is limited to the correction of errors and the aforementioned advisoryservices.

Copyright 2000 - 2012 SwissQual AG. All rights reserved.

No part of this publication may be copied, distributed, transmitted, transcribed, stored in a retrieval system, or translated

into any human or computer language without the prior written permission of SwissQual AG.Confidential materials.

All information in this document is regarded as commercial valuable, protected and privileged intellectual property, and isprovided under the terms of existing Non-Disclosure Agreements or as commercial-in-confidence material.

When you refer to a SwissQual technology or product, you must acknowledge the respective text or logo trademarksomewhere in your text.

SwissQual, Seven.Five, SQuad, QualiPoc, NetQual, VQuad, Diversity as well as the following logos areregistered trademarks of SwissQual AG.

Diversity Explorer, Diversity Ranger, Diversity Unattended, NiNA+, NiNA, NQAgent, NQComm, NQDI,NQTM, NQView, NQWeb, QPControl, QPView, QualiPoc Freerider, QualiPoc iQ, QualiPoc Mobile,QualiPoc Static, QualiWatch-M, QualiWatch-S, SystemInspector, TestManager, VMon, VQuad-HD aretrademarks of SwissQual AG.

SwissQual acknowledges the following trademarks for company names and products:

Adobe, Adobe Acrobat, and Adobe Postscript are trademarks of Adobe Systems Incorporated.

Apple is a trademark of Apple Computer, Inc.

DIMENSION, LATITUDE, and OPTIPLEX are registered trademarks of Dell Inc.

ELEKTROBIT is a registered trademark of Elektrobit Group Plc.

Google is a registered trademark of Google Inc.

i.Scan is a trademark of CommScope, Inc.

Intel, Intel Itanium, Intel Pentium, and Intel Xeon are trademarks or registered trademarks of Intel Corporation.

INTERNET EXPLORER, SMARTPHONE, TABLET are registered trademarks of Microsoft Corporation.

Java is a U.S. trademark of Sun Microsystems, Inc.

Linux is a registered trademark of Linus Torvalds.

Microsoft, Microsoft Windows, Microsoft Windows NT, and Windows Vista are either registered trademarks ortrademarks of Microsoft Corporation in the United States and/or other countries U.S.

NOKIA is a registered trademark of Nokia Corporation.

Oracle is a registered US trademark of Oracle Corporation, Redwood City, California.

SAMSUNG is a registered trademark of Samsung Corporation.

SIERRA WIRELESS is a registered trademark of Sierra Wireless, Inc.

TRIMBLE is a registered trademark of Trimble Navigation Limited.

U-BLOX is a registered trademark of u-blox Holding AG.

UNIX is a registered trademark of The Open Group.


3/26

Microsoft SQL Server 2008 Installation Manual

2000 - 2012 SwissQual AG

Contents |

CONFIDENTIAL MATERIALS

ii

Contents

1 Introduction .......................................................................................................................................... 1SQL Server 2008 Editions ..................................................................................................................... 1System Requirements ........................................................................................................................... 1

2 Installing SQL Server 2008 Standard Edition ................................................................................... 23 Installing SQL Server 2008 Express Edition ................................................................................... 124 Af ter You Instal l ................................................................................................................................. 18

Installing Service Packs ....................................................................................................................... 18Changing the Default Language to English ......................................................................................... 18Configuring Memory Usage (Standard Edition Only) .......................................................................... 19

5 Troubleshooting ................................................................................................................................ 21Cannot Import Measurement File ........................................................................................................ 21SQL Server and Windows Firewall ...................................................................................................... 22

Figures

Figure 2-1 Microsoft .NET message .................................................................................................................. 2Figure 2-2 Microsoft .NET 3.5 SP1 setup .......................................................................................................... 2Figure 2-3 Microsoft Windows Installer 4.5 ....................................................................................................... 3Figure 2-4 SQL Server Installation Center, Planning page ............................................................................... 3Figure 2-5 SQL Server Installation Center Installation page ............................................................................. 4Figure 2-6 Setup Support Rules page ............................................................................................................... 4Figure 2-7 Product Key page ............................................................................................................................. 5Figure 2-8 License Terms page ......................................................................................................................... 5Figure 2-9 Setup Support Files page ................................................................................................................. 6Figure 2-10 Feature Selection page .................................................................................................................. 6Figure 2-11 Instance Configuration page .......................................................................................................... 7Figure 2-12 Service Accounts page .................................................................................................................. 8Figure 2-13 Collation tab on Server Configuration page ................................................................................... 8Figure 2-14 Customize database collation ........................................................................................................ 9Figure 2-15 Customize Analysis Services collation ........................................................................................... 9Figure 2-16 Account Provisioning tab on Database Engine Configuration page ............................................ 10Figure 2-17 Ready to install page .................................................................................................................... 10Figure 2-18 Setup Complete page .................................................................................................................. 11Figure 3-1 SQL Server Installation Center Planning page .............................................................................. 12Figure 3-2 SQL Server Installation Center Installation page ........................................................................... 13Figure 3-3 Feature Selection page .................................................................................................................. 14Figure 3-4 Instance Configuration page .......................................................................................................... 14


4/26



Contents |


iii

Figure 3-5 Service Accounts page .................................................................................................................. 15Figure 3-6 Customize database collation ........................................................................................................ 15Figure 3-7 Account Provisioning tab on Database Engine Configuration page .............................................. 16Figure 3-8 Installation complete ...................................................................................................................... 17Figure 4-1 Server Properties window .............................................................................................................. 18Figure 5-1 Enable the Named Pipes network protocol .................................................................................... 21Figure 5-2 Warning dialog box when you enable a network protocol ............................................................. 21Figure 5-3 Restart the SQL server .................................................................................................................. 22


5/26



Chapter 1 | Introduction


1

1 Introduction

The Microsoft SQL Server 2008 Installation Manualdescribes how to install and to configure Microsoft SQLServer 2008 for use with the following SwissQual software:

NetQual NQDI

NetQual NQWeb

NetQual NQView

SQL Server 2008 Edit ions

You can use the following versions of SQL Server 2008 with SwissQual software:

SQL Server 2008 Enterprise Edition:Contains the complete SQL server functionality

SQL Server 2008 Standard Edition: Offers the core functionality of the Enterprise Edition, which isusually sufficient for SwissQual software.

Important: The 32 Bit version supports only up to 4 GB of RAM.

SQL Server 2008 Express Edition:Offers the core functionality of the Enterprise Edition, but islimited to a maximum database size of 4 GB

Important: The Express Edition is limited to a database size of 4 GB. You can download SQL Server2008 Express Edition software fromhttp://www.microsoft.com/downloads.

System Requirements

Note: For a detailed description of the hardware and software requirements of the SQL Server 2008Enterprise and Standard Editions, consult the relevant Microsoft documentation.
http://www.microsoft.com/downloadshttp://www.microsoft.com/downloadshttp://www.microsoft.com/downloadshttp://www.microsoft.com/downloads


6/26



Chapter 2 | Installing SQL Server 2008 Standard Edition


2

2 Installing SQL Server 2008 Standard Edition

This chapter describes how to install Microsoft SQL Server 2008 Standard Edition. The installation procedurefor the Enterprise Edition is very similar to the Standard Edition and is not described.

To install MS SQL Server 2008 Standard Edition

1. Insert the Microsoft SQL Server 2008 installation disk and in the Microsoft SQL Server 2008 Setup dialog box, click OK.

Note: If AutoPlay is disabled, right-click the setup.exefile on the CD, and then click Run asadministrator.

2. If required, install the prerequisite software for the SQL Server 2008 setup program.

Figure 2-1 Microsoft .NET message

a In Microsoft SQL Server 2008 Setupdialog box, click OK.

b On the Welcomepage for the Microsoft .NET Framework 3.5 SP1 Setup , click I have read andACCEPT the terms of the License Agreement , and then click Install.

Figure 2-2 Microsoft .NET 3.5 SP1 setup


7/26





3

Figure 2-3 Microsoft Windows Installer 4.5

c On the License Agreementpage, click I Agree, and then click Next.

d At the end of the process, restart the computer.

e Follow the instructions to update Windows Installer.

3. Open the Microsoft SQL Server 2008 Setup program on the CD again, and start the installation.

a In the SQL Server Installation Center, click Installation.

Figure 2-4 SQL Server Installation Center, Planning page

b On the Installationpage, click New SQL Server stand-alone installation o r add features to an


8/26





4

existing installation.

Figure 2-5 SQL Server Installation Center Installation page

c On the Setup Support Rulespage, click OK.

Figure 2-6 Setup Support Rules page


9/26





5

4. Specify the license information.

a On the Product Keypage, click Enter the product key, type the product key in the box, and thenclick Next.

Figure 2-7 Product Key page

b On the License Termspage, select the I accept t he termscheck box, and then click Next.

Figure 2-8 License Terms page


10/26





6

5. On the Setup Support Filespage, click Install.

Figure 2-9 Setup Support Files page

6. On the Feature Selectionpage, select the following check boxes, and then click Next:

Database Engine Services

Management Tools Basic

Figure 2-10 Feature Selection page


11/26





7

7. On the Instance Configurationpage, specify the name and the location of the SQL Server instance.

a In the Instance IDbox, type a name for the instance.

b In the Instance root directorybox, enter a location for the server instance, and then click Next.

Figure 2-11 Instance Configuration page

8. On the Server Configurationpage, specify the configuration for the server.

a On the Service Accountstab, select NT AUTHORITY\SYSTEMin theAccount Namecolumn forthe SQL Server Agentand the SQL Server Database Engine.

b InStartup Typecolumn, select Manualfor the SQL Server Agentand selectAutomat ic for theSQL Server Database Engine.


12/26





8

Figure 2-12 Service Accounts page

c On the Collationtab, click Customizebeside the Database Enginebox.

Figure 2-13 Collation tab on Server Configuration page


13/26





9

d Click SQL collation, used for backward compatibilityand in the list, clickSQL_Latin1_General_CP1_CI_AS .

Figure 2-14 Customize database collation

e Click OK, and then click Customizebeside theAnalysis Services box.

f Ensure that the Collation designatoris Latin1_General, that theAccent-sens it ivecheck box isselected, and then click OK.

Figure 2-15 Customize Analysis Services collation

g On the Server Configuration page, click Next.

9. On theAccount Provision ingtab of the Database Engine Configurationpage, specify the logininformation for the database.

a In theAuthent ication Modearea, click Mixed Mode.

b In the Enter passwordbox, type a password for the server.

c In the Confirm passwordbox, retype the password, and then click Next.


14/26





10

Figure 2-16 Account Provisioning tab on Database Engine Configuration page

10. Install the server.

a On the Error and Usage Reportingpage, click Next.

b On the Installation Rulespage, click Next.

c On the Ready to Installpage, click Install.

Figure 2-17 Ready to install page


15/26





11

d At the end of the process, click Close.

Figure 2-18 Setup Complete page

11. Configure the server according to the instructions in the "After You Install"chapter on page18.


16/26



Chapter 3 | Installing SQL Server 2008 Express Edition


12

3 Installing SQL Server 2008 Express Edit ion

This chapter describes how to install the MS SQL Server 2008 Express Edition, which has the corefunctionality of the Enterprise Edition, but is limited to a maximum database size of 4 GB.

You can download SQL Server 2008 Express Edition and the prerequisite software fromhttp://www.microsoft.com/downloads.

The following instructions describe how to install SQL Server 2008 Express Edition R2 Service Pack 1.

To install SQL Server 2008 Express Edition

1. Double-click the SQL Server 2008 Express Edition setup program, for example,SQLEXPRWT_x86_ENU.exe, and start the installation.

a In the SQL Server Installation Center, click Installation.

Figure 3-1 SQL Server Installation Center Planning page

b On the Installationpage, click New installation or add features to an existing installation .
http://www.microsoft.com/downloadshttp://www.microsoft.com/downloadshttp://www.microsoft.com/downloads


17/26





13

Figure 3-2 SQL Server Installation Center Installation page

c On the License Termspage, click I accept the license terms, and then click Next.

2. On the Feature Selectionpage, select the features that SwissQual software uses.

a Select the following check boxes:

Database Engine Services

Management Tools Basic

b Clear the check boxes in front of the following features:

SQL Server Replication

SQL Client Connectivity SDK

c Click Next.


18/26





14

Figure 3-3 Feature Selection page

3. On the Instance Configurationpage, click Default instance, and then click Next.

Figure 3-4 Instance Configuration page


19/26





15

4. On the Server Configurationpage, specify the configuration for the server.

a On the Service Accountstab, select NT AUTHORITY\SYSTEMin theAccount Namecolumn forthe SQL Server Database Engine.

Figure 3-5 Service Accounts page

b On the Collationtab, click Customizebeside the Database Enginebox.

c Click SQL collation, used for backward compatibilityand in the list clickSQL_Latin1_General_CP1_CI_AS .

Figure 3-6 Customize database collation


20/26





16

d On the Server Configuration page, click Next.

5. On theAccount Provision ingtab of the Database Engine Configurationpage, specify the logininformation for the database.

a In theAuthent ication Modearea, click Mixed Mode.

b In the Enter passwordbox, type the password for the server.

c In the Confirm passwordbox, retype the password.

d In the Specify SQL Server administratorsarea, clickAdd Current User, and then click Next.

Figure 3-7 Account Provisioning tab on Database Engine Configuration page

6. Install the server.

a On the Error and Usage Report ing page, click Next.

b At the end of the process, click Close.


21/26





17

Figure 3-8 Installation complete

7. Configure the server according to the instructions in the "After You Install"chapter on page18.


22/26



Chapter 4 | After You Install


18

4 After You Install

This chapter describes the tasks that you need to perform after you install the SQL server on your computer.

Installing Service Packs

After you install the server, you should download and install the relevant service packs from the Microsoftdownload page at:http://www.micosoft.com/downloads.

Changing the Default Language to English

For best results with Diversity, you need to set the default language of the SQL server to English.

To set the default language of an SQL Server to Engl ish

1. On the Startmenu, clickAl l Prog rams, click Microsoft SQL Server 2008, and then click SQL ServerManagement Studio Express.

2. In the Connect to Serverwindow, type the name of your server in the Server namebox, and then clickConnect.

3. In the Object Explorerpane, right-click your SQL server, and then click Properties.

4. In the Select a pagelist, clickAdvanced .

5. In the list of properties, ensure that Default Languageis set to English, and then click OK.

Figure 4-1 Server Properties window

6. On the Filemenu, click Exit.
http://www.micosoft.com/downloadshttp://www.micosoft.com/downloadshttp://www.micosoft.com/downloadshttp://www.micosoft.com/downloads


23/26





19

Configuring Memory Usage (Standard Edit ion Only)

The amount of memory that the Standard and Enterprise Editions of the SQL Server can use is limited by themaximum amount of RAM that the operating system supports. For example, Windows XP and Windows

2008 Server have the following RAM limitations. Windows 2008 Server Standard Edition (32 Bit) supports only up to 4 GB of RAM

Windows 2008 Server Enterprise Edition (32 Bit) supports up to 64 GB of RAM

Note: For the 32-Bit servers, you need to edit the boot.inifile of the Windows 2008 Server to increasethe amount of RAM for the SQL server.

Windows 2008 Server Standard Edition (64 Bit) supports up to 32 GB of RAM

To increase the amount of RAM for the SQL Server on a 32-bit Windows 2008 server

1. Login as Administrator on the Windows 2008 server.

2. Open the C:\boot.inifile in a text editor and locate the following section:

[ boot l oader]t i meout =30def aul t =mul t i ( 0) di sk( 0) r di sk( 0)par t i t i on( 2) \ WI NNT[ operat i ng syst ems]mul t i ( 0) di sk( 0) r di sk( 0) part i t i on( 2) \ WI NNT="????"

3. Add the /3 GBswitch to the end of the following line:

mul t i ( 0) di sk( 0) r di sk( 0) part i t i on( 2) \ WI NNT="????" /3 GB

4. Save the file and restart Windows.

Tip: You can also type the following command in a Command Prompt window to increase the available

memory 3 GB: BCDEDIT /SET IncreaseUserVa 3072To return the setting to the default value, type the following command: BCDEDIT /DELETEIncreaseUserVa

To specify the amount of RAM that a SQL server uses

Important: You can only use this procedure for servers with more than 4 GB of RAM.

1. Open SQL Server Management Studio.

2. In the Object Explorer, right-click the name of the server, and then click Properties.

3. In the Select a Pagepanel, click Memory.

4. Select the Use AWE to allocate memorycheck box.


24/26





20

Figure 4-19 Memory Configuration SQL Server

5. Specify the minimum and maximum server memory.

For best results, SwissQual recommends the following memory settings for a computer that operatesexclusively as a SQL server.

2 GB RAM:Use standard settings

4 GB RAM:Limit the maximum server memory to 3072 MB of RAM

8 GB RAM:Limit the maximum server memory to 6144 MB of RAM

Note: These settings depend on the amount of physical RAM that the server has.

b In the Minimum server memorybox, enter the minimum amount of RAM in MB.

c In the Maximum server memorybox, enter the maximum amount of RAM in MB.


25/26



Chapter 5 | Troubleshooting


21

5 Troubleshooting

This chapter provides solutions to SQL database problems that you might encounter when you useSwissQual software.

Cannot Import Measurement File

If you receive a series of error messages when you try to import a measurement file into an NQDI database,you need to change the network protocol settings of the SQL server.

Import

To change the network protocol settings of the SQL server

1. Log in to the computer that hosts the server.

2. On the Startmenu, clickAl l Prog rams, click Microsoft SQL Server 2008 R2, click ConfigurationTools, and then click SQL Server Configuration Manager.

3. In the console tree on the left, expand SQL Server Network Configuration, and then click Protocolsfor MSSQLSERVER.

4. In the right pane, right-click the following protocols, and then click Enable:

Named Pipes

TCP/IP

Figure 5-1 Enable the Named Pipes network protocol

5. In the Warningdialog box, click OK.

Figure 5-2 Warning dialog box when you enable a network protocol

6. Exit SQL Server Configuration Manager.

7. Restart the SQL server.


26/26



a In the console tree, click SQL Server Services.

b In the server list on the right, right-click your server, and then click Restart.

Figure 5-3 Restart the SQL server

SQL Server and Windows Firewall

If your firewall blocks TCP port 1433, the standard port that MSSQL Server uses, you need to open the portin the firewall. For more information, go to:

http://msdn.microsoft.com/en-us/library/ms175043.aspx
http://msdn.microsoft.com/en-us/library/ms175043.aspxhttp://msdn.microsoft.com/en-us/library/ms175043.aspxhttp://msdn.microsoft.com/en-us/library/ms175043.aspx

installation - ms sql server 2008

Documents