SQL Server Performance

How do I create a new SQL Server 2005 Instance?

Discussion in 'SQL Server 2005 General DBA Questions' started by Trev256, Dec 5, 2007.

  1. Trev256 New Member

    Do I have to install SQLO Server again??
  2. Greg Larsen New Member

    Yes you go through the install again. Pop in the CD and install a named instance.
  3. jn4u Member

    Use the Instance Name page of the SQL Server Installation Wizard to specify whether to create a default instance or a named instance of SQL Server. A default instance name is used unless you choose a named instance.
    Each SQL Server instance is made up of a distinct set of services with specific settings for collations and other options. The directory structure, registry structure, and service names all reflect the specific instance ID of the SQL Server instance created during SQL Server Setup.
    An instance is either the default instance or a named instance. The default instance name is MSSQLSERVER; it does not require a client to specify the name of the instance to make a connection. A named instance is determined by the user during Setup.
    A named instance can be installed at any time. By default, the first time you install SQL Server 2005 on a computer, Setup specifies the installation as the default instance; however, you can choose to install SQL Server as a named instance without installing the default instance first. The default instance could be an installation of SQL Server version 6.5, 7.0, 2000, or 2005. Only one installation of SQL Server, regardless of version, can be the default instance at any one time.

Share This Page