Creating FDO-Enabled SQL Server Spatial Data Stores
Concept Procedure
 
 
 

To create a data store for SQL Server Spatial

  1. On the Task Pane, click either the Map Explorer or Display Manager tab.
  2. Click Data Connect To Data.
  3. In the Data Connections By Provider list in the Data Connect window, select Add SQL Server Spatial Connection).
  4. In the right-hand pane, enter a connection name (the name you will call this data store in AutoCAD Map 3D) and the information required to connect to the data store, for example, a service name.
    NoteDo not use the same name you used when you created a user for the data store.
  5. Log into the service for the store, using either Windows authentication or SQL Server authentication.
  6. In the Data Store list, select Add New Data Store (or type a name that does not appear in the list already) and press Enter.

    You are asked if you want to create a new data store. Click Yes.

  7. In the Create Data Store Dialog Box for this provider, enter the settings for the new data store.

    Specify whether the new data store will be FDO-enabled or not by selecting or clearing Use FDO Enabled Schema. FDO-enabled data stores include additional FDO metadata, but otherwise use native SQL Server schema capabilities.

  8. Click OK.

    If the data store is created successfully, a confirmation message prompts you to edit its schema. Use the Schema Editor to create or import the schema for the data store.

    The Concept tab for this topic describes issues concerning geometric and geogra[hic properties, as well as issues with coordinate systems for SQL Server Spatial data stores.

    You are connected to the new data store automatically.