Troubleshooting Reports in Visual Studio 2008

Question

Troubleshooting Reports in Visual Studio 2008

leosinclair

Old Hand

Points: 368
More actions
September 7, 2012 at 7:04 am

#280832

I'm 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 actually 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.
Could someone give me suggestions on troubleshooting this issue? Thanks in advance.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

AlexSQLForums SSChampion Points: 14277 More actions · Answer 1

leosinclair (9/7/2012)
I'm 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 actually 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.
Could someone give me suggestions on troubleshooting this issue? Thanks in advance.

Try http://MySeverName/ReportServer/Reports_DSIM01

Alex S

HowardW One Orange Chip Points: 29109 More actions · Answer 2

AlexSQLForums (9/7/2012)

leosinclair (9/7/2012)
I'm 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 actually 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.
Could someone give me suggestions on troubleshooting this issue? Thanks in advance.

Try http://MySeverName/ReportServer/Reports_DSIM01%5B/quote%5D

I think that should be http://MySeverName/ReportServer_DSIM01. Report Manager and Report Server are different URL's, but they're both suffixed with the Instance name for the report server (DSIM01 in this case)

leosinclair Old Hand Points: 368 More actions · Answer 3

I would like to thank you for the response.

Here's what I have learned and the answer to my issue:

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.

I was able to determine that the URL in the TargetServerURL didn't match that that was listed in the Report Services Configuration Manager. Once I changed the TargetServerURL to match the URL listed in the Report Services Configuration Manager the problem was fixed and I deploy my reports.

Thanks to everyone for take the time to reading and answering my question.