Installing SQL Server 2008
From InstallationWiki
| Official Page |
| Project Documentation |
| Download |
|
Contents |
[edit] Version of SQL Server 2008 to be installed
An evaluation version of the SQL Server 2008 Enterprise Edition is installed for the purposes of working with this tutorial. It may be noted that there are several editions of SQL Servers with varying capabilities available. For details of versions and the features they support follow this link: http://msdn.microsoft.com/en-us/ library/cc645993.aspx.
[edit] Hardware requirements
In this tutorial we will be using the SQL Server 2008 Enterprise Evaluation Edition (32Bit). The requirements have been extracted from the http://msdn.microsoft. com/en-us/library/ms143506.aspx#EE32 site for the SQL Server 2008 32-bit Enterprise Edition for Windows XP Professional SP2 Computer OS. Here are the requirements:
1. Processor: Pentium III compatible processor with 1.0 GHZ or faster with a recommended speed of 2.0 GHZ.
2. Hard disk space requirements:
| Service\Resource | Disk Space |
|---|---|
| Database Engine, data files, replication, and Full-Text Search | 280MB |
| Analysis Services and data files | 90MB |
| Reporting Services and Report Manager | 120MB |
| Integration Services | 850MB |
| Books on Online and SQL Server Compact Books Online | 240MB |
3. Memory: Minimum 512 MB RAM. Recommended is 2.048 GB or more.
4. Drive: A CD or DVD Drive for disc-based installations.
5. Display: High resolution VBA 1024 x 768 pixels for SQL Server Graphic tools.
6. Others: Microsoft mouse or compatible pointing device.
[edit] System and software requirements
The following are the system and software requirements:
1. Operating System:SQL Server 2008 can be installed on all versions (in 32Bit and 64-Bit) of Windows Vista, Windows Server 2008, Windows Server 2003 (SP2 and Enterprise Edition SP2) and Windows XP Professional SP2.
2. Software: Microsoft Windows Installer 4.5 or later Microsoft Data Access Components (MDAC) 2.8SP1 or later Standalone named and default instances support the following network protocols:
- Shared Memory
- Names pipes
- TCP/IP
- VIA
Microsoft Internet Explorer 6.1 or later
3. Framework (all installed during SQL Server 2008 install):
- .NET Framework 3.5
- SQL Server Native Client
- SQL Server Setup support files
|
System Configuration Checker will check and the required items will be flagged if they are not present. |
[edit] Hardware and software used for working with the tutorial
The following are the hardware and software details of the Toshiba Laptop Computer used in the preparation of this tutorial:
- Operating system: Microsoft Windows XP Media Center Edition Version 2002 SP3
- Hardware: Intel Pentium 3.00 GHZ, 1 GB of RAM
- Disk Capacity: 180 GB
- Internet Explorer: Version 7.0
- Drives: DVD Read/Write
[edit] Installing a named instance of SQL Server 2008
The exercises like these will help you to install the SQL Server 2008, review the installed items, install an example database to use with this tutorial, and configure the SQL Server Reporting Services.
While installation of both named and default instances of SQL Server 2008 are possible, installation of a named instance is described for the examples used in this tutorial. A named instance would be required if there is already a default instance of SQLServer 2008 (only one default of any version is allowed), or a default instance of another version (for example SQL Server 2000 or SQL Server 2005) is already present. If this is the only SQL Server (any version) on the computer then a default instance can be a good choice as well.
[edit] Getting ready
The following are some of the verifications you have to make before starting an installation:
1. Make sure that your setup satisfies the Hardware and System/Software requirements discussed earlier.
2. Make sure that there are no previous installations of SQL Server 2008 (CTP's). Read note after the conclusion of Hands-on exercise 1.1.
3. If you are installing on a machine with Visual Studio 2008 already installed, make sure you have installed Visual Studio SP1.
4. The SQL Server and the components will run as windows services and you should have windows accounts configured to run services. These could be Domain User Account, Local User Account, Local Service Account, Network Service Account and Local System Account. In this example the local user account with administrator's privilege is used. For details see: http://msdn.microsoft.com/en-us/library/ms143504.aspx.
5. Download the SQL Server 2008 RTM Enterprise Edition from the following link (requires registration): http://msdn.microsoft.com/en-us/ evalcenter/bb851668.aspx. The downloaded image, SQLFULL_ENU. ISO, is an archive file. It is best opened with the WinRAR program. It can be downloaded from the WinRAR web site: http://www.download.com/ WinRAR/3000-2250_4-10007677.html.
The following screenshot shows the contents of this archive. Extract the contents to a folder.
[edit] Follow the steps
1. Click on setup.exe in the folder. This brings up the Microsoft SQL Server 2008 Setup window as shown:
2. Click on the OK button.
The Microsoft .NET Framework 3.5 SP1 setup window comes up and after some 30 minutes you will be asked to reboot.
3. Click again on setup.exe after rebooting the computer.
The setup program extracts files from the ISO and the SQL Server 2008 starting display comes up followed by the SQL Server Installation Center window as shown:
4. Click on the Hardware and Software Requirements link.
This brings up the web page: http://msdn.microsoft.com/en-us/library /ms143506.aspx. Read the information relevant to your system. For this tutorial the previously described hardware and software are used.
5. Click on the Security Documentation link.
This brings up the web page: http://msdn.microsoft.com/en-us/library/ms144228.aspx. Read the information on this web page.
6. Click on the link System Confi guration Checker.
In the following window, Setup Support Rules, a list of rules will appear. The 'status' for all items should be marked passed. Problems arising when any of the rules fails can be corrected and the setup can be re-run from the point where it failed last. The setup will not continue unless all failures are corrected.
7. Click on Installation in the navigation (left-hand) list. The following SQL Server Installation Center window shows up again:
8. Click on the link New SQL Server stand-alone installation or add features to an existing installation.
9. Click on the OK button.The Product Key page shows up as shown:
10. Accept the default and click on the Next button.
11. The License Terms page shows up as shown. Make sure you read the terms and the fi ne print.
12. Place check mark for I accept the license terms check box after reading the license and then click on the Next button which gets activated. The Setup Support Files shows up again as shown:
13. Click on the Install button.
The setup program progress page shows up and you may need to restart the computer.
14. Click on the OK button and reboot the computer.
15. Click on the setup.exe file in the folder (see Step 1) after rebooting the computer. The Setup Support Rules page is displayed, checks the support fi les and shows the status as shown:
16. Click on the Next button on the Setup Support Rules page. The Product Key page shows up again.
17. Choose Enterprise Evaluation and click on the Next button. The Feature Selection page shows up as shown:
18. After clicking on the Select All button, click on the Next button. A brief Please Wait window shows up.
19. In the Instance Configuration page that shows up, change the Named instance to SANGAM as shown. You are free to type in a name of your choice. You may also choose to install a default instance. In the installed instances you can see that there is a SQL Server 2005 SQLEXPRESS.
20. Click on the Next button.
Again a brief Please Wait window shows up followed by the Disk Space Requirements window as shown:
21. Click on the Next button. The Server Configuration window shows up with two tabbed pages, Service Accounts and Collation as shown:
22. Click on the drop-down handle in the Account Name column for the SQL Server Database Engine. It now shows the options you have in creating an Account Name and a Password as shown:
23. Click on the <<Browse >> drop-down menu item. The select User or Group window shows up as shown:
24. In the Enter the object name to select, type in the name of a Windows user or group. The user name gets into the Enter the object name to select box.
25. Click on the Check Names button that is enabled. This should verify the object name you typed in as a Windows user or group.
26. Click on the OK button in the Select User or Group window.
This name is put into the Database Engine's Account Name. This is what you will be using for authentication. You should try to remember this or, write it down for safe keeping.
27. Click on Use the same account for all SQL Server 2008 services button.
The Use the same account for all SQL Server 2008 services window shows up as shown:
28. Enter the Account name you verified in the earlier step and the Password associated with the Windows User or Group. Click on the OK button.
29. All accounts get the same Account Name and Password as shown in the following screenshot:
30. Make no changes to the Collation page and click on the Next button. The Please wait window shows up after which the Database Engine Configuration window shows up with three tabs: Account Provisioning, Data Directories, and FILESTREAM as shown:
31. Accept the default authentication mode as Windows authentication mode and click on the Add Current User button. Read the instructions regarding the unrestricted privilege for this account.
The current user's name shows up in the Specify SQL Server administrators' window. Here you can Add /Remove names from the list. For this example only the current user was set up with this privilege.
32. Click on Data Directories tab.
The Data Directories page shows the various directories of the Database Engine and their locations. While the default location is acceptable, a different location can be chosen. By default the directories of SQL Server Database Engine, Analysis Server, and Reporting Services are sub-directories of Microsoft SQL Server under C:\Program Files\Microsoft SQL Server. This could sometimes lead to errors as the wizards in applications do not necessarily discover this structure. This is especially problematic when multiple versions are installed on the same machine. A different choice for the location of the directories would avoid this problem.
33. Click on the FILESTREAM tab and check the Enable FILESTREAM for Transact-SQL access option as well as the Enable FILESTREAM for I/O streaming access and fill out other details as shown. Filestream is a new feature in SQL Server 2008 that allows direct storing of large binary data to the NTFS file system while maintaining transactional consistency. This helps in storing large binary data outside of the database on cost-effective storage media. When this is enabled the Windows share name gets automatically entered.
34. Click on the Next button.
The Analysis Services Configuration window shows up as shown with two tabs: Account Provisioning and Data Directories.
35. Click on the Add Current User button to add the current user as Analysis Services' administrator.
This adds the current users name to the Specify which users have administration permissions for Analysis Services area above the button.
36. Click on the Data Directories tab.
All the directories and their locations for the Analysis Services Configuration gets displayed as shown:
37. Click on the Next button.
The Reporting Services Configuration window shows up with the default choice as Install the native mode default configuration. Note that this is the choice made for working through this tutorial. Read about other options as well.
38. Click on the Next button.
The Error and Usage Reporting page gets displayed as shown. This is optional but these have been checked for this installation.
39. Click on the Next button.
The Installation Rules page is displayed as shown. The status should be Passed for the rules. If any of the Rule items fail, the whole installation winds back. You will have to start from the beginning.
40. Click on the Next button.
The Ready to Install page gets displayed which shows all the items chosen during this installation and the path for the Configuratio.ini file.
41. Click on the Install button.
The Installation Progress window gets displayed as installation starts up. It will take quite a while. Finally the Installation Progress window shows up which displays that the installation was a success as shown:
42. Click on the Next button.
The Complete window shows up as shown. Read the Supplemental information by scrolling down. The installation log file is saved to the hard drive, which is useful if you need to look up any information.
You have completed the installation of a named instance of a stand-alone SQL Server 2008 RTM on your Windows XP Professional computer.
[edit] Installation choices and notes
Since this installation is just for working with basic Reporting Services by a single user on a single machine, the same service account was used for all of the services. Also all services were configured to start automatically except for the SQL Server Agent. During installation, the username and password chosen are of the author on this particular custom environment as it makes meaningful screen capture easier. It is not a recommended practice to make public the security arrangement except for a demo environment such as the one used here.
The author is a window's user with administrative privileges. If you want to customize, you may want to choose different locations for the data and log files, but for this tutorial the default locations are adequate.
Windows authentication was chosen for both the Database Engine as well as the Reporting Services to keep it simple. Also to make it simple, the current user of the machine was also made the sysadmin. If necessary, one could add other SQL Server administrators using the related Database Engine page. While configuring the Database Engine, the defaults were used for Data Directories but these can be customized as well.
Regarding choices for the Reporting Services configuration mode, there are three possible modes of which the default is the native mode. It is also the simplest. Since SharePoint integration was excluded from the tutorial, the SharePoint default mode was not considered.
The installation should proceed as described without any problem, if you are making installation of the SQL Server 2008 for the first time. However as the SQL Server 2008 and Visual Studio 2008 are tightly bound, it is essential that Visual Studio SP1 should be applied before installing SQL Server 2008. It may be noted that SQL Server 2008 can co-exist with SQL Server 2005 and that Reporting Services can be installed separately on another machine. These other installation options are outside the scope of this tutorial. Another source of installation problems is the existence of the CTP (Community Technology Preview or Beta) installations of SQL Server 2008 (http://www.packtpub.com/article/microsoft-sql-server-2008-installation-made-easy). These must be completely removed before SQL Server 2008 RTM can be successfully installed.
Read the important information presented in the last installation screen regarding sample databases, late-breaking changes and many other items.
[edit] Reviewing the installation
In this exercise you will be getting acquainted with the following:
- The program short cuts
- Reviewing installed services
- Start and Stop Reporting Services
[edit] Program shortcuts
1. Click Start | All Programs | Microsoft SQL Server 2008. This displays the submenu items as shown:
2. Click on the Confi guration Tools submenu item to display further submenu items as shown.
- In SQL Server Error and Usage Reporting you will be giving permission to Microsoft to collect information from your machine.
- In SQL Server Installation Center you can carry out a number of activities (Planing, Installation, Maintenance) as described in Hands-on exercise 1.1.
Reporting Services Confi guration Manager will open the interface where Reporting Services can be confi gured. This will be described in Hands-on exercise 1.4.
SQL Server Confi guration Manager provides access to this important interface for managing the SQL Server Services, SQL Server Network Configuration, and SQL Native Client Configuration. It is also possible to stop, start, and restart several of the SQL Services including the Reporting Services from this interface.
3. Click on the SQL Server 2008 Upgrade Advisor submenu item.
This launches the SQL Server 2008 Upgrade Advisor window where you can read more about Upgrade Advisor, check for updates, launch the Upgrade Advisor Analysis Wizard, and launch the Upgrade Advisor Report Viewer.
4. Click on the Documentation and Tutorials submenu item.
The following submenu item gets displayed as shown. The SQL Server Samples Overview submenu item describes code samples and sample databases and provides the following important link: http://www.Code-Plex.com/SqlServerSamples. It also provides information on several important topics like providing feedback, and updating .NET Framework CLR samples. The other submenu items take you to the listed items.
5. Click on the Analysis Services submenu item.
Verify that you can access the Welcome to the Analysis Services Deployment Wizard.
6. Click on the Integration Services submenu item.
Verify that you can access two more items in the resulting drop-down: the Data Profile Viewer and the Execute Package Utility.
7. Click on the Performance Tools submenu item.
Verify that you can access the menu items, Database Engine Tuning Advisor and the SQL Server Profiler.
8. Click on the Import and Export Data (32bit) submenu item.
Verify that this invokes the SQL Server Import Export Wizard's Welcome screen
9. Click on the SQL Server Business Intelligence Development Studio submenu item.
Verify that this invokes an instance of Microsoft Visual Studio 2008's shell.
10. Click on the SQL Server Management Studio submenu item.
Verify that the SQL Server Management Studio is invoked.
[edit] Reviewing installed services
The Database Engine, Reporting Services and SQL Server Agent are installed as Windows services. These services can be stopped and started from the Control Panel.
1. Click Start | Control Panel on your desktop. In the Control Panel, click on Administrative Tools | Services . Alternatively enter servies.msc in the Start|Run command window.
This opens the Services window where you can find all the Windows services as shown in the next screenshot. This includes all the SQL Server services.
2. Review all SQL Server 2008 related services.
[edit] Starting/stopping Reporting Services
Starting, pausing, and stopping windows services are essential operations in the Windows OS for reasons that include security and performance or when the service fails for any reason. Reporting Services can be started and stopped from the SQL Server Configuration Manager, the Windows services as well as from the Reporting Services Configuration tool. Reporting Services cannot be paused. In this section you will see how it can be started and stopped from Windows services.
1. Click SQL Server Reporting Services (SANGAM) to change the display as shown in the following screenshot:
2. Click on the Stop the service link.
This brings up the Service Control window which advises that the service is attempting to stop as shown in the next screenshot:
[Reporting Services can be started in a similar manner. The other services
in the Services window can also be similarly controlled.]
[edit] Accessing installed services from the SQL Server Management Studio
Click Start | All Programs |Microsoft SQL Server 2008| SQL Server Management Studio.
This opens up the SQL Server Management Studio followed by the Connect to Server window which immediately shows up as a modal window. The two windows are shown superposed in the screenshot:
In this screenshot the drop-down handle is activated to show the different services.
[edit] Post installation checks
Program shortcuts give one-click access to most of the tools and it is in the best interests of the reader to get acquainted with the various menus associated with it.
The configuration tools give access to the SQL Server Installation Tool, the SQL Server Configuration Manager, and the Reporting Services Confi guration Manager. All of these are frequently used.
Documentation and tutorials should not be overlooked as most of what you can do with SQL Server 2008 is contained in them.
The Services collection in the Control Panel's Administrative tools folder is another very important resource that is used not only for starting and stopping services but also for trouble shooting connectivity with services. You can right-click on any item to look at the services in more detail, make changes there and look at how they depend on other constituent parts. Another way to get to the Services is to click on
Start | Control Panel | Administrative Tools | Computer Management (Local) | Services and Applications. The following link, http://www.aspfree.com/c/a/ ASP.NET/Managing-Windows-Services-with-Visual-Studio-2005/,describes more details regarding the use of the Services Collection in the Control Panel.
For managing objects on the SQL Server 2008 there is no better tool than the SQL Server Management Studio. You can connect to all servers, whether local or networked, using the File | Connect Object Explorer menu. Of course you need to know the authentication mode and authentication details. Also before you can connect to the server you must have the service started.
[edit] Source
The source of this content is Chapter 1: Installing SQL Server 2008 of SLearning SQL Server 2008 Reporting Services by Jayaram Krishnaswamy (Packt Publishing, 2009).
