Accessing ADSI Query from ASP page

Expand Post »

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

Similar Threads

basena

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

4 posts
since Aug 2005

Permalink

Jan 18th, 2006

Re: Accessing ADSI Query from ASP page

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

campkev

Reputation Points: 14

Solved Threads: 19

Posting Pro in Training

Offline

484 posts
since Jul 2005

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in ASP Forum Timeline: login with cookie

Next Thread in ASP Forum Timeline: asp code generated as text, needed to be seen as asp code again. databses backup

DaniWeb Message

Cancel Changes

User Name
Password