[PDF] Installation of SQL Server 2008 Express with Advanced Services on

View - Download Installation of SQL Server 2008 Express with Advanced Services on

Previous PDF

Next PDF

Installation of SQL Server 2008 Express with Advanced

Services on Windows 2008 R2 (64-bit)

Contents

Add Web Server (IIS) Role ............................................................................................................... 2

NET Framework 3.5 ......................................................................................................................... 4

SQL Server Installation ..................................................................................................................... 5

Configuring SQL Server .................................................................................................................. 18

Configuring the Product ................................................................................................................ 24

In Basic Mode ............................................................................................................................ 24

In Full Featured Mode ............................................................................................................... 26

Add Web Server (IIS) Role

Open Start | Administrative Tools | Server Manager.

Add the Web server (IIS) role.

Select the following IIS components:

Wait for IIS installation to complete.

NET Framework 3.5

Before starting SQL Server 2008, select .NET Framework 3.5.1 Features for installation in the

Add Features Wizard in Server Manager.

SQL Server Installation

Download Microsoft SQL Server 2008 Express Edition (Runtime with Advanced Services):

After downloading, start SQL Server installation.

Select Installation at the left pane.

Click the topmost link to begin stand-alone installation. Specify the license code, and read and accept the license terms.

Install the support files:

Click Next on the Setup Support Rules screen.

On the next screen, select the following features: NOTE: Business Intelligence Development Studio is an optional feature. Using this feature you can create new or edit existing SSRS report templates.

Click Next.

Select the named instance you want:

Confirm the disk usage summary.

On the Server Configuration screen, specify account information. We recommend using the NT AUTHORITY\NETWORK SERVICE account for both services. Also, set the Startup Type for the services as shown below. On the Engine Configuration screen, select Mixed Mode and specify the password for the SQL Server system administrator account. Also, add the current user (or any other users, if necessary) to the SQL Server Administrators list.

On the next screen, leave the default settings.

Again, leave the default settings:

Click Install and wait for the operation to complete. We recommend restarting the computer where SQL Server has just been installed.

Configuring SQL Server

Run SQL Server Configuration Manager from the Start menu. service and select Start).

Check that protocols are enabled:

Open the following node:

Double click the TCP/IP protocol entry in the right pane, and set Enabled to Yes.

Enable IP1 and IP2:

Go back to the SQL Server Services node and restart the SQL Server service:

Close SQL Server Configuration Manager.

After this, run the Reporting Services Configuration Manager tool using the Start menu.

Connect to your IIS server.

Make sure that you have no warnings for any nodes.

On the Web Service URL node:

Click the URL in the Report Server Web Service URLs section to verify that the Report Server Web Service works. Internet Explorer should show something like the following: Go to the Report Manager URL node, check the parameters, and verify the URL as well.

The result should be be like the following:

If you change any parameter, remember to click Apply.

Click Exit.

Configuring the Product

This section uses AD Change Reporter for configuration examples.

In Basic Mode

Run the AD Change Reporter Configurator (Basic Mode) tool and click Configure. Then select Use existing SQL server instance, and specify the required parameters: Click Next. If the software requires the creation of a new database, click Yes. Wait for report uploading to complete, and click Finish.

In Full Featured Mode

Run Enterprise Management Console from the Start menu.

Go to the Settings | Reporting node.

Click the Configure button, select Use existing SQL server instance, and specify the required parameters:

Click OK.

Under the node of your domain, expand the node of the product, select the Advanced Reports node and click the Configure button. Turn on the Enable advanced reporting option, and select the Default option under SQL Server

Connection Settings, or specify a custom setting.

Click Apply.

quotesdbs_dbs31.pdfusesText_37

[PDF] Calendrier de la garde d enfants à domicile

[PDF] Politique relative aux services à la clientèle accessibles

[PDF] 1. Projet de lecture. Français 20-2. Médias : La pub. Cahier de l élève. Nom :

[PDF] DESCRIPTION DU CORPS D'EMPLOI

[PDF] VILLE DE GRIMAUD. Objet de la consultation MAINTENANCE DES INSTALLATIONS DE CHAUFFAGE / RAFRAICHISSEMENT BATIMENTS COMMUNAUX ACTE D ENGAGEMENT

[PDF] Modèle de contrat de travail Accueil Occasionnel

[PDF] Evaluation de la charte 2003-2013 - Agenda 21 et des contrats. Comité technique du 9 octobre 2012

[PDF] Ville de Wissembourg DÉPARTEMENT DU BAS-RHIN. Bienvenue. à Wissembourg!

[PDF] UE 3 Management et contrôle de gestion. Le programme

[PDF] LISTE DES DOCUMENTS A FOURNIR A L APPUI DE VOTRE DEMANDE DE BOURSE Documents à fournir quelle que soit votre situation :

[PDF] Guide pour l élaboration des profils d emplois ITA CAS DES RECRUTEMENTS

[PDF] INSTALLATION OFFICE 2013

[PDF] POUR UNE NOUVELLE POLITIQUE DE SOUTIEN A L INSERTION PAR L ACTIVITE L ECONOMIQUE. Rapport Cadre n CR 41-09 du 06 Mai 2009

[PDF] Les emplois «sports nature» en Bretagne. Juillet 2010

[PDF] Mesures de lutte contre le blanchiment de capitaux et le financement du terrorisme - Belgique