Saturday, 16 August 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.
Posted by at

2 comments:

  1. Rupesh Kodwani29 January 2015 at 10:47

    Sir i have tried your solution 1 query but in the 2nd query the following error occurs in SQL 2000 :-

    (Server: Msg 15123, Level 16, State 1, Procedure sp_configure, Line 78
    The configuration option 'Ad Hoc Distributed Queries' does not exist, or it may be an advanced option.

    Valid configuration options are:)

    Sir please provide solution for this...

    ReplyDelete
  2. Unknown17 August 2016 at 08:46

    sir in speed net delivery the following error occur..
    kindly give solution in my e mail id..

    hemanttiwari.dl@gmail.com or in your blog....

    run time error '3704':
    Operation is not allowed when the object is closed



    ReplyDelete

Subscribe to: Post Comments (Atom)