Logo

Navigation
  • Home
  • Services
    • ERP Solutions
    • Implementation Solutions
    • Support and Maintenance Solutions
    • Custom Solutions
    • Upgrade Solutions
    • Training and Mentoring
    • Web Solutions
    • Production Support
    • Architecture Designing
    • Independent Validation and Testing Services
    • Infrastructure Management
  • Expertise
    • Microsoft Development Expertise
    • Mobile Development
    • SQL Server Database and BI
    • SAP BI, SAP Hana, SAP BO
    • Oracle and BI
    • Oracle RAC
  • Technical Training
    • Learn Data Management
      • Business Intelligence
      • Data Mining
      • Data Modeling
      • Data Warehousing
      • Disaster Recovery
    • Learn Concepts
      • Application Development
      • Client Server
      • Cloud Computing Tutorials
      • Cluster Computing
      • CRM Tutorial
      • EDI Tutorials
      • ERP Tutorials
      • NLP
      • OOPS
      • Concepts
      • SOA Tutorial
      • Supply Chain
      • Technology Trends
      • UML
      • Virtualization
      • Web 2.0
    • Learn Java
      • JavaScript Tutorial
      • JSP Tutorials
      • J2EE
    • Learn Microsoft
      • MSAS
      • ASP.NET
      • ASP.NET 2.0
      • C Sharp
      • MS Project Training
      • Silverlight
      • SQL Server 2005
      • VB.NET 2005
    • Learn Networking
      • Networking
      • Wireless
    • Learn Oracle
      • Oracle 10g
      • PL/SQL
      • Oracle 11g Tutorials
      • Oracle 9i
      • Oracle Apps
    • Learn Programming
      • Ajax Tutorial
      • C Language
      • C++ Tutorials
      • CSS Tutorial
      • CSS3 Tutorial
      • JavaScript Tutorial
      • jQuery Tutorial
      • MainFrame
      • PHP Tutorial
      • VBScript Tutorial
      • XML Tutorial
    • Learn Software Testing
      • Software Testing Types
      • SQA
      • Testing
  • Career Training
    • Career Improvement
      • Career Articles
      • Certification Articles
      • Conflict Management
      • Core Skills
      • Decision Making
      • Entrepreneurship
      • Goal Setting
      • Life Skills
      • Performance Development
      • Personal Excellence
      • Personality Development
      • Problem Solving
      • Relationship Management
      • Self Confidence
      • Self Supervision
      • Social Networking
      • Strategic Planning
      • Time Management
    • Education Help
      • Career Tracks
      • Essay Writing
      • Internship Tips
      • Online Education
      • Scholarships
      • Student Loans
    • Managerial Skills
      • Business Communication
      • Business Networking
      • Facilitator Skills
      • Managing Change
      • Marketing Management
      • Meeting Management
      • Process Management
      • Project Management
      • Project Management Life Cycle
      • Project Management Process
      • Project Risk Management
      • Relationship Management
      • Task Management
      • Team Building
      • Virtual Team Management
    • Essential Life Skills
      • Anger Management
      • Anxiety Management
      • Attitude Development
      • Coaching and Mentoring
      • Emotional Intelligence
      • Stress Management
      • Positive Thinking
    • Communication Skills
      • Conversation Skills
      • Cross Culture Competence
      • English Vocabulary
      • Listening Skills
      • Public Speaking Skills
      • Questioning Skills
    • Soft Skills
      • Assertive Skills
      • Influence Skills
      • Leadership Skills
      • Memory Skills
      • People Skills
      • Presentation Skills
    • Finding a Job
      • Etiquette Tips
      • Group Discussions
      • HR Interviews
      • Interview Notes
      • Job Search Tips
      • Resume Tips
      • Sample Resumes
 

Installing a Second Copy of SQL Server 2005

By Exforsys | on November 29, 2005 |
SQL Server 2005

Installing a Second Copy of SQL Server 2005

Multiple instances of SQL Server are supported by SQL Server 2005. Previous versions of SQL Servers can also be upgraded to SQL Server 2005. In this section we shall see how to install a second copy of SQL Server 2005. A little later in this tutorial we shall examine how existing versions of SQL Server can be upgraded.

If a version of SQL Server already exists on the computer, the second copy will be installed as a named instance.

Insert the DVD into the drive and the Installation wizard will guide you through the installation.

The first screen that pops up is the End user license agreement. Once the user accepts the license, the system check begins.

Microsoft SQL Server now checks whether the system has the software components required to run SQL Server. Since this is the second instance, all the required files are available and the wizard proceeds to install only the setup support files.

The Next step is the System configuration check. This step is used to examine the computer for potential configuration problems.

If configuration check reveals problems the setup is rolled back. Else the user is allowed to proceed with the installation. When the configuration check is successful, the first screen of the server installation wizard appears. The user has to click next to proceed.

The registration information has to be entered. The Name field is compulsory.

The next screen requires the user to enter the components that he wishes to install. The components selected are to be checked and the user has to click Next to install them.

The next screen displays the features selected by the user for installation and the drive space required by each of the components selected. The user has to confirm that he wishes to install the components and that he has the requisite drive space by clicking Next.

Since a default instance already exits in the system a named instance is being installed. Select Named instance and assign a name to it. Here we have named it Exforsys. If you want to see the other instances installed on the system click on Installed instances or click Next.

In the system on which the second instance is being installed, Analysis Services and SQL Server have been already installed.

If the SQL server is being upgraded from an earlier version or a side by side installation is being done, the user is required to specify whether he wants to upgrade the existing versions or let them remain as they are.

The next screen displays the installed components and upgrade options. The user is informed that for maintaining the product he must access Add/Remove programs.

The next step is the specification of the service accounts to log in. The user can select the built in system or user domain account.

The next screen asks the user select the Authentication mode. He can select the Windows Authentication mode or the mixed mode for this installation.

The wizard now asks the user specify the collation settings. A number of collation options are available. The collation designator and sort order and SQL collations have to be indicated.

The user can now specify the error and usage report settings. He can choose to send the reports to Microsoft or not.

Now that all the settings have been specified, SQL Server is ready to install the components selected. The user is informed that all the selected components will be installed and changes to any of the components as specified will be carried out.

The next screen displays a progress bar while the Setup wizard migrates the Windows Installer properties to Bootstrap.

The required components are then configured and requested changes are carried out.



The next screen displays the progress on the setup of each of the items selected. An arrow indicates that the configuration of components is underway and a tick mark indicates the completion of the setup.

The next screen displays a summary log. If an upgradation from an earlier version has been undertaken the user is informed that all the cubes in Analysis services will have to be reprocessed. The reporting services will require further configurations depending on the options specified at installation and so on…Click Finish to complete the installation.

Now login to the named instance Exforsys and browse the servers installed to select the sever you need to log in to!

In this lesson we have explored side by side installations of SQL Server. In the sections that follow we shall examine how to upgrade from earlier versions of the server.

« « Planning to Install SQL Server 2005
SQL Server 2005 Installation – Maintenance Plan Using Wizard » »

Author Description

Avatar

Editorial Team at Exforsys is a team of IT Consulting and Training team led by Chandra Vennapoosa.

Ads

Free Training

RSSSubscribe 416 Followers
Ads
  • Popular
  • Recent
  • SQL server 2005 Editions

    November 23, 2005 - 0 Comment
  • Using SQL Sever Management Studio – Part 1

    December 15, 2005 - 0 Comment
  • XML Data Types in SQL Server 2005

    October 26, 2005 - 0 Comment
  • Managing SQL Server 2005 Security

    December 24, 2005 - 0 Comment
  • SQL Server 2005 Installation

    November 23, 2005 - 0 Comment
  • Getting started with SQL Server 2005

    August 9, 2005 - 0 Comment
  • Using SQL Sever Management Studio – Part 2

    December 15, 2005 - 0 Comment
  • Native HTTP Support in SQL Server 2005

    November 1, 2005 - 0 Comment
  • SQL Server 2005 – Managing Permissions

    December 26, 2005 - 0 Comment
  • Planning to Install SQL Server 2005

    November 29, 2005 - 0 Comment
  • SQL Server 2005 – Configuring Replication

    January 11, 2006 - 0 Comment
  • SQL Server 2005 Replication Enhancements

    January 11, 2006 - 0 Comment
  • SQL Server 2005 – Mirror Server

    January 11, 2006 - 0 Comment
  • SQL Server 2005 – Introduction to Data Availability

    January 1, 2006 - 0 Comment
  • SQL Server 2005 – Backing up a Database

    January 1, 2006 - 0 Comment
  • SQL Server 2005 – Using Database Snapshots

    December 26, 2005 - 0 Comment
  • SQL Server 2005 – Disaster Recovery

    December 26, 2005 - 0 Comment
  • SQL Server 2005 – Managing Certificates

    December 26, 2005 - 0 Comment
  • SQL Server 2005 – Managing Permissions

    December 26, 2005 - 0 Comment
  • Managing SQL Server 2005 Security

    December 24, 2005 - 0 Comment

Exforsys e-Newsletter

ebook
 

Related Articles

  • SQL Server 2005 – Configuring Replication
  • SQL Server 2005 Replication Enhancements
  • SQL Server 2005 – Mirror Server
  • SQL Server 2005 – Introduction to Data Availability
  • SQL Server 2005 – Backing up a Database

Latest Articles

  • Project Management Techniques
  • Product Development Best Practices
  • Importance of Quality Data Management
  • How to Maximize Quality Assurance
  • Utilizing Effective Quality Assurance Strategies
  • Sitemap
  • Privacy Policy
  • DMCA
  • Trademark Information
  • Contact Us
© 2021. All Rights Reserved.IT Training and Consulting
This website uses cookies to improve your experience. We'll assume you're ok with this, but you can opt-out if you wish.Accept Reject Read More
Privacy & Cookies Policy
Necessary Always Enabled