PowerShell™ for SharePoint® 2013 How-To

Allow or Restrict Nonremotable Queries

Scenario/Problem: You need to allow or restrict the use of non-remotable queries.

Solution: Use the NonRemotableQueriesAllowed switch parameter with the Set-SPAccessServiceApplication cmdlet.

Nonremotable queries are queries that cannot be remotely executed within the database. By default, the Access Services service application is configured to allow nonremotable queries. Because NonRemotableQueriesAllowed is a switch parameter, you can use it with a $false setting to disable nonremotable queries, as shown in Listing 23.11.

Listing 23.11. Disabling Nonremotable Queries

Set-SPAccessServiceApplication -Identity "Access Services"-NonRemotableQueriesAllowed:$false

You can use -NonRemotableQueriesAllowed ...