topic Re: Connecting to a Standby/Read-Only SQL/SDE Database in Geodatabase Questions https://community.esri.com/t5/geodatabase-questions/connecting-to-a-standby-read-only-sql-sde-database/m-p/1074365#M7248 <P>How are your log file parameters defined?&nbsp; Some configurations create tables in the Geodatabase itself (needing write access there), some write to tempdb&lt;--this is the recommendation and the default for SQL Server.<BR /><A href="https://desktop.arcgis.com/en/arcmap/10.4/manage-data/gdbs-in-sql-server/logfiles-sqlserver.htm" target="_blank">https://desktop.arcgis.com/en/arcmap/10.4/manage-data/gdbs-in-sql-server/logfiles-sqlserver.htm</A></P> Wed, 30 Jun 2021 18:42:23 GMT DebbieBull 2021-06-30T18:42:23Z Connecting to a Standby/Read-Only SQL/SDE Database https://community.esri.com/t5/geodatabase-questions/connecting-to-a-standby-read-only-sql-sde-database/m-p/869992#M6209 <HTML><HEAD></HEAD><BODY><P>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!!</P><P></P><P>Cheers,</P><P></P><P>Bob</P></BODY></HTML> Wed, 06 Jan 2016 02:10:45 GMT https://community.esri.com/t5/geodatabase-questions/connecting-to-a-standby-read-only-sql-sde-database/m-p/869992#M6209 BobBell 2016-01-06T02:10:45Z Re: Connecting to a Standby/Read-Only SQL/SDE Database https://community.esri.com/t5/geodatabase-questions/connecting-to-a-standby-read-only-sql-sde-database/m-p/869993#M6210 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Have you tried making a connection file using the tools,</P><P><IMG class="image-1 jive-image" src="https://community.esri.com/legacyfs/online/165127_pastedImage_0.png" style="max-width: 1200px; max-height: 900px;" /></P><P></P><P>or via </P><P><IMG class="image-2 jive-image" src="https://community.esri.com/legacyfs/online/165128_pastedImage_2.png" style="max-width: 1200px; max-height: 900px;" /></P></BODY></HTML> Wed, 06 Jan 2016 02:49:57 GMT https://community.esri.com/t5/geodatabase-questions/connecting-to-a-standby-read-only-sql-sde-database/m-p/869993#M6210 MikeCusi 2016-01-06T02:49:57Z Re: Connecting to a Standby/Read-Only SQL/SDE Database https://community.esri.com/t5/geodatabase-questions/connecting-to-a-standby-read-only-sql-sde-database/m-p/869994#M6211 <HTML><HEAD></HEAD><BODY><P>Absolutely. Connecting to any other database (including the source for this read only copy) works fine.</P></BODY></HTML> Wed, 06 Jan 2016 04:51:02 GMT https://community.esri.com/t5/geodatabase-questions/connecting-to-a-standby-read-only-sql-sde-database/m-p/869994#M6211 BobBell 2016-01-06T04:51:02Z Re: Connecting to a Standby/Read-Only SQL/SDE Database https://community.esri.com/t5/geodatabase-questions/connecting-to-a-standby-read-only-sql-sde-database/m-p/869995#M6212 <HTML><HEAD></HEAD><BODY><P>Hi Bob,</P><P></P><P>I assume that you are using SQL Server for the RDBMS. It looks like it may be possible using the following documentation:</P><P></P><P><A href="http://desktop.arcgis.com/en/desktop/latest/manage-data/gdbs-in-sql-server/connections-highly-available-sqlserver.htm" title="http://desktop.arcgis.com/en/desktop/latest/manage-data/gdbs-in-sql-server/connections-highly-available-sqlserver.htm">Connections to highly available SQL Server databases—Help | ArcGIS for Desktop</A> . </P><P></P><P>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: <A href="http://desktop.arcgis.com/en/desktop/latest/manage-data/gdbs-in-oracle/connect-oracle-read-only.htm" title="http://desktop.arcgis.com/en/desktop/latest/manage-data/gdbs-in-oracle/connect-oracle-read-only.htm">Connections to read-only Oracle databases—Help | ArcGIS for Desktop</A> </P><P></P><P>-George</P></BODY></HTML> Wed, 06 Jan 2016 12:36:01 GMT https://community.esri.com/t5/geodatabase-questions/connecting-to-a-standby-read-only-sql-sde-database/m-p/869995#M6212 George_Thompson 2016-01-06T12:36:01Z Re: Connecting to a Standby/Read-Only SQL/SDE Database https://community.esri.com/t5/geodatabase-questions/connecting-to-a-standby-read-only-sql-sde-database/m-p/869996#M6213 <HTML><HEAD></HEAD><BODY><P>What error do you observe while connecting to the database?</P><P>Did you rename the database while restoring on your Instance?</P></BODY></HTML> Wed, 06 Jan 2016 14:40:29 GMT https://community.esri.com/t5/geodatabase-questions/connecting-to-a-standby-read-only-sql-sde-database/m-p/869996#M6213 AsrujitSengupta 2016-01-06T14:40:29Z Re: Connecting to a Standby/Read-Only SQL/SDE Database https://community.esri.com/t5/geodatabase-questions/connecting-to-a-standby-read-only-sql-sde-database/m-p/1074365#M7248 <P>How are your log file parameters defined?&nbsp; Some configurations create tables in the Geodatabase itself (needing write access there), some write to tempdb&lt;--this is the recommendation and the default for SQL Server.<BR /><A href="https://desktop.arcgis.com/en/arcmap/10.4/manage-data/gdbs-in-sql-server/logfiles-sqlserver.htm" target="_blank">https://desktop.arcgis.com/en/arcmap/10.4/manage-data/gdbs-in-sql-server/logfiles-sqlserver.htm</A></P> Wed, 30 Jun 2021 18:42:23 GMT https://community.esri.com/t5/geodatabase-questions/connecting-to-a-standby-read-only-sql-sde-database/m-p/1074365#M7248 DebbieBull 2021-06-30T18:42:23Z