Share via

Connecting to the Component Database (Windows Embedded Standard 2009)

  • Article

4/23/2012

This section outlines the various ways to connect to the Windows Embedded Standard component database, also known as MANTISSQLDB, by using the Component Database Manager (CDM).

Different ways of connecting to MANTISSQLDB

  1. You can connect to a default instance of the database on your computer by typing local or the computer name in the Database Server Location text box in the CDM.
  2. Named instance on the local computer. You can type any of the following into the Database Server Location text box in the CDM.
    1. (local)\<InstanceName>, for example, (local)\MyInstanceOfSQL.
    2. <MachineName>\<InstanceName>, for example, MyMachine\MyInstanceOfSQL.
  3. Default instance on a remote computer. As a prerequisite, you must do the following:

    1. Make sure that SQL Server Browser service is started and active on the remote computer.

    2. On the remote computer, choose Start, choose AllPrograms, choose Microsoft SQL Server 2005, point to Configuration Tools, and then choose SQL Surface Area Configuration.

    3. On the SQL Surface Area Configuration screen, choose Surface Area Configuration for Services and Connections.

    4. On the Surface Area Configuration for Services and Connections screen, choose either the View by instance tab or the View by component tab, and choose Remote Connections as the component. Choose Local and remoteconnections, and choose the option Using both TCP/IP and named pipes.

    5. Restart the service.

    6. The firewall on the remote computer is configured to allow connections to the SQL Server Browser service. You can configure the firewall by starting My Network Places. Choose View Network Connections, and then choose Change Firewall Settings. On the Exceptions tab, choose Add program and add the instance of SQLSERV.exe and SQLBrowser.exe. On the same screen, choose Add Port and add port number 1433 (default port number for SQL Server).

      Note

      You can check the port number of SQL Server from the registry key HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server&lt;SQL Version No>&lt;SQL Instance name>\SuperSocketNetLib\Tcp\IPAll.

    7. In the CDM, type the remote computer name.

  4. Named instance on a remote computer. Follow all the steps a to g in step 3 earlier. Type the following in the CDM, <remote computer name>\<name of instance of SQL Server>. For example, RemoteMachine\RemoteInstanceOfSQL.