Hi,

I have registered the Linked server ADSI and I have written a query and i am able to run that query and get the details from query analyzer.But the problem now is if i try to call the same query or written that query in Stored procedure, from ASP program it is throwing an error Remote Access Denied.

FYI...My SQL Server resides on one server and IIS resides on different server.

Can anybody please help me regarding any configuration settings are required in calling the ADSI query from ASP program?

Thanks in advance

Aravind

you probably just need to grant execute privileges on that stored procedure to what user you are using for your connection
should look something like
grant exec on procname to username