Member Avatar for basena

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

  • 2 Contributors
  • 1 Reply
  • 74 Views
  • 17 Hours Discussion Span
  • Latest Post Latest Post by campkev
Member Avatar for campkev

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

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.