Tuesday, November 27, 2012 6:17 AM
while am to test the connection of my package, getting an error message:
The connection Failed bacuase of an error in initializing folder. the following system error occured:
The requested name is valid, but no data of requested type was found.
please help me in this..
Thanks in advance.
Tuesday, November 27, 2012 6:53 AMIs it SSRS report? How do you test the connection? Have you done deploy?
Best Regards,Uri Dimant SQL Server MVP, http://sqlblog.com/blogs/uri_dimant/
MS SQL optimization: MS SQL Development and Optimization
MS SQL Blog: Large scale of database and data cleansing
MS SQL Consultants: Improves MS SQL Database Performance
Tuesday, November 27, 2012 6:55 AM
few more details on this:
provider: Microsoft OLEDB Provider for Analysis services 10.0
DB : DPSR_KK
--- use Windows NT Integrated Security
Tuesday, November 27, 2012 9:27 AM
yes it is ssrs report ,
when i clicked on test connection it is showing the error message.
please suggest something on this
thanks for the reply
Thursday, November 29, 2012 2:05 AMModerator
Which data source type are you using when creating the data source by using SSIS package in the Report Designer? By default, the SSIS data processing extension is disabled. To enable it in Report Designer, we need to modify the RSReportDesigner.config file. For the detailed steps, please see the following MSDN article:
Configuring Reporting Services to Use SSIS Package Data
After that, please also pay attention to the following precautions before creating the SSIS data source:
- Make sure the content of the package is controlled (for example, you can use the password protection features in SSIS or set permissions on the file).
- Grant the SSRS service accounts permission to read the data and perform any operation that you define in the package.
Hope this helps.
TechNet Community Support
- Marked As Answer by Mike YinMicrosoft Contingent Staff, Moderator Sunday, December 02, 2012 5:50 PM