SQL+Server+Installation

=**Installation instructions for Microsoft SQL Server 2005 Enterprise, Trial Version:**= 70-455, Information Resource Management


 * Part 1: Download SQL Server 2005 Eval Package**

Downloading and installing SQL Server 2005 is a relatively straightforward process, considering that it is an enterprise-grade BI/database management system. The following steps should guide you through the basic download and install process. I will assume that you are reasonably familiar with downloading and installing software on MS Windows computers and have written the instructions accordingly.

· Go to the Microsoft SQL Server 2005 trial download site at:

http://www.microsoft.com/downloads/details.aspx?FamilyId=6931FA7F-C094-49A2-A050-2D07993566EC&displaylang=en

If this URL does not work, you can go to the more general link at:

http://www.microsoft.com/sql/downloads/trial-software.mspx

and follow the link to register under "Download SQL Server 2005 Trial Software".

You will need to register with Microsoft before you can download the evaluation version of SQL Server 2005. Please follow the registration instructions and proceed to the download page.

· Once you are at the download page, you will need to download three files. You should download (and review) the ReadmeSql2005.htm file, and the RequirementsSql2005.htm files available at the bottom of the page. Both of these files should be relatively small (<200kb each). You will need to select the appropriate download for the primary SQL Server install based on format (executable or DVD ISO image), and processor family (32-bit, 64-bit, etc.). I would strongly recommend downloading the executable instead of the DVD ISO image, as it is simpler to use for installation. The SQL Server install bundle is rather large, at 900-1000MB, depending on version. The download may take some time (it took me about 20 minutes on the CMU wired network).


 * Note: I would strongly recommend that you use a __wired__ connection on campus to download the install bundle to insure that you don’t exceed your allocated wireless bandwidth. It is likely also faster with a wired connection.**

· If you have chosen to download the DVD ISO Image you will need to burn a DVD from which you can run the setup.exe program.

· If you downloaded the executable format, then you will need to run the .exe file you downloaded to extract all of the installation files. When running this you will need to select a temporary directory that will hold the SQL Server 2005 install files. I recommend that you use the default C:\SQLEVAL directory for simplicity of following subsequent installation instructions in this document. Note that running the .exe file that you initially downloaded does not actually install SQL Server 2005, it only unpacks that installation files from the downloaded file and puts them in the C:\SQLEVAL directory.


 * Part 2: Install SQL Server 2005 Eval Package**

The following instructions provide a step-by-step overview for installing the SQL Server 2005 components that we will be using in the course. For more detailed installation instructions, please see the ReadmeSql2005.html file and/or a set of detailed installation instructions that Microsoft provides on the web at:

http://msdn2.microsoft.com/en-us/library/ms143516.aspx

In most cases, you shouldn’t need to do anything beyond following the instructions below, but these additional resources might prove helpful if something doesn’t work quite right when you are installing the software.

Note: If you are unable, for some reason, to install the server components (database engine, reporting services, analysis services), at least install the client tools, samples, and documentation. You will be able to connect to a shared server to complete your exercises/assignments, but you will have significantly less control of your environment for doing so.

1. Launch the setup.exe program, either from the DVD that you burned (it should auto-start when you put it in your machine) or directly by double-clicking on C:\SQLEVAL\Servers\Splash.hta. This should launch a splash window from which you can choose how to proceed in your installation.

2. Install SQL Server 2005’s components by clicking on the “Server Components, Tools, Books Online, and samples” option under Install on the splash screen. This should launch the main SQL Server 2005 setup program. You will not be installing the server, but the client install is under this option.

3. Review and accept the license agreement, then proceed with the installation of prerequisite components. Click ‘Install’. It may take a few minutes to install the pre-requisite components (it took about 10 minutes on my server). Once it has completed, click ‘Next >’.

4. Welcome screen. ‘Next >’

5. **System configuration check. If there are any configuration problems, please fix them, as possible. IIS is not required for installing the client tools, so you need not install IIS.** ‘Next >’

6. Enter your registration information. ‘Next >’

7. Components to install dialog. To install only the client tools, select the following components to install: o Workstation components, Books online, and Development Tools

8. Click the ‘Advanced’ button. The only tree node that you should need to change this for is the ‘Documentation, Samples, and Sample Databases’ entry. Select to install the Sample Code and Applications, but you will not need the Sample Databases.

Click ‘Next >’. If you click the ‘’.

10. Finally a conformation page shows. Now Install the Client Components


 * Part 3: Test your client tools installation and try to attach to the class SQL Server instance.**

From the Start menu open the SQL Server Management program (Start > All Programs > Microsoft SQL Server 2005 > SQL Server Mangaement Studio). You should be immediately prompted with a dialog box asking you which server and database you would like to connect to. You should be able to attach to the class SQL Server instance using the information in the attached screen shots.

The server name is **bmonroe-srv.tepper.cmu.edu**. Authentication should be switched to SQL Server Authentication.



There is a generic class userid called //test-student// with a password of //erd//. You should use this userid initially to connect to the database and confirm that your client tools attach properly to the course database.

If you connect successfully, you should be able to see the contents of the database “AdventureWorks_BITT” and “AdventureWorksDW_BITT” in the tree stucture to the left.

You will be assigned a unique userid that you should use for all subsequent interactions with the database. Your userid will be the same as your andrewid (e.g. rm74, or asessa – without the @andrew.cmu.edu). Your password will be listed in the gradebook section of Blackboard.

If you have continuing problems connecting to the database, either with the test-student id or your andrewid, please contact the teaching assistant or the instructor for assistance.

The connection properties should default to the following, but in case you change something, here are the default settings.




 * Congratulations! You have completed the client tools setup, and are ready to access the database server used for the course.**

//The client tools will be sufficient for all the class assignments. Your own local database (and sample dbs) are not required. Support for the server installation may go largely unsupported due to time constraints, although feel free to update the wiki with any experiences as to provide some help for your fellow students.//

=**Appendix: Installing SQL Server 2005 Database Engine (Server)**=

The following appendix outlines steps to connect to your own local database if you choose to install a local instance of SQL Server. Most students will not need any future configuration.

If you decided to install the server as well as the client tools then once your server installation is complete, you should run the SQL Server Surface Area Configuration tool (available in the Start menu at Start > All Programs > Microsoft SQL Server 2005 > Configuration Tools). By default, your server installation is quite heavily locked down. If you want it to be accessible by other computers you will need to use this tool to configure the server to accept requests for connections from outside of your machine.
 * Part 4: Configure your server installation and test connection**

I found that I had to make the following changes to allow SQL Management Studio to attach to my database engine:

· Using the Surface Area Configuration Tool, I selected “Surface Area Configuration for Services and Connections” and configured the database engine, reporting services, and analysis services to allow local and remote connections with TCP/IP · I did not need to do anything under the “Surface Area Configuration for Features” link, as I wanted most of the additional features listed in that dialog box disabled.

To test the connection, I opened the SQL Server Management Studio (Start menu, Microsoft SQL Server 2005 section) and connected to the SQL Server database. To connect, use a server name of ‘localhost’ or the name of your server machine. If you gave the instance a name during the installation process, you will need to append that name to the server name in the connect dialog, e.g. localhost\BITT to connect to the BITT instance of SQL Server.

As the final bullet of the installation summary points out:
 * Part 5: Install sample databases (AdventureWorks and AdventureWorksDW)**

“to install sample databases and code samples, see ‘Running Setup to Install AdventureWorks Sample Databases and Samples’ in SQL Server 2005 Books Online.”

You will need to install these databases to complete the next four homeworks. SQL Server 2005 Books Online can be accessed from the Start menu in the Microsoft SQL Server 2005 area.