It was already installed so I'm not sure. How do I find that information? There's nothing to indicate it as 64-bit in the Programs and Features list in Control Panel. I am able to access another server running ArcGIS Server 10.1 without an issue, so I assume that the Microsoft SQL Server 2008 Native Client I have on my desktop is compatible with ArcGIS Desktop. That could be a faulty assumption.
Just want to confirm that this solution is what worked for us. We had our IT turn off the firewall on the server that is hosting our new SQL instance, and vi-oh-lay, the tool ran just fine. We narrowed it down to this as the probable source of the error by attempting to connect to the new SQL instance using Management Studio on a local machine (i.e. not on/within the server itself), and the attempt failed, so that more or less confirmed that "access" to the server was limited. Anyhow, thanks for the tip to help us narrow it down!
ArcGIS Server 10.1 is a 64-bit app -- It requires the 64-bit Native client. The fact that
your old server (where the 32-bit client had been installed for 32-bit AGS 10.0) works
indicates that a missing 32-bit native client could be the issue.
- V