April 13, 2009 at 7:15 pm
Hello,
I'm having some very frustrating issues getting my stored procs to run in SSRS. Here are two two different errors that I'm getting. The first error is when I try to execute a simple stored proc that queries a table on a linked server. The sproc works great in query analyzer, but when I try to create a report in SSRS it throws this error...
An error occurred while executing the query.
Ad hoc access to OLE DB provider 'MSDASQL' has been denied. You must access this provider through a linked server. (Microsoft SQL Server, Error: 7415)
The error is generated when I try to use OPENQUERY() to yet another linked server...
An error occurred while executing the query.
Cannot initialize the data source object of OLE DB provider "MSDASQL" for linked server "BIDDY". (Microsoft SQL Server, Error: 7303)
These errors only happen in SSRS. When accessing the linked servers with ad-hoc queries from query analyzer, we see no strange behavior.
Please Help...
April 21, 2009 at 2:30 pm
You are using MSDASQL which is Microsoft OLE DB Provider for ODBC. Are you accessing a linked server. Have you set up the linked server correctly. Have you tested whether you can run the openquery() in the SQ Server Management Studio.
I have a chapter which deals with all kinds of reports including linked reports. May be you should check it out.
You may down-load a free chapter.
April 22, 2009 at 6:28 am
Sounds like you need to get Kerberos setup for the double-hop. Check out this article[/url] by K. Brian Kelley. Here is a good blog post by Kendal Van Dyke about it as well.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply