connection manager error

Question

Hi All,

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.

Aadhya

Answer 1

Is 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

Answer 2

few more details on this:

provider: Microsoft OLEDB Provider for Analysis services 10.0

servername:  RSB65OLAP

DB        : DPSR_KK

--- use Windows NT Integrated Security

Answer 3

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

Answer 4

Hi Aadhya,

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.

Regards,

---

Mike Yin
TechNet Community Support