To create a data store for SQL Server
- On the Task Pane,
click either the Map Explorer or Display Manager tab.
- Click Data Connect
- In the Data Connections By
Provider list in the Data Connect window, select Add
SQL Server Spatial Connection).
- 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.
- Log into the service for the store, using
either Windows authentication or SQL Server authentication.
- 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.
- 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.
- 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
You are connected to
the new data store automatically.