How do I connect to a Personal SDE Geodatabase

From fmepedia


Q) How do I connect to a Personal SDE Geodatabase based on SQL Express?

A)ArcSDE 9.2 now supports a personal SDE Geodatabase based on the Microsoft SQL Express database. To build a geodatabase you need to use ArcCatalog and the Add Database Server option to add a connection to the SQL Express Database Server. Now you can right click on this connection and select "New Geodatabase" to create the geodatabase.

To connect to this geodatabase using FME use the following settings in the Geodatabase ArcSDE Input or Output dialog box

  • Connection: OS Authentication
  • Server: <name of the server> e.g. bd-Inara
  • Database: <name of the geodatabase> e.g. test_personal
  • Instance Name: sde:sqlserver:<server name>\SQLEXPRESS
  • Version: dbo.DEFAULT
Retrieved from "http://www.fmepedia.com/index.php/How_do_I_connect_to_a_Personal_SDE_Geodatabase"
User Comments Add a new comment