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

Related posts about sql-server

Related posts about visual-studio