AnsweredAssumed Answered

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

Question asked by bob.bell on Jan 5, 2016
Latest reply on Jan 6, 2016 by asengupta-esristaff

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

Outcomes