question

Vishal avatar image
Vishal asked

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.
sql-server-2005sqlreport
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

· Write an Answer
Fatherjack avatar image
Fatherjack answered
I covered something very similar to this in a blog post a while back, the details are here : http://www.simple-talk.com/community/blogs/jonathanallen/archive/2011/01/24/99007.aspx.
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.