ArcGIS Connection

[JeremyNeufeld7186]

Using Map 3D 2019 I'm trying to connect to an ArcSDE Enterprise connection.  The database is stored in SQL Server with no instance name.  When I connect using the server name in both the server name and instance name fields I get the following error: "ESRI: Entry for SDE instance not found in services file."  I'm not sure how to go about getting this connection established.  I'd appreciate any help available.

Thanks. 

[JeremyNeufeld7186]

I was able to get a little bit further.  If I use the Add ArcGIS Connection and select ArcSDE Enterprise I can connect with the following:

Server name: <sqlservername>

Instance Name: sde:sqlserver:<sqlservername>

Data store: <database name>

I'm connecting using sa for permissions while testing.  The problem with this is that the data comes in read only.  I'm unable to modify it in Map 3D

When I attempt to use the Add ArcSDE Connection using the same server name, instance name and credentials I get the following error:

Failed to connect.

FDO Provider entry point function 'CreateConnection' returned NULL.

[Gary_Braun · Accepted solution]

SA is the SQL db Admin but may not be a geodatabase user, I would try the ArcGIS Connection with a different user. You must have a named geodatabase user having read-write access that you can use to test the connection.

Also, after adding data to your map you may need to use the MAPEDITSETAUTO command to toggle editing. I have to in any case.

[JeremyNeufeld7186]

---

@Gary_Braun wrote:

Also, after adding data to your map you may need to use the MAPEDITSETAUTO command to toggle editing. I have to in any case.

---

The MAPEDITSETAUTO command did it.  Thank you very much!