In SQL 2008 / SQL 2008 R2 - You need to enable the Adhoc Query Option as follows.
- Open Server Management Studio for SQL 2008 R 2 Edition
- Open Management-> Policy Management -> Facets ->
- Double clik on Surface Ara Configuration
- Change the status of AdHoc Remote Queries to enabled (TRUE).
This will solve the problem of fetching Point of Sale articles into in Speed Net module through network.
Download the Solution Document and Scripts in the below link
- Please download the attachment.
- Unzip the file and follow the guidelines based on the SQL version being used at your office.
Updates:
Follow us on WhatsApp, Telegram Channel, Twitter and Facebook for all latest updates
Post a Comment