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

[BobBell]

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!!

Cheers,

Bob

[MikeCusi]

Hi,

Have you tried making a connection file using the tools,

or via

[BobBell]

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

[George_Thompson]

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

[AsrujitSengupta]

What error do you observe while connecting to the database?

Did you rename the database while restoring on your Instance?

[DebbieBull]

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.
https://desktop.arcgis.com/en/arcmap/10.4/manage-data/gdbs-in-sql-server/logfiles-sqlserver.htm