Solved

Report Manager on my laptop

Posted on 2014-09-16
6
201 Views
Last Modified: 2014-09-17
I am practicing SQL server reporting services.  I want to be able to deploy the report somewhere so that I can practice using the Report Manager.  What do i enter for Report URL?
0
Comment
Question by:vbnetcoder
  • 4
  • 2
6 Comments
 
LVL 22

Accepted Solution

by:
Nico Bontenbal earned 500 total points
Comment Utility
Do have SQL Server with SSRS installed on this machine also? And you want to know what to enter as the TargetServerURL in the project properties of the Report Project? Then the answer is:
http://localhost/ReportServer
or
http://localhost/ReportServer_<instance>
depending on how you installed SQL Server. You can test those URL's in the browser if you get some results that's probably the right one.
You can also start the "Reporting Services Configuration Manager" and navigate to the "Web Service URL" section on the left. I will show you the 'Report Server Web Service URL" on the detail screen.
At least that's how it works with SQL Server 2008 R2, it might be slightly different with newer versions.
0
 

Author Comment

by:vbnetcoder
Comment Utility
I got the following error when i navigated to the URL

The permissions granted to user 'JohnPC\John' are insufficient for performing this operation. (rsAccessDenied)
0
 
LVL 22

Expert Comment

by:Nico Bontenbal
Comment Utility
Oh, I think I remember that's a well known problem with Windows 7 and SSRS. I think you can solve this by running IE as Administrator. Or if John is not an administrator on the machine, first try to log on as an Administrator.
See also:
http://msdn.microsoft.com/en-us/library/aa337279(v=sql.110).aspx
http://msdn.microsoft.com/en-us/library/bb630430.aspx
for example.
0
How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

 

Author Comment

by:vbnetcoder
Comment Utility
Thanks! That worked,

Now, in BIDS what do I use for TargetServerURL in bids? When i try to deploy it tells me that the URL can not be found
0
 

Author Comment

by:vbnetcoder
Comment Utility
Never mind i got it! Thanks for your help!
0
 

Author Closing Comment

by:vbnetcoder
Comment Utility
Thanks so much for you help!
0

Featured Post

Maximize Your Threat Intelligence Reporting

Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

Join & Write a Comment

Time Corrections for Reports Working with a report, we made some interesting discoveries about the time corrections/updates We are using the following Parameters: Starting Entered Date (Date) formatted as Data type: "Date/Time" Ending Entered …
It is helpful to note: This is a cosmetic update and is not required, but should help your reports look better for your boss.  This issue has manifested itself in SSRS version 3.0 is where I have seen this behavior in.  And this behavior is only see…
This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're looking for how to monitor bandwidth using netflow or packet s…
In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're interested in additional methods for monitoring bandwidt…

763 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now