Connecting to a Standby/Read-Only SQL/SDE Database

01-05-2016 06:10 PM
New Contributor

Hi All, I'm trying to connect to a SQL/SDE database. This database is a log shipped copy of our production data used for reporting purposes. I can connect to this database via a variety of mechanisms - management studio, excel, reporting services etc. but not through Arc. I have tried using the APPLICATIONINTENT setting but I don't think that is for this purpose. Does anyone have any ideas why I am unable to connect? In running profiler I can see connecting tries to execute some stored procedures and create some temp tables under the SDE application. Perhaps this is the cause and I simply can't connect to a read-only DB? Any ideas would be greatly appreciated!!



0 Kudos
5 Replies
Occasional Contributor II


Have you tried making a connection file using the tools,

or via

New Contributor

Absolutely. Connecting to any other database (including the source for this read only copy) works fine.

0 Kudos
Esri Frequent Contributor

Hi Bob,

I assume that you are using SQL Server for the RDBMS. It looks like it may be possible using the following documentation:

Connections to highly available SQL Server databases—Help | ArcGIS for Desktop .

But it looks like it may not be possible in SQL Server yet to just connect a read-only geodatabase. I know that it is possible to connect to a read-only in Oracle: Connections to read-only Oracle databases—Help | ArcGIS for Desktop


--- George T.
Regular Contributor III

What error do you observe while connecting to the database?

Did you rename the database while restoring on your Instance?

New Contributor II

How are your log file parameters defined?  Some configurations create tables in the Geodatabase itself (needing write access there), some write to tempdb<--this is the recommendation and the default for SQL Server.

0 Kudos