•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the ASP section within the Web Development category of DaniWeb, a massive community of 426,916 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 2,325 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our ASP advertiser: Lunarpages ASP Web Hosting
Views: 2200 | Replies: 1
 |
•
•
Join Date: Aug 2005
Posts: 4
Reputation: 
Rep Power: 0
Solved Threads: 0
Newbie Poster
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
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
•
•
Join Date: Jul 2005
Location: Dallas, TX
Posts: 481
Reputation:
Rep Power: 4
Solved Threads: 19
Posting Pro in Training
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
should look something like
grant exec on procname to username
|
•
•
•
•
•
•
•
•
DaniWeb ASP Marketplace
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Linear Mode
- Retriving data from excel sheet into an asp page (ASP)
- problem in javascript coding in asp page (ASP)
- How do i print asp page on client side "only the contents" (ASP)
- ASP Date Help - If Then Else (ASP)
- Retrieving values from pop up and displaying into asp page (ASP)
- How to Create TIME STAMP in ASP page (ASP)
- New ASP page (ASP)
Other Threads in the ASP Forum
- Previous Thread: login with cookie
- Next Thread: asp code generated as text, needed to be seen as asp code again. databses backup
