Take the 2-minute tour ×
Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It's 100% free, no registration required.

i have the following server system:

-Windows Server 2008R2 -SQL Server 2008 (SDE10 Enterprise Geodatabaees) and SQL Server 2012 on the the same machine -ArcSDE Application Server 10

First - Is that right, that i do not need to install the ArcSDE 10.1 for Microsoft SQL Server because we use direct connect on the client ?

Now i want to create with ArcGIS 10.1 a new ArcSDE 10.1 Enterprise Geodatabase on SQL Server 2012 with the "create enterprise geodatabase" tool. But i get an error messagge: Unknown errorNo extended error. I look at the sdedc_SQL Server.log:

DB_instance_open() db_connect error: -1 CAN'T OPEN INSTANCE: sde:sqlserver. Spatial Engine Connection Failed (-51). Cannot Get Access to Instance sde:sqlserver

share|improve this question
    
Do you have the Database permissions to create Enterprise Geodatabase on SQL Server 2012 ? –  Sunil Aug 9 '13 at 8:13
    
    
Yes i have the permisson to create the database. –  Sebastian Aug 9 '13 at 8:17
    
When using the create enterprise geodatabase tool, are you specifying the server name, or are you using the 10.0 direct connect syntax (sde:sqlserver:servername)? You should only be specifying the server name. –  travis Aug 10 '13 at 8:09
add comment

1 Answer

SQL-Server 2012 support was introduced at ArcGIS 10.1 SP1. You must also have the required SQL-Server 2012 client library install (and its dependent .Net Framework 4.x components) on the ArcGIS 10.1 SP1 client.

Discussion on the "need to install ArcSDE" is more of a philosophical issue (vice technical), but you can read more about it in the Esri Forums.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.