How to deploy SQL Reporting 2005 when Data Sources are locked?
Posted
by spoulson
on Stack Overflow
See other posts from Stack Overflow
or by spoulson
Published on 2008-09-17T15:36:44Z
Indexed on
2010/03/23
17:53 UTC
Read the original article
Hit count: 338
The DBAs here maintain all SQL Server and SQL Reporting servers. I have a custom developed SQL Reporting 2005 project in Visual Studio that runs fine on my local SQL Database and Reporting instances. I need to deploy to a production server, so I had a folder created on a SQL Reporting 2005 server with permissions to upload files. Normally, a deploy from within Visual Studio is all that is needed to upload the report files.
However, for security purposes, data sources are maintained explicitly by DBAs and stored in a separated locked down common folder on the reporting server. I had them create the data source for me.
When I attempt to deploy from VS, it gives me the error "The item '/Data Sources' already exists." I get this whether I'm deploying the whole project or just a single report file. I already set OverwriteDataSources=false in the project properties. The TargetServer URL and folder are verified correct.
I suppose I could copy the files manually, but I'd like to be able to deploy from within VS. What could I be doing wrong?
© Stack Overflow or respective owner