Saturday, July 26, 2014

Point of Sale Article not fetched in Speed Net

       Speed Post Articles were booked in Point of Sale does not fetched in Speed Net Module, after Configure DOP Server.

Solution

Solution 1 : POS booked articles not fetching in speed net module after changing the server name or formatting the server
Run these two queries in SQL query analyzer one by one
sp_configure 'show advanced options',1
go
reconfigure
sp_configure 'Ad Hoc Distributed Queries',1
go
reconfigure

Solution 2 : 

Right click on server name in SQL management studio->facets-> surface area configuration.
Set true to Ad hoc remote queries.

No comments:

Post a Comment