Creation of New Instance in SQL Server 2005

  • .

  • You’ll have to explain your question. Do you want to install a second instance on a server? Do you want to rename an SQL Server instance? Or did you mean something completely different? Asking how to install an SQL server that is already installed has the same logic as how to turn on a computer that is already turned on.

    Adi

    --------------------------------------------------------------
    To know how to ask questions and increase the chances of getting asnwers:
    http://www.sqlservercentral.com/articles/Best+Practices/61537/

    For better answers on performance questions, click on the following...
    http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

  • Hello,

    I want to create new instance of SQL Server 2005 which is already installed in my system.

    Thank u,

  • For some reason you don’t want to explain what you need. From what I understood, you already have an SQL Server installed on your machine and you want to install a second server. All you have to do is use the installation disk/DVD and install the second instance. The installation process is the almost exactly the same as the installation process of the first instance. The wizard will take you through the installation. If I misunderstood your question, try to explain it better.

    Adi

    --------------------------------------------------------------
    To know how to ask questions and increase the chances of getting asnwers:
    http://www.sqlservercentral.com/articles/Best+Practices/61537/

    For better answers on performance questions, click on the following...
    http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

  • BOL,

    On the Instance Name page, select a default or named instance for

    your installation. If a default or named instance is already installed, and

    you select the existing instance for your installation, Setup upgrades it

    and provides you the option to install additional components. To install a

    new default instance, there must not be a default instance on the

    computer. To install a new named instance, click Named Instance and

    then type a unique instance name in the space provided. To install a

    new named instance side-by-side with an existing instance, click Named

    Instance and then type a unique instance name in the space provided.

    For more information about instance naming rules, click Help at the

    bottom of the page, or see the Instance Name topic in SQL Server 2005

    Books Online.

    http://msdn.microsoft.com/en-us/library/ms143219(SQL.90).aspx

    Ohh dint see the reply from Adi!

    ---------------------------------------------------------------------------------

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply