Retrieve data source connection string from reportserver.dbo.DataSource

• Marianne L Collins

  SSCommitted

  Points: 1895

  More actions

  September 2, 2009 at 11:36 am

  #210399

  I would like to retrieve the connection string (and credentials) for each of my data sources (without having to click on each individual item). The DataSource table has a column called ConnectionString, but the data type is image, which cannot be converted to varchar. Does anyone have any ideas of how to pull this information from the database?

  I have tried converting to binary/varbinary, and then converting to varchar, but I get garbage back.

  Thanks,

  Marianne

• andrew.neuman

  SSC Veteran

  Points: 200

  More actions

  May 4, 2010 at 11:06 am

  #1161965

  Did you ever find a solution to this? I'm trying to do the exact same thing.

  Thansk!