Planning your desktop COSA database submission

Important

Starting in Windows 10, version 1703, the APN spreadsheet (apndatabase.xml) is replaced by the Country and Operator Settings Asset (COSA) database. Windows 8, Windows 8.1, and versions of Windows 10 before version 1703 will continue to use the APN database while Windows 10, version 1703 and later use COSA. For more information about COSA, see COSA overview.

Use this article plan for adding a new APN to the baseline COSA database that ships with Windows desktop devices, or to update an existing APN.

The COSA update process

To connect to a mobile broadband network, the user provides the following information:

  • On GSM networks, an Access Point Name (APN) such as "data.contoso.com".
  • On CDMA networks, an access string that includes a special dial code such as "#777" or a Network Access Identifier such as "somebody@contoso.com".
  • A username and password for the network connection.

The COSA connectivity database is updated by using Windows Update.

Use the Microsoft mobile operator portal

The Microsoft mobile operator configuration portal (MOCP) is a web-based tool that allows mobile operators (MOs) to submit APN updates to Microsoft. The MOCP is used to submit APN updates for the COSA database. For more information about the MOCP, see the Microsoft mobile operator configuration portal.

For more information about the mobile operator portal, see the Mobile operator configuration portal guide.

COSA database considerations

  • The operator identification data is stored in the COSA database as encoded Hardware IDs.

    • For GSM networks, you can have a separate database entry for each unique combination of MCC/MNC pair. If you are a Mobile Virtual Network Operator (MVNO) and do not have a unique MCC/MNC pair, you can specify one or more ranges of IMSIs or SIM ICC IDs currently leased from a Mobile Network Operator (MNO).
    • For CDMA networks, you can have a new database entry for each Provider ID (also called a SID) or Provider Name.
    • Certificate information for account provisioning metadata includes Cert Issuer Name and Cert Subject Name and is used to verify that account provisioning provided by a purchase website comes from the an authorized web service. If the certificate information stored here matches what the purchase website presents, Windows will allow that website to push network-specific configuration information to the PC.
  • When submitting a COSA database update, the following values must be included:

    • A CDMA Provider name
    • A CDMA Provider ID (SID)
  • Certificate information for account provisioning metadata includes Cert Issuer Name and Cert Subject Name and is used to verify that account provisioning provided by a purchase website comes from an authorized web service. If the certificate information stored here matches what the purchase website presents, Windows will allow that website to push network-specific configuration information to the PC.

  • The auto-connect order must be unique for the Operator and Country/Region combination with the same IMSI, ICCID range, CDMA provider name, or CDMA provider ID value.

    For example, if Contoso had four APNs for MCC+MNC value 100 101, it would list each APN entry in a new row in the spreadsheet and number the auto-connect order starting with 1 up to 4 for each of those four entries because they share the same IMSI range. If Contoso had another set of APNs for MCC+MNC value 100 102, it should start the auto-connect ordering at 1 for that set of APNs.

    If you don't provide an auto-connect order, Windows will ask the user to choose an APN, which could introduce user error. We recommend that the auto-connect order be specified. In this case, the user sees the Friendly Name of the APN in Windows Connection Manager.

  • Changes provided by the OEM will take precedence over the default COSA database included in Windows.

  • The Country/Region and the Operator entries in the spreadsheet are used to determine whether this is an update to an existing APN or a request for a new APN. If the Country/Region and the Operator fields match content that already exists in the COSA database, the entries will be deleted and replaced with the entries that you list in the MOCP.

    Note

    Because the previous entries will be deleted, it is important to list all APNs for the Operator and Country/Region combination, including the ones that are not changing.

    For example, when the following values are entered in the MOCP:

     Operator: Contoso
     Country/Region: Argentina
    

    All entries currently in the COSA connectivity database that match the following format will be deleted and replaced with data for that Operator and Country/Region combination:

    <Operator name="Contoso (Argentina)">
    
  • If the Operator and Country/Region entries do not match content that already exists in the COSA database, a new APN is created.

    For example, if the following values are entered in the MOCP:

    Operator: Contoso
    Country/Region: Argentina
    

    If it does not exist in the appropriate connectivity database, a new entry is added after your submission is accepted that looks like the following:

    <Operator name="Contoso (Argentina)">
    
  • In the mobile operator configuration portal, you must specify only one of the following:

    • An MCC+MNC with a blank IMSI range
    • An MCC+MNC with a specific IMSI range
    • An MCC+MNC with a specific ICCID range
    • An MCC+MNC with a specific GSM provider name
  • If you have created a website for setting up Mobile Broadband service, it is important to provide the Account Experience URL and certificate data.

  • Access strings used for plan purchase (Purchase Flag=Y) can be one of the following:

    • For GSM networks, an APN with a specified User Name and Password used for purchasing the subscription.
    • For CDMA networks, a Network Access Identifier (NAI) is used for purchasing the subscription.
  • Access strings used for Internet connectivity (Connect Flag=Y) can be one of the following:

    • For GSM networks, an APN with a specified User Name and Password used to connect to the Internet.
    • For CDMA networks, a Network Access Identifier (NAI) is used to connect to the Internet.

For the next steps in testing your APN update, see Testing your desktop COSA database submission.