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.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft