e-dokumen.id

INSTALLING SQL SERVER 2005 EXPRESS ADVANCED EDITION FORREDHORSE CRMThis article will walk you thru the installation of SQL Server 2005 Express Advanced Edition.Step 1: Download SQL Server 2005 Express EditionSQL Server 2005 Express Edition with Advanced Services SP2 may be downloaded using this px?FamilyId 5b5528b9-13e1-4db9-a3fc82116d598c3d&displaylang en.Please choose to Save this file to disk when downloading so that it may be used more than once. It is notrecommended to choose to Run from the download site.FEATURESVersionSQL Server 2005 Express Edition with Advanced ServicesDatabase engineXClient softwareXFull-text searchXReporting ServicesXManagement Studio ExpressXStep 2: Identify system requirementsSQL Server 2005 Express Edition does not have significant system overhead requirements, particularl y given theoverpowered nature of many of today's newest servers. The minimum system requirements for SQL Server 2005Express Edition with Advanced Services are:RedHorse Systems, .comCopyright 2008-2009 RedHorse Systems, Inc. All rights reserved.

SYSTEM REQUIREMENTSVersionSQL Server 2005 Express Edition with Advanced Services SP1RAM (minimum)512 MBRAM (recommended)1 GBDrive space600 MBProcessor (minimum)600 MHzProcessor(recommended)1 GHzIIS 5 or higherYesOperating systemssupportedWindows Server 2003 SP1, Windows Server 2003 Enterprise Edition SP1,Windows Server 2003 Datacenter Edition SP1, Windows Server 2003 Web EditionSP1, Windows Small Business Server 2003 Standard Edition SP1, WindowsSmall Business Server 2003 Premium Edition SP1, Windows XP ProfessionalSP2, Windows XP Home Edition SP2, Windows XP Tablet Edition SP2, WindowsXP Media Edition SP2, Windows 2000 Professional Edition SP4, Windows 2000Server Edition SP4, Windows 2000 Advanced Edition SP4, Windows 2000Datacenter Server Edition SP4Softwareprerequisites.NET Framework 2.0 & MSXML 6Other requirementsServer joined to your Active Directory domain.Step 3: Install database software prerequisitesThere are a number of software prerequisites for SQL Server 2005 Express Edition. Before you can install thedatabase software, you need to take the necessary steps to get these items installed.Install the following items in order.Internet Information Server 5 or higherRedHorse Systems, .comCopyright 2008-2009 RedHorse Systems, Inc. All rights reserved.

IIS is required for Microsoft SQL Server 2005 Reporting Services (SSRS). If you will not be using ReportingServices, you will not need to install IIS.Reporting Services will not install on operating systems that do not include Internet Information Services (IIS). Thisincludes Windows XP Home Edition, which does not include IIS.If your Windows server does not have IIS installed, go to Start Control Panel Add or Remove Programs Add/Remove Windows Components. ASP.NET 2.0 is required for Reporting Services. When installing ReportingServices, SQL Server Setup will enable ASP.NET if it is not already enabled.NET Framework 2.0Download the .NET Framework 2.0 using this px?FamilyID 0856eacb-4362-4b0d-8eddaab15c5e04f5&DisplayLang enAfter downloading, execute dotnetfx.exe and follow the instructions to complete the installation.MSXML6Download MSXML6 using this link:RedHorse Systems, .comCopyright 2008-2009 RedHorse Systems, Inc. All rights reserved.

milyid 993C0BCF-3BCF-4009-BE2127E85E1857B1&displaylang enExecute msxml6.msi. This is a quick installation.Step 4: Create a SQL Server service accountFrom a security perspective, it's best to run SQL Server as a normal everyday user. When possible, don't use thebuilt-in service accounts on your SQL Server as this practice does not limit your server's attack surface as much asusing an unprivileged user account.If you are installing on XP Pro or higher, or Server 2003 or higher, create a domain account named"SQLExpressUser" for this purpose. If you're joined to a domain -- which you should be -- use Active DirectoryUsers and Computers. If you're just testing locally, use Computer Management to add the account. Make sure toalso assign a strong password to the account.Configure this user account so that the password does not expire. In addition, anyone logging in as this user -- noone should be doing that though -- will not be able to change the password.Step 5: Install SQL Server 2005 Express EditionDouble-click the file SQLEXPR ADV.EXE to start the product installation. The contents of the file are extracted andthe installation begins.After you start the installation, agree to the End User License Agreement after which you're presented with a screenthat shows you what prerequisites you need to get the express edition on your system. The installer will handle theinstallation of these prerequisites for you. Click the Install button to install these items. Once the items are installed,click the Next button.RedHorse Systems, .comCopyright 2008-2009 RedHorse Systems, Inc. All rights reserved.

Once the prerequisites are in place the SQL Server installation wizard will start. The first screen you're shownprovides you with a list of items that may or may not give you trouble if you continue the installation. Note that theinstaller provides you with a complete status report to make it easy for you to determine what needs to be done. Ifyou have any serious problems, correct them before you continue. Click Next to continue.RedHorse Systems, .comCopyright 2008-2009 RedHorse Systems, Inc. All rights reserved.

Next provide your name and your company's name. Unchecked the box marked "Hide advanced configurationoptions".RedHorse Systems, .comCopyright 2008-2009 RedHorse Systems, Inc. All rights reserved.

Next, you will choose which features to install. Even though the Express Edition is free, it includes many of thefeatures found in the Standard and Enterprise editions. In this step, you will choose Database Services (Data Files,Full-Text Search and Shared Tools) and Client Components (Connectivity Components and Management StudioExpress). Instructions for installing SQL Reporting Services are provided after installing the database engine.Choose the default location, C:\Program Files\Microsoft SQL Server, or if you want to install to a different location,click the Browse button to choose this new location.RedHorse Systems, .comCopyright 2008-2009 RedHorse Systems, Inc. All rights reserved.

Install SQL Server 2005 Express Edition using the default setting of Named Instance called “SQLExpress”, unlessother SQL Servers are located on the same machine.RedHorse Systems, .comCopyright 2008-2009 RedHorse Systems, Inc. All rights reserved.

Service accounts are used in order to better protect your SQL Server -- and the rest of your network -- in the eventof a security breach. If you run your SQL Server under an administrative account, you run the risk of additionaldamage should your server be compromised. Therefore, run SQL Server 2005 Express Edition under a useraccount with few, if any, rights. Use the account you created before as the service account for SQL Server 2005.RedHorse Systems, .comCopyright 2008-2009 RedHorse Systems, Inc. All rights reserved.

Using a domain user account is not available in XP Home. When installing on XP Home, select the built-in systemaccount of Network service.RedHorse Systems, .comCopyright 2008-2009 RedHorse Systems, Inc. All rights reserved.

SQL Server can authenticate users in two ways: (1) directly against Active Directory (Windows AuthenticationMode); (2) against its own database (Mixed Mode, since W indows Authentication is also supported). From asecurity perspective, Windows Authentication mode is highly preferred. First off, you have only a single userdatabase -- Active Directory -- to worry about.Either mode is available when using RedHorse CRM and it is recommended to install SQL Server in Mixed Mode.When you choose Mixed Mode, you will also need to provide a password for the SQL Server “sa” user. You mustassign a strong password.RedHorse Systems, .comCopyright 2008-2009 RedHorse Systems, Inc. All rights reserved.

The next step of the installation involves selecting a collation method, which defines the way that your SQL Serverwill sort data. Choose the Latin1 General collation method, unless, of course, you're using a different language. Orchoose SQL Collations if you need to maintain backward compatibility with older versions of SQL Server.RedHorse Systems, .comCopyright 2008-2009 RedHorse Systems, Inc. All rights reserved.

SQL Server 2005 Express provides a new feature: The ability to run sub-instances of the product under a normaluser account. User instances are useful in situations in which users are logged into Windows under a leastprivileged user account. Using user instances, the user can still have SQL system administrator privileges to theirSQL "sandbox", but the rest of the system is protected since the user's primary account does not have rights tomake global changes. Databases housed under user instances support only a single connection and higher-endfeatures such as replication are not supported.If you want to support user instances in your installation, make sure the checkbox next to "Enable User Instances"is selected.RedHorse Systems, .comCopyright 2008-2009 RedHorse Systems, Inc. All rights reserved.

Microsoft has included an error reporting tool in other applications for quite some time. This feature is nowoptionally included in SQL Server 2005 Express. Further, Microsoft wants you to send them anonymous usage dataabout your installation. Neither option is enabled by default. You may decide what information you want to send.RedHorse Systems, .comCopyright 2008-2009 RedHorse Systems, Inc. All rights reserved.

These are all of your options for SQL Server 2005 Express Edition. Continue on to install the product using theseselections.RedHorse Systems, .comCopyright 2008-2009 RedHorse Systems, Inc. All rights reserved.

In some cases, your installation may fail with errors reported for the SQL Native Client and the SQL ServerDatabase Services. In addition, the Workstation Components selection may indicate a failure. If this happens toyou, it may be because you formerly had a conflicting SQL Server service on the machine and t he Native Clientpreviously installed is creating a problem. If this is the case for you, follow these steps:1. Change to the directory in which you saved the downloaded SQL Server Express 2005 installer.2. Extract the contents of the installer to a new directory: SQLEXPR ADV.EXE /x:c:\sqltmp. If you are usingthe download that does not contains the advanced services, this command is SQLEXPR.EXE /x:c:\sqltmpinstead.3. Change to C:\sqltmp\setup.4. Execute "sqlncli.msi"5. Choose the "Uninstall" option.6. Reboot your server.7. Run the SQL Server Express 2005 installer again. It should be successful this time around.RedHorse Systems, .comCopyright 2008-2009 RedHorse Systems, Inc. All rights reserved.