I'm on Windows 7 and I have a workspace (FME Desktop 2017.1.0.0, build 17539) that connects to a SQL Server enterprise gdb to export a handful of feature classes to a file gdb. The enterprise gdb is not versioned and is located on a server within my network, though not in my office, and I'm exporting to a file gdb on my machine. It's been working fine up until about a month ago, when I started getting errors.
This is the error I get when running the workspace: "Could not open the Enterprise Geodatabase. The error number from ArcObjects is: '-2147216100'. The error message from ArcObjects is: {FDO error: -2147216100} Please ensure the connection parameters are correct (server=`server_name', instance=`instance_name', user=`username', password=`***', database=`database', version=`SDE.DEFAULT')"
I can use the same parameters and connect to the gdb in ArcCatalog and ArcMap and can view feature classes within it. I've tried using a connection file and also using direct connect with the legacy sde reader and I get this error: "Failed to obtain any schemas from reader 'SDE30' from 1 datasets. This may be due to invalid datasets or format accessibility issues due to licensing, dependencies, or module loading."
Â
I thought the gdb password might have expired, so I had it reset, but that didn't help. My co-worker can use the same parameters and connect to the gdb in FME (he's using Desktop 2017.1.2.1, build 17725).
The only thing I can think of, is that right about the time it stopped working, I upgraded from ArcGIS Pro 2.0 to Pro 2.1 (I've also installed the patch so now I'm at 2.1.2). My co-worker has Pro 2.0. Aside from the difference in FME versions, I can't think of anything that would be different between us, and the fact that this workspace was working with my current version of FME and then stopped tells me that it's not FME that's the issue. Would there be any reason that Pro would be messing this up? Any other ideas on what could be wrong?