• Computer Using
• Windows
• Browser
• How-To
• Microsoft Office
• MS Word
• MS Excel
• MS Outlook
• MS PowerPoint
• Graphic / Design
• Photoshop
• Illustrator
• Server & Network
• Computer Networking
• Internet
• Windows Server
• Web Development
• HTML
• Javascript
• CSS
• ASP.NET
• PHP
• Animation
• Flash
• Silverlight
• Database
• Database System
• SQL Server
• T-SQL
• XML
• XML

How to Setup SQL Server 2005

1. This form shows the License for End User to update, supplements, Internet-based services and support services on Microsoft SQL Server 2005 Setup.
   Tick on I accept the licensing terms and conditions
   
2. This screen you're shown provides you with a list of items that may or may not give you trouble if you continue the installation.
   Click Next to continue setup Microsoft SQL Server 2005
   
3. After Installing Prerequisites finished it will show Microsoft SQL Server 2005 Setup form that you must Click Next button to continue setup Microsoft SQL Server 2005.
   
4. This form checks about System Configuration and show you about hardware and software requirement.
   Click Next to continue setup.
   
5. To complete setup Microsoft SQL server 2005 need you to fill your name, your name must be input, and your Company is optional, you can’t input it.
   After fills your name and your company than click Next to continue setup.
   
6. This is the form show you about components services that you want to install.
   
   Let’s briefly take a look at what each of these components are:
   • SQL Server Database Service: this is the main core for SQL Server 2005 and installs the main engine, data files, etc., to make SQL Server run.
   • Analysis Services: This tool you can take a set of data and dice and slice and analyze the information contained.
   • Reporting Services: This tool allows reports to be produced from SQL Server instead of using third-party tools like Crystal Reports.
   • Notification Services: This tool allows notifications such as a message sent to areas like SMS or any process that is listening, to “hear” when certain actions occur.
   • Integration Services: This component allows importing and exporting data using data sources that are not only SQL Server but also Oracle, Excel, MS Access, etc.
   • Workstation components, Books Online and Development tools: These are tools for working on the workstation. This installs the GUI (Graphic User Interface) we use with SQL Server, and it can also install the help feature, Books Online, it like MSDN on Microsoft Visual Studio.
   After you choose some Component tools that you want to install. Click Next to continue setup.
7. Default Instance: SQL server will use your computer name as Instance Name.
   Named instance: allow you input instance name that you like. And then click Next.
   
8. SQL Server needs account for log on to use SQL service.
   If you want use account on your computer you can choose Use the built-in System account and select Local System.
   If your computer join domain you can use your account on your domain by input Username, Password, and your domain name.
   And you can select some service to start up when your computer is start.
   
   
9. Windows Authentication Mode denotes that you are going to use Windows security to maintain your SQL Server logins, whereas mixed mode use either Windows security or a SQL Server defined Login ID and Password. We also need to define a password for a special login ID, called sa. ID “sa” is the built-in account on SQL server 2005.
   In this example I choose Mixed Mode so I need to input Password for user account sa. And then click Next to continue.
   
10. Collation settings specify how sorting and comparison of rows of data are dealt with within SQL Server. For example, a collation setting will inform SQL Server details such as whether the system is case sensitive. It is possible to have different collation settings for each type of SQL Service, shown in the earlier setup process, so you could sort one way for Analysis Services different from that defined for your main SQL Server 2005 installation. It would only be in exceptional circumstances that you would do this, as it will cause extra processing complications when using the same processing in more than one service. Click Next to continue setup.
    
11. We selected Reporting Services to be installed, we need to create a database for the reporting server to use. Depending on your requirement and how heavily used your SQL Server installation is, you may wish your reports to be run out of a separate and purpose-built SQL Server installation. For the moment, I will install Reporting Services on the same SQL Server. And then click Next.
    
12. Within SQL Server, it is possible for any errors to be automatically reported and sent to Microsoft. These include fatal error where SQL Server shut downs unexpectedly. And then click Next to continue
    
13. This form tells you what Microsoft SQL Server 2005 will be set up.
    Click Install to install Microsoft SQL Server 2005.
    
14. This form shows you the action while installing Microsoft SQL Server 2005.
    
15. Click Finish to completing Microsoft SQL Server 2005 setup.