Connection String stored in Datasource table of Report Server
Hi, we are moving all our environments (Databases, DTS or SSIS and Reports built in SQL 2000 and SQL 2005 to SQL 2008. I am working on report parts. I am preparing a list of all the reports which is more than 3000 (used in different applications) and I am stuck to list out which report is connected to which database. I want a complete list of reports in a format: Report Name, Report Path, List of Users Access that report, Database Server, Datasource (DB), Authentication (User ID and Password). I checked Datasource table of Report server and there are fields ConnectionString, UserName and Password but all these fields are of IMAGE type. I tried to findout a way if I can see actual connectionstring, username and password instead of images stored in the database. Can anyone suggest me how it can be done? Is that possible within the database engine or do we need to create some webservice kind of? Please help me to ease my work. That will be a great help. Thanks a lot.