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.

 All Forums
 SQL Server 2008 Forums
 Analysis Server and Reporting Services (2008)
 Troubleshooting Deploying Reports in VS 2008

Author  Topic 

LEOx037
Starting Member

12 Posts

Posted - 2012-09-07 : 09:15:16
I am having issues deploying my Reports in Visual Studio 2008. I can open the Report Manager on the web browser but I cannot deploy the Report. My URL: http://MySeverName/Reports_DSIM01/

I added the following TargetServerURL in the Visual Studio: http://MySeverName/Reports_DSIM01/ReportServer but I get the following error when I try to deploy the Report

Popup notice:

Microsoft SQL Server Report Designer

The specified report server URL
http://MySeverName/Reports_DSIM01/ReportServer could not be
found. Verify the syntax of the URL and that the report server
exists.

sunitabeck
Master Smack Fu Yak Hacker

5155 Posts

Posted - 2012-09-07 : 09:43:08
First, verify that the virtual directory for the report server is indeed http://MySeverName/Reports_DSIM01/ReportServer. You can do this by using the Report Services Configuration Manager (under configuration tools in the SQL Server program group) and looking in the Web SErvice URL tab. It should say Reports_DSIM01/ReportServer for the Virtual directory. If it is something else, change your URL accordingly.

Second, although it covers only the basics, this youtube video is pretty good: http://www.youtube.com/watch?v=DfLnnB7fAuk
My experience is that more often than not, I make mistakes in the basics
Go to Top of Page

LEOx037
Starting Member

12 Posts

Posted - 2012-09-07 : 10:06:39
Thank you sunitabeck! You got me one step closer. The Virtual directory was named something else. I fix my url and tried to redeploy but now I am getting a log in prompt. Interesting. I am logged into the server with an admin account, I tried to use that user account/password but it failed. How or where do I resolve that?

Again, thanks for the information.
Go to Top of Page

LEOx037
Starting Member

12 Posts

Posted - 2012-09-07 : 10:32:58
Disregard the last posting. I found the issue which prompted the log in box. (TargetServerURL should be http://MyServerName/ReportServer_DSIM01/ and not http://MyServerName/Reports_DSIM01/ReportServer in otherwords, dropped "ReportServer") Changing the Virtual directory reference fix the issue. Thanks again sunitabeck!
Go to Top of Page

sunitabeck
Master Smack Fu Yak Hacker

5155 Posts

Posted - 2012-09-07 : 10:39:50
Can you go to the report server (in IE) and under Site Settings (at the top right) in Security tab, make sure that the user/group that you are deploying from is present and has the permissions?
Go to Top of Page
   

- Advertisement -