Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
viperbyte
Posting Yak Master
132 Posts |
 Posted - 2013-12-11 : 10:42:33
|
| Good morning everybody,I'm following along on a tutorial on creating a 2012 ssrs report and am now at the publishing part of the tutorial.I don't know what value to provide for TargetServerURL. For now I just want to get this report to work from my local instance. The instructions that are giving me a hard time are these.:1.An optional step is to publish the completed report to the native mode report server so you can view the report from Report Manager.2.On the toolbar click Project and then click tutorial Properties...3.In the TargetServerURL type the name of the name of your report server, for example http://<servername>/reportserver4.Click OK5.On the toolbar click Build and then click Deploy tutorial.What do I put for servername and reportserver?My instance name is SATURN\SQLEXPRESSIn the list of databases I have the following:ReportServer$SQLExpressReportServer$SQLExpressTempDBI would really appreciate some help. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-12-11 : 12:33:24
|
| 1. Your local instance will have a report server (if configured). Go to start-> programs -> sql server -> configuration tools -> report server configuration manager. it will show the report server url if configured. If not configured configure it to create virtual directory and url. Give the value to TargetServerURL property of your project and then depploy your reports. the reports along with datasources,datasets etc will get deployed to the server which can be accessed from link shown in config manager.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
 |
|
|
viperbyte
Posting Yak Master
132 Posts |
Posted - 2013-12-11 : 14:15:38
|
| Thanks Visa that helped. I see now that it's supposed to be http://saturn/reportserver_sqlexpress. So now I get a little further along when clicking "deploy <project>". Now I have a new snag. A permission problem. I really have tried to solve this myself but am stuck again. Anyone have any pointers on how to handle my new error message of:Error 1 The permissions granted to user 'saturn\michael' are insufficient for performing this operation. 0 0 Saturn\Michael is my computer name Saturn and whatever Michael is, I suppose login ID? |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-12-12 : 11:06:28
|
| yep...which role this user is mapped to in your sqlserver insatnce?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
|
|
|
|
|
|
How to Publish Report