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!!
I assume that you are using SQL Server for the RDBMS. It looks like it may be possible using the following documentation:
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