tobania / VSTS.Extension.SqlReportingServices

VSTS Extension for uploading SSRS Reports
MIT License
14 stars 20 forks source link

Could not Pass Data Source Credentials? #41

Open RRGGSS opened 6 years ago

RRGGSS commented 6 years ago

Hello Team,

First of all, thank you very much for the extension and appreciate you. We're able to deploy the data source (.rds) and report files (.rdl) to existing folder structure (Can't create a folder using other SQL Server folder structure relese extension).

But in release definition we don't find options to pass the username and password for data source (.rds) Kindly help to set up this in release definition, because we use different user name and password in each environment.

Below are reference screenshots.

  1. Release definition confiuration image

  2. Deployed atrifacts image

Please let us know if I can provide any further details.

Thanks, Sathi Reddy

anton-kirschhock commented 6 years ago

You should be able to add them in the connectionstring

RRGGSS commented 6 years ago

Muziekklas,

I tried different ways to pass the credentials in the connection string. Please give an example which you have tried and worked for you.

anton-kirschhock commented 5 years ago

Something like this should work: Server=myServerAddress;Database=myDataBase;User Id=myUsername; Password=myPassword;