Bringing In Features from SQL Server Spatial
Concept Procedure Quick Reference
 
 
 

To bring in features from SQL Server Spatial

  1. In Display Manager, click DataConnect To Data.
  2. In the Data Connect window, select Add SQL Server Spatial Connection in the Data Connections By Provider list.
  3. Under Connection Name, type a name for this connection.

    You can give the connection any name you like. This name appears in Map Explorer as the name of the feature source.

  4. Enter the Service Name and click Login.

    The service name is set when you install SQL Server Spatial itself.

  5. Specify the login credentials to use to log into this data store.
    • To use your Windows Authentication credentials, select Windows Authentication and click Login.
    • To use your SQL Server login credentials, enter your user name and password and click Login.
  6. In Data Connect, under Data Store, enter the data store name. If you do not know this name, check with your System Administrator.

    To select from a list of data stores, click the down arrow. AutoCAD Map 3D connects to the specified server and instance and lists the available data stores.

    NoteIf the data store is not in the list, it may not use a AutoCAD Map 3D schema. Select Show All Data Stores to add these to the list. AutoCAD Map 3D creates a mapping to use these data stores with AutoCAD Map 3D.
  7. Click Connect.
  8. In the feature class list, select the feature classes to include in the map.

    If this feature source contains only a single feature class, that feature class is selected automatically. If it contains multiple feature classes, you can right-click any of them and select Select All or Select None.

  9. Click Add To Map.

    To bring in a subset of the data, click the down arrow and select Add To Map With Query. To filter data after you’ve added the data to your map, see Filtering Feature Layers.