1 / 32

Installation of SQL Server 2005 Express Edition and SQL Server Management Studio Express

BCS 4 th Semester. Installation of SQL Server 2005 Express Edition and SQL Server Management Studio Express. Step 1: Download SQL Server 2005 Express Edition. Table A -- Decide which features you need for your installation. Step 2: Identify system requirements.

gwendolyn-leblanc
Download Presentation

Installation of SQL Server 2005 Express Edition and SQL Server Management Studio Express

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. BCS 4th Semester Installationof SQL Server 2005 Express Edition andSQL Server Management Studio Express

  2. Step 1: Download SQL Server 2005 Express Edition Table A -- Decide which features you need for your installation

  3. Step 2: Identify system requirements • SQL Server 2005 Express Edition does not have significant system overhead requirements, particularly given the overpowered nature of many of today's newest servers. • The minimum system requirements for the various SQL Server 2005 versions are given in: Table B -- System and software requirements for SQL Server 2005 Express Edition

  4. Step 3: Install database software prerequisites • there are a number of software prerequisites for SQL Server 2005 Express Edition. • Before you can install the database software, you need to take the necessary steps to get these items installed.

  5. Install the following items in order • Internet Information Server 5 or higher • If your Windows server does not have IIS installed, go to Start| Control Panel | Add or Remove Programs | Add/Remove Windows Components. • .NET Framework 2.0 • Download the .NET Framework 2.0 (x86). • After downloading, execute dotnetfx.exe and follow the instructions to complete the installation. • MSXML6 • Download MSXML6. Execute msxml6.msi. This is a quick installation.

  6. Step 4: Create a SQL Server service account • Create a domain account named "SQL Express User" forth is purpose. If you're joined to a domain -- which you should be -- use Active Directory Users and Computers. • If you're just testing locally, use Computer Management to add the account. • Make sure to also assign a strongpassword to the account. • Here a user account is configured so that the password doesnotexpire. • In addition, anyone logging in as this user -- no one should be doing that though -- will not be able to change the password.

  7. Step 5: Install SQL Server 2005 Express Edition • Now, start installing SQL Server 2005 Express Edition with Advanced Services SP1. • The name of the downloaded file is SQLEXPR_ADV.EXE. • Double-click this file to start the product installation. • The contents of the file are extracted and the installation begins.

  8. Step 5: Install SQL Server 2005 Express Edition • After you start the installation, you have to agree to the typical End User License Agreement after which you're presented with a screen that shows you what pre-requisites you need to get the express edition on your system. • The installer will handle the installation of these prerequisites for you. • Click the Install button to install these items. • Once the items are installed, • clicktheNextbutton.

  9. After that, you have to provide your name and, optionally, your company's name. • I have also unchecked the box marked "Hide advanced configuration options" so you can get a look at these options during the installation.

  10. Next, you get to choose which features you want to install. • Even though the Express Edition is free, it includes many of the features found in the Standard and Enterprise editions. I've decided to install everything except replication. • Notethat I've picked also to install the ManagementStudioExpress. • This is an outstanding utility provided by Microsoft and it replaces QueryAnalyzer and EnterpriseManager. • I highly recommend you install this tool. • I'm installing into the default location, C:\Program Files\Microsoft SQL Server. • If you want to install to a different location, click the Browsebutton to choose this newlocation.

  11. Instances were introduced in SQL Server 2000 and provide a way for you to more seamlessly serve multiple databases from a single SQL Server. • SQL Server 2005 Express Edition supports up to 16 named instances while the Enterprise Edition supports up to 50. • Formyinstallation, I'm installing SQL Server 2005 Express Edition as the defaultdatabaseinstance on my server.

  12. Serviceaccounts are used in order to better protect your SQLServer-- and the rest of your network -- in the event of a security break. • If you run your SQLServer under an administrative account, you run the risk of additional damage should your server be compromised. • Therefore, run SQLServer2005Express Edition under a user account with few, if any, rights.

  13. SQLServer can authenticateusers in two ways: (1) directly against Active Directory (Windows Authentication Mode); (2) against its own database (Mixed Mode, since Windows Authentication is also supported). • From a security perspective, Windows Authentication mode is highly preferred. • First off, you have only a single user database -- Active Directory -- to worry about.

  14. The next step of the installation involves selecting a collation method, which defines the way that your SQL Server will sort data. • If you need to maintain backwardcompatibility with older versions of SQL Server, you should choose SQL Collations. • If, however, you do not need to worry about backward compatibility, you should choose the Latin1_General collation method, unless, of course, you're using a different language.

  15. SQLServer2005Express provides a newfeature: • The ability to run sub-instances of the product under a normal user account. • User instances are useful in situations in which users are logged into Windows under a least-privileged user account. • Using userinstances, the user can still have SQL system administratorprivilegesto their SQL. • Databases housed under user instances support only a single connection and higher-end features such as replication are not supported. • If you want to support userinstances in your installation, make sure the checkbox next to "EnableUserInstances" is selected.

  16. Introduced as an add-on for SQL Server 2000, an enhancedversion of Reporting Services is included with SQL Server 2005. • For your small SQL Server2005 Express Edition installation, I recommend that you install this feature, but don't worry about customizing the configuration. • The default configuration places the tool at http://{your server name}/ReportServer. • The ReportManager tool is placed at http://{yourserver name}/Reports.

  17. Microsoft has included an errorreportingtool in other applications for quite some time. • This feature is now optionally included in SQL Server 2005Express. • Further, Microsoft wants you to send them anonymous usage data about your installation. • Neitheroption is enabled by default. • Personally, I like the error reporting service and the only way it will improve is by adding data.

  18. These are all of your options for SQL Server 2005 Express Edition. • Continue on to install the product using these selections.

  19. Installed and ready • Atthispoint, SQL Server 2005 Express Edition is installed and can be managed using the SQL Server Management Studio Express tool that was installed along with the database server. • Toaccess this tool go to: • Start | All Programs |Microsoft SQL Server 2005 | SQL Server Management Studio Express.

More Related