When deploying report from BIDS to a non local Report Manager get message: “The specified report server URL http://xxxxxxxx/Reports_xxxxxxxx could not be found. Verify the syntax of the URL and that the report server exists.” Not sure if its relevant but, on the test machine I am attempting to deploy to, the sql server installation was to a named instance. I can copy and paste the URL from the error message into Internet Explorer, access this server’s Report Manager and upload the report files from within the Report Manager. I can also deploy from BIDS successfully if I run SQL Server and Reporting Services on my local pc (default instance) and deploy to that. I need to get deployment from BIDS working to machines other than my local pc and would be very grateful if you can point me in the right direction. Thanks Breadon

Are you sure it's the right URL? Do you get the GUI for reporting services or the file listing? Default Target Server URL is http://servername/ReportServer , not http://servername/Reports

Go to the SQL Server Reporting Services Configuration Manager, log on to the RS instance and look for the Report Manager URL. Try clicking on the URL in this dialog. Use this as a template. hth__________________________________________________________________ William Vaughn Author, Mentor, Trainer, MVP Beta V Corporation William Vaughn's blog Hitchhikers Guide to Visual Studio and SQL Server (7th Edition) The Owl Wrangler a fantasy fiction novel Please click the Mark as Answer button if a post solves your problem!

Thnks guys but I have tried these approaches. Never had to deal with a named instance before so I originally sourced the url from Reporting Services Configuration Manager, URL tab. Have just been back and doubled checked it. Plus I used Ctrl-C to copy the error message in the BIDS pop up dialog box, pasted it in to Notepad, then copied the url bit and pasted it in to Internet Explorer. Able to access Report Manager just fine. There is a difference in case. For some reason, Reporting Services Configuration Manager shows the first part of the url (the actual server name) in upper case. However, in BIDS project configuration properties, BIDS insists on downshifting this server name. The virtual directory name on the end is NOT downshifted. The SQL Server collation is case insensitive, namely SQL_Latin1_General_CP1_CI_AS. That said, I thought urls were case insensitive anyway?? I am a bit suspicious of the service account. Its not NETWORK SERVICE but a domain user account that I was surprised to see used for this purpose. I would try changing it to NETWORK SERVICE but I don't know the password to put it back afterwards. Guess I can reset it BUT am afraid of more problems.... Any other suggestions? Thanks Breadon

Ah, I NEVER install SQL Server with case-sensitivity enabled as it causes all kinds of grief. Since all of the more recent versions let you do case-sensitive searches on demand, there is no real need for it IMHO. I would change the colllation to the default. I use a Domain user account as well--one specifically setup for this purpose but you'll need to know the PW to go back there.__________________________________________________________________ William Vaughn Author, Mentor, Trainer, MVP Beta V Corporation William Vaughn's blog Hitchhikers Guide to Visual Studio and SQL Server (7th Edition) The Owl Wrangler a fantasy fiction novel Please click the Mark as Answer button if a post solves your problem!

If you are copying the URL into IE and its taking you to Report Manager, then you are using the wrong URL, and needs to be the Report Server web service URL Right click the report project and select Properties, in the General page, make sure the TargetServerURL value is the string of report server instead of report manager, for example, http://PCName/ReportServer. You can get it from Web Service URL page of Reporting Services Configuration Manager tool.

Thanks Clare. From the 'Reporting Services Configuration Manager' I had taken the Report Manager URL rather than the Web Service URL. All working now. Many thanks to everyone who contributed. Breadon