yes, i've already configured distributed ad hoc queries. Like I said before it is working when I run the query on the SQL server through remote desktop connection of the SQL server but it is not working when I run it on my local machine connected to that SQL server in management studio.