Wednesday, March 21, 2012

Error when deploying Report Model

I installed SQL Server 2005 on my laptop, this also contains my SQL Server 2000, so I couldnt use localhost and I used CreweAlex/SQLSERVER2005 as the hostname.

What do I need to fill in the field:

TargetServerURL

Because when I type http:\\localhost\ReportServer it doesn't work (as mentioned in the tutorial which I am following), also CreweAlex/SQLSERVER2005/ReportServer doesnt work.

I tried all kinds of combinations, but nothing works.

Everything is installed on my laptop, also the Reporting Server.

Try http://crewealex/reportserver$sqlserver2005|||

Thanks for the quick respons, but I still get an error:

Connection could not be made to the report server

The attempt to connect to the report server failed. Check your connection information and that the report server is a compatible version. (Microsoft.ReportingServices.SemanticQueryDesign)

|||

When I type http://crewealex/reportserver in my browser then I can see that I log in into my Report Server, because this is the message that I get:

Microsoft SQL Server Reporting Services Version 9.00.1399.00

I typed http://crewealex/reportserver in my TargetServerURL and this works now. But my instance name is SQLSERVER2005. > Problem solved.

No comments:

Post a Comment