<div>I have been trying to make an autocad map (2010, 2011) connection to sql2008 express with an arcsde 9.3.1 personal gdb. I get several reactions depending on which connection and the values I use. I tried going through autodesk support to get a resolution. I got the following response from them. I have seen some responses on this forum expressing that the connection is possible. Any help would be appreciated.</div>
<div>Brad</div>
<div>My connection parameters...</div>
<div>sql server spatial</div>
<div>service name: sde:sqlsserver:myserver\sqlexpress</div>
<div>response: credentials are not valid or provider is unable to establish a connection.</div>
<div>ArcSDE connection</div>
<div>server name: myserver\sqlexpress</div>
<div>instance name: sde:myserver\sqlexpress</div>
<div>response: no error on credentials but the data store not populated</div>
<div>the sde:sqlserver:myserver\SQLEXPRESS syntax works in FME and returns the geometry correctly</div>
<div> </div>
<div>Autodesk Response ...</div>
<div>
<p><span style="FONT-FAMILY: 'Verdana','sans-serif'; FONT-SIZE: 8pt">Here's the official word from the product manager: </span></p>
<p><span style="FONT-FAMILY: 'Calibri','sans-serif'; COLOR: #1f497d"><font size="3">This is not a supported configuration. Not tested. I suspect the "local connect" string is not understood by our provider. But even if Map 3D did connect, you wouldn’t be able to "create a datastore". FDO Provider for ArcSDE doesn’t allow creation of data store from Map 3D. you can only connect and edit existing ArcSDE Data Stores.</font></span></p>
<br></div>