How to: Specify the SQL Server instance that will be used by Windows Embedded Standard installation wizard (Windows Embedded Standard 2009)

  • Article

4/23/2012

Use the SQL Server Instance Name page of the Windows Embedded Standard installation wizard to choose the SQL Server instance that will be used during setup.

A SQL Server instance can be either a default instance or a named instance. A default instance is an installation of SQL Server that uses the same name as the computer name on which it is installed, also referred to as <MachineName>. A software client need only specify the computer name when connecting to a default instance. SQL Server 2000 and higher support multiple SQL Server instances on a single computer or processor, but only one instance can be the default instance; all others must be named instances. A named instance is an installation of SQL Server that is given a name to differentiate it from other named instances and from the default instance on the same computer. A named instance is identified by the computer name on which it is installed and its instance name, also referred to as <InstanceName>. A software client must specify both the computer name and the instance name when connecting to a named instance.

On the SQL Server Instance Name page of the Windows Embedded Standard installation wizard you will utilize the Server Name list to choose the SQL Server instance that will be used by setup. The following scenarios will help you determine how to specify the SQL Server instance.

  1. Install a new component database or migrate from an existing component database.
    Note: To install a new component database or to migrate an existing component database you must specify a local SQL Server Instance. The component database cannot be installed to or migrated on a remote SQL Server Instance.
    • Choosing a default instance: Select/enter either (local) or <MachineName>.
    • Choosing a named instance: Select/enter either (local)\<InstanceName> or <MachineName>\<InstanceName>.
      Example
      If the component database will be created on a SQL Server 2005 Express instance named SQLEXPRESS and the name of the computer running that SQL Server is PC-COMPDB, you can enter either (local)\SQLEXPRESS or PC-COMPDB\SQLEXPRESS as the SQL server instance.
  2. Install tools and connect to a local SQL Server Instance
    • Choosing a default instance: Select/enter either (local) or <MachineName>.
    • Choosing a named instance: Select/enter either (local)\<InstanceName> or <MachineName>\<InstanceName>.
  3. Install tools and connect to a remote SQL Server Instance
    • Choosing a default instance: Select/enter <MachineName>.
    • Choosing a named instance: Select/enter <MachineName>\<InstanceName>.
      Example
      If the component database exists on a remote SQL Server 2005 instance named REMSQLSERVER and the name of the computer running that SQL Server is PC-COMPDB, you can enter PC-COMPDB\REMSQLSERVER.

Note

For Windows Embedded Standard installer to detect a remote SQL Server instance, you must start the SQL Server browser service on the remote server running that instance.