×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

project settings in SSRS deployment

project settings in SSRS deployment

project settings in SSRS deployment

(OP)
What are the project settings in SSRS deployment and what do they mean and refer to?

I have successfully created my first SSRS project in Visual Studio. The deployment process requires setting up the TargetServerURL and the TargetServer Version. These are the only two items that I know are correct. The tutorial I have been watching does not go into the other items and does not clarify what they are and what they are used for. What are the following items referring to?

•TargetDatasetFolder
•TargetDataSourceFolder
•TargetReportFolder
•TargetReportPartFolder

The default settings for OverwriteDatasets and OverwriteDataSources was False and this is probably why my deployment attempt threw a nondescript error. So, now, perhaps if I try again, my deployment will create these folders on the server by force, but I would rather not do this because the database manager has already given me the names of the folders where I should deploy. So, how are these Folders arranged? Please advise.

https://i.stack.imgur.com/5CiJO.png
https://www.sqlservercentral.com/Forums/Uploads/Im...

When I try to do a build, the output window says:

CODE -->

------ Build started: Project: Rules Report Project, Configuration: Debug ------
Skipping 'DefaultReport.rdl'. Item is up to date.
Build complete -- 0 errors, 0 warnings
------ Deploy started: Project: Rules Report Project, Configuration: Debug ------
{deploy to server message redacted}
Deploying report '/Rules Report Project/DefaultReport'.
Error rsInternalError : An unexpected error occurred in Report Processing.
Deploy complete -- 1 errors, 0 warnings
========== Build: 1 succeeded or up-to-date, 0 failed, 0 skipped ==========
========== Deploy: 0 succeeded, 1 failed, 0 skipped ========== 

"Rules Report Project" is listed as being default value for TargetReportFolder in the project settings. So, now I try assigning this value the value of a directory I know exists for me on the server. When I do this, I have a different error message. This time, when I do a deploy, I get a different message in the output window:

CODE -->

------ Build started: Project: Rules Report Project, Configuration: Debug ------
Skipping 'DefaultReport.rdl'. Item is up to date.
Build complete -- 0 errors, 0 warnings
------ Deploy started: Project: Rules Report Project, Configuration: Debug ------
{deploy to server message redacted}
Deploying report '/{Folder Name}/DefaultReport'.
Error rsAccessDenied : The permissions granted to user '{somethin'}\{my username}' are insufficient for performing this operation.
Deploy complete -- 1 errors, 0 warnings
========== Build: 1 succeeded or up-to-date, 0 failed, 0 skipped ==========
========== Deploy: 0 succeeded, 1 failed, 0 skipped ========== 

So I have one of two options:
  1. Either I need to be granted read/write permissions to the sever or
  2. I need to know the location of the other folders and I need to have them named
Please advise.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close