I. Pre-requisite: If you intend to install Visual Studio, you must install Visual Studio 2008 with Service Pack 1 before attempting to install SQL Server 2008.
A. Note: It is possible to install SQL Server 2008 without installing Visual Studio 2008 directly. In that case, the SQL Server 2008 installation will install Business Intelligence Development Studio for you. BIDS is Visual Studio with only Business Intelligence projects available.
II. Put SQL Server 2008 DVD in the drive and close it. If AutoPlay is enabled click on “Run Setup.exe”, if it is not enabled navigate to the Setup.exe file on the DVD and double-click it.
B. If you see a dialog concerning installing prerequisites (Net Framework and updated installer) click OK.
C. If you get additional dialogs concerning installing software, click OK.
D. Click Restart Now if get dialog that update Installation is complete.
E.
After your computer restarts you may have to wait a few
minutes before the
III. When the SQL Server Installation dialog appears, note in the left pane Planning is (should be) in bold. If it is not in bold, click on it.
A. In the right pane are a number of planning steps to take. You should click on them one at a time from top to bottom and note the information contained therein. Following are the steps you have to work with:
1. System configuration checker
a. This will run the Setup Support rules. When the operation is completed, click on the Show details button, and ensure all rules display a status of Passed. If any do not, click on the blue status link for the rule and determine what has to be fixed. (Note: If you do not fix these problems now some of the Support rules will be run again during installation, and you may have to cancel the installation to fix the problem then.)
b. When all rules show Passed, click OK
2. Install upgrade Advisor. Run this if you are upgrading from SQL Server 2000 or 2005. Fix any problems identified.
3. When finished with all of the Planning items, click Installation in the left pane.
IV. Installation
A. Select the New SQL Server stand-alone installation or add features to an existing installation. (Note: at first you will be installing a stand-alone installation, but note that this option allows you to run start-up again to add features to your installation or to add another instance of SQL Server).
B. The Setup Support rules will run again. Check the Details to ensure all have passed and then click OK.
C. On
the Setup Support files dialog click on Install.
The setup Support Rules run again. Note
that, if you have any problems, you can leave this page open and try to fix the
problem, and click the Rerun button
to see if the problem rule passed.
D. Click Next when done.
E. Your Product Key should be embedded and therefore displayed in the Product Key dialog, so just click Next.
F. Accept the License Terms and click Next.
G. On the Feature Selection dialog click on the Select all button
1. Note the features that will be installed. Ensure that Full Text Search is checked because this is needed to install the sample databases.
2. Click Next
H. On the Instance Configuration dialog select the Default Instance option. Note the other information but do not change anything. You may see SQLEXPRESS has already installed as a named instance. Click Next.
I. On the Disk space Requirements dialog click Next.
J. Server configuration dialog:
1. Note the SQL Server Integration services has the Account Name already set to NT Authority/Network Service
2. For Reporting Services click in the Account name drop-down list box, then click on the drop-down arrowhead, and then select NT AUTHORITY/Network Service.
3. For the remaining services in the top group of services, click in the drop-down list box named “Use the same ServiceAccount for all SQL Server services”, then the arrowhead, and select <<Browse>>.
a. In Select User or Group dialog click on Advanced
b. In Select the object type dialog click on Find Now
c. In the Search results pane at the bottom of the screen scroll down almost to the bottom of the list and select System.
d. Click OK, and OK again.
e. Note that passwords are not required for these accounts, so just click Next
4. For the SQL Full Text search Daemon Launcher service follow the instructions in step 3 above but scroll down to and select the Local Service account
K. Database Engine Configuration dialog
1. On Account Provisioning Tab
a. Select the Mixed Mode option
b. Enter and confirm a password for the System Administrator account. Write this down, you will not use it often, but when needed, it would be helpful to remember what it is.
c. Click the Add the current user button (this is the account you are using, so you are making yourself an administrator.)
2. On Data directories tab. just note the information but don’t change the default values.
3. On
FILESTREAM Tab (Important requirement to
install sample databases)
a. Check the Enable FILESTREAM for Transact SQL access checkbox
b. Check the Enable FILESTREAM for file I/O streaming access checkbox
c. Click Next
L.
Analysis
Services Configuration dialog
1. Account Provisioning tab. Click the Add Current User button
2. Data Directories tab. Just note but do not change the default values.
M. Reporting Services Configuration dialog
1. Select the option to Install the native mode default configuration
2. Click Next.
N. Error and Usage Reporting dialog
1. Select anything you want, if anything
2. Click Next.
O. Installation Rules dialog
1. This is similar to the Support Rules check that was run earlier. If anything fails you can keep this dialog open and try to correct the problem, and then click the Re-Run button.
2. If you get an error for Previous Releases of Microsoft Visual Studio 2008, it may mean you did not install Visual Studio Service Pack 1. You must do that.
3. Click Next when all pass.
P. Ready to Install dialog
1. Review the entries if you are so inclined.
2. Click Install
Q. Installation Progress dialog
1. You can review the progress of the installation.
2. When you get the Setup Process Complete message, click Next
3. In the Complete dialog click Close.
V. Updates
A. You should be returned to the SQL Server Installation Center
B. Click Search for product updates
VI. Configure Network Services for SQL Server
A. Click on Start/All Programs/SQL Server Configuration Manager
1. Expand the SQL Server Network Configuration node in the left-pane.
2. Select each SQL Server instance in turn and:
a. In the right-pane right-click Named Pipes and Select enable
b. In the right pane right-click TCP/IP and select enable
3. Close the Configuration Manager
B. Open Control Panel and navigate to Services
1. Select the Standard tab at the bottom
2. Scroll down to each of the SQL instances you had worked on inVI,A,2 above.
3. Right-click the service, select Properties and then Stop the service.
4. After the service has stopped, right-click the service again, select Properties and Start the service
5. Close out of Services and Control Panel.
VII. Install Sample Databases
A. Click on Start/Control Panel/Administrative Tools/Services.
1. Click on the Standard Tab in Services dialog
2. Scroll down to the SQL Full-text Filter Daemon Launcher (MSSQLSERVER) and make sure it is running. If not, right-click on that service and select properties, and click Start to start it.
B.
Go to the following web site:
http://msftdbprodsamples.codeplex.com/Release/ProjectReleases.aspx?ReleaseId=37109
1. This is the download site for the databases.
2. Under the Recommended Download area Click on the AdventureWorks2008_SR4.exe link
3. On the License dialog click I agree.
4. Run the file
a. Respond to the dialog boxes as needed referring to the screen shots at the end of this section.
C. Open SQL Server Management Studio
1. Connect to the database engine on your Server using Windows authentication.
2.
Expand the Databases node in the left pane and ensure
the following databases are present:
Database
Installation Screen Shots
