Just upgraded to 2.0. When I try to sync to my newly created local offline databases I get the following error:
Run-time error - 2147217900 (80040e14) SQL server blocked access to STATEMENT "open Rowset/Open Satasource" of component 'Ad Hoc Distributed Queries' because this component is turned off as part of the security configuration for this server. A system administrator can enable the use of 'Ad Hoc Distributed Queries' by using sp_configure. For more information about enabling 'Ad Hoc Distributed Queries' , see "Surface Are Configuration" in SQL Server Books Online.
Can someone walk me through this?