We currently have multiple SSRS report projects that are able to deploy to our SSRS server using MSBuild. The command we use is:
"C:\Program Files (x86)\Microsoft Visual Studio\2022\BuildTools\MSBuild\Current\Bin\msbuild.exe" myproj.rptproj /t:Deploy /p:configuration=Release /p:OverwriteDatasets=False /p:OverwriteDataSources=False /p:TargetDataSourceFolder="Data Sources" /p:TargetReportFolder="Reports" /p:TargetServerURL="http://xxxx.xxxx.com/reportserver"
We are working on building a new CI/CD system and this new environment is not on our domain. When attempting to call the previous command from this environment, we are getting the error "Could not connect to the report server http://xxxx.xxxx.com/reportserver. Verify that the TargetServerURL is valid and that you have the correct permissions to connect to the report server.". Based on previous research, we attempted to provide credentials using the following command:
cmdkey /add:xxxx.xxxx.com /user:domain\user /pass:password
After providing a valid user in this command, we are still receiving the same error. We checked the SSRS server event viewer, and MSBuild is sending the computer username/password, not the credentials we provided in the cmdkey command.
We also tried providing credentials directly in the msbuild command: /p:username=domain\user /p:password=password
We are able to access the http://xxxx.xxxx.com/reportserver endpoint via a browser from the CI/CD environment VM.
How do we provide domain\user and password to MSBuild to allow us to deploy from this non-domain environment?
Hi @Tim A
Please checking in to see if the below suggestions helped. If this answers your query, do click
Up-Votefor the same. And, if you have any further query do let us know.