TechNet
Export (0) Print
Expand All

Instance Name (64-bit)

SQL Server 2000

  This topic applies only to SQL Server 2000 (64-bit).

Use the Instance Name page of the Microsoft® SQL Server™ 2000 (64-bit) Installation Wizard to specify whether to create a default instance or a named instance of SQL Server. A default instance name will be used unless you choose a named instance.

Options

Default instance

Choose this option to install a default instance of SQL Server 2000. If this option is disabled, it is because Setup has detected a default instance of SQL Server already installed on this computer. A computer can host only one default instance; all other instances must be named.

Named instance

Choose this option to enter a new instance name. Note the following when naming an instance of SQL Server:

  • Instance names are not case-sensitive.

  • Instance names cannot contain "Default" or "MSSQLServer."

  • The first character in the instance name must be a letter, an underscore (_), or a number sign (#). Acceptable letters are those defined by Unicode Standard 2.0, including Latin characters a-z, A-Z, and letter characters from other languages. Numbers and the ampersand sign (&) are not allowed.

  • Subsequent characters can be letters defined by Unicode Standard 2.0, decimal numbers from Basic Latin or other national scripts, the dollar sign ($), number sign (#), or an underscore (_).

  • Embedded spaces or other special characters are not allowed in instance names; nor are the backslash (\), comma (,), colon (:), or at sign (@).

  • The identifier may not be a reserved keyword. If you enter a reserved keyword as part of the instance name, an error occurs with the message: "The instance name specified is invalid."

    Note  Only characters that are valid in the current Microsoft Windows® code page can be used in SQL Server instance names. If an unsupported Unicode character is used, an error occurs.

Show:
© 2016 Microsoft