Installing SQL Server 2005

Installation
Step 1 - Insert the CD into the drive

Via Windows Explorer go to the following directory on the CD-ROM (or DVD) and double click the following: Servers \ setup.exe

Step 2 - License Agreement
Accept the license agreement and click "Next"

Step 3? Installation. NET Framework 2.0 and SQL Server Client
The installation always starts with the installation. NET Framework 2.0 and installing the client tools to access SQL Server, both are mandatory.
Click "Install" to start installation.

Step 4 - Start the installation
Start the installation wizard itself
Click "Next"

Step 5 - Check the configuration
The means to verify the configuration allows you to detect potential problems that would prevent the installation of SQL Server 2005. The items checked concern the hardware, Windows services installed, the Windows configuration and security settings.
Items in green means no problems, those in yellow are not critical but may interfere with the operation, the red points are critical

       You can see the details of a message using the link "Messages ... In case warning (yellow) or error (red). A window like below will appear.

         You can view the summary of this window by clicking on the "View Report" button, you will have access to the end of the installation. It contains the summary of all messages including those validated successfully.

           To continue click "Next" and then wait during the detection of the following

Step 6 - Identity and key product
Please enter identity information and the product key.
Note that the product key can be pre-entered if you use an installation CD MSDN or in the case of an edition of assessment
Then click "Next"

Step 7 - Features to install
Choose components to install.
If you are in Enterprise Edition you can perform the installation in Cluster (here checkboxes are grayed out). See the following tutorial on a clustered SQL Server 2005:
Select the services you want on your server:

• o SQL Server Database Services
  
• o Engine relational database
  
• o Agent planning tasks
  
• o Engine Indexing "Full Text Search"
  
• o Analysis Services (SSAS)
  
• o Engine database multidimensional (OLAP)
  
• o Reporting Services (SSRS)
  
• o generation engine states (static reports). We need IIS to install.
  
• o Notification Services (SSNS)
  
• o Research Services data subscription. It retrieves data periodically query database.
  
• o Integration Services (SSIS)
  
• o tool for transferring and transforming data, replacing Data Transformation Services (DTS)
  
• o Components of a workstation, etc..
  
• o Administration interface (SQL Server Management Studio (SSMs))
  
• o Interface development (SQL Server BI Development Studio)
  
• o Database example, code examples (you will need to go to advanced to select)
  
• o Online Documentation
  

      To install the databases and sample files you will need to click the "Advanced" button to select them.
         In the "Advanced" you can choose to add or remove features in detail.
On the screenshot you can choose for example to add the AdventureWorks database and AdventureWorksDW (new databases examples replacing pubs and Northwind), you can also add code examples.

Step 8 - Instances
You choose whether you are installing as default instance or named.
This choice applies to:

• o Analysis Services
  
• o Reporting Services
  
• o SQL Server Database Services
  
• o Engine relational database
  
• o Agent planning tasks
  
• o Engine Indexing "Full Text Search"
  

If you already have a pending installation by default, only the named instance option is available. A default instance is accessible via the server name alone (eg MyServer), a named instance is accessible via the server name and the name you gave to the body (eg MyServer \ MONINSTANCE). Each instance is installed it may be separate versions / editions different patches may also be different.
The other services have no knowledge of bodies and are installed only once.

Step 9 - Accounts Service
Choosing a service account and perform the services of SQL Server 2005.
Each of the services of SQL Server requires a security account to run, and a parameter indicating whether the service starts automatically or manually.
The services may be the following:

• • LocalSystem
  
• o This is generally the option chosen, it will be "administrator" of the local machine, in fact the service can impersonate the system, rights are only local, this account has no real user context, if network access is a null session is open (usually not on other machines)
  
• o With this kind of rights do not forget that ill-intentioned person could simply reboot your server if it had access to xp_cmdshell.
  
• • LocalService (new Windows 2003)
  
• o The rights are those of a simple user local rights are local only, if network access is a null session is open (usually not on other machines).
  
• o Note that the installation process, which grants additional rights for SQL Server.
  
• • NetworkService (new Windows 2003)
  
• o Same as above except that the access network this with the account of the machine when you try to connect to another machine it should allow your server to connect (for example, your SQLSERVER server must be explicitly authorized to write to the share \ \ MESFICHIERS \ VAS). This mode is quite handy in case of machine not connected to a domain, but need access antrum them.
  
• o Same as above. When you are on the same server is NetworkService who must be accorded the rights, however, is the usage of the server (machine name) to be authorized.
  
• • Local Users (ServerName \ Users)
  
• o Nearly equivalent to LocalService, however, your server can connect to a machine with a couple user / password similar to your local account.
  
• • User Field (DomainName \ User)
  
• o The most common option when you are connected to a domain, allows greater ease in the management of rights between the servers.
  
• o Avoid too much right to a domain account, a service may well be called the domain, without compromising the functioning of the SQL service.
  
• All types of accounts are not available in this window, you can change them later if you wish via the Tool "SQL Server Configuration Manager (Configuration Manager SQL Server) or via the Services Manager in the Tools of ? administration of Windows (the first option is by far the best).
  
• If you check "Customize for each service account, you can specify a different service account for each service installed, otherwise the same will be chosen for all.
  
• The startup type of services may be one of these values:
  
• • Automatic
  
• o The service starts automatically when Windows starts
  
• • Manual
  
• o The service must be started manually (this may be another service)
  
• • Off
  
• o The service is disabled and can not be started
  

Here, if you check the box that means that the service is started automatically, otherwise it is in manual mode. These options may be modified as the service account indicated above.
SQL Browser only be performed if you use multiple instances, or a named instance, in this case, be sure to check well the automatic startup of this service.

Step 10 - Type of authentication
At this stage we choose if you want authentication:

• o Windows
  
• o Windows (using a domain account or a local machine)
  
• o Mixed
  
• o Windows (using a domain account or a local machine)
  
• o SQL Server (using a user name and password stored on the SQL Server)
  

Then, it is strongly recommended to specify a password for the account "sa" which has the maximum rights to the server. Even if you are using Windows Authentication, you must assign a password to this account. This password can be changed after the server installation.
By default, the sysadmin rights (maximum of rights on the SQL server) are attributed to "its" (SQL Server) and group 'BUILTIN \ Administrators (Windows group of local administrators of the server).

Step 11 - Page Code and Classification (Collation)
For each service account it is possible to specify the collation (also known as classification or sorting order and comparing and code page).
This snack is the composition of the following parameters:

1.  The code page used for fields that are not unicode (type varchar)
   
2.  The sort order of strings
   
3.  Sensitive or not sensitive (uppercase and lowercase)
   
4.  The sensitivity or not accents
   
5.  Sensitive or not to Kana
   
6.  Sensitive or not the width of characters
   

Points 1 and 2 are modified by the drop-down list that allows you to choose a language and therefore a sort order and a page of code. For a french Windows server, the default setting is "French", for a server in English the default setting is "Latin1_General. The only difference between the two lies in the sort order, code pages are identical.
Point 3 corresponds to the box "Match case", 4 "Respecting accents", 5 "Meet the characters Kana" and 6 "width Respect." Boxes "Binary" allow a sensible comparison to the four points (3 to 6). Snacks binaries are the most effective in terms of performance on the salaries of channels (equal and tris).
The snack set here applies to database systems (master, msdb, tempdb and model) and by default for new databases created. It can however be changed when creating a new database or when adding a text field using the COLLATE keyword.
Attention to the fact that if you use a collation sensitive to case insensitive to case sensitive in the names of objects and databases in SQL scripts.

Step 12 - End of the installation
You choose whether you want to send an error report to a central server, or if you want to send anonymous information to Microsoft about your configuration.
           A summary of your choices is presented to you before installing SQL Server 2005.
Once ready, click "Install"
             You are viewing the progress of the installation in the window, if one phase fails, there would be a red icon in front of the stage.
Click "Install"
             If the installation was successful you should see the window as below.
Click "Next".
            The summary page of the installation with advice for the services of SQL Server 2005, read carefully. At this point you can retrieve the log of the installation of SQL Server 2005 by clicking on the hyperlink Journal abstract.
Click "Next"

Step 13 - After the installation
After the installation, it is wise to check the operation of various services of SQL Server and check the security settings. To do this, go to the Start menu and then on "Program / Microsoft SQL Server 2005 / Configuration Tools" and open the tool SQL Server Configuration Manager "
In Services SQL Server 2005 you will see a look the services SQL Server 2005 installed on the machine, and if they run or not. You can boot from the tool or change the startup parameters of these (or non-automatic start and service accounts).
This tool also allows the network settings of SQL Server 2005.