I installed sql express with advanced services on a local network computer named 'Tester'. For service accounts I used 'network service' and 'mixed mode' for authentication. I would like to publish database reports using reporting services. when i open a web browser on the machine with sql express and type in the url: http://localhost/reports or http://localhost/reportserver the web pages work fine. but when i go to a different machine thats on the same network and use the url: http://Tester/reports or http://Tester/reportserver the web page is not found. how do i get users on the network to be able to view the virtual report server directories on the Tester computer? Help would be greatly appreciated.
Hi,
did you check your IIS configuration of your localhost (Tester)?
Is there an alias for your network computer - "Tester", DNS?
Have you put in a Hostheadername by IP?
What about a ping`?
Have you test http://172.../reports ?
CU
tosc
|||i can ping 'Tester' fine, i've tried http://<ip of host>/reports. IIS is configured for integrated windows autentication. I tried setting authentication to allow anonymous access but that didnt work either.|||Hi John,
by installation, have you check "Use SSL..." checkbox in the installation wizard?
CU
tosc
|||are you referring to the install of IIS? I dont recall, should I try to reinstall IIS?
Thanks,
John
|||Hi John,
NO, i'm referring to Installing and Configuring SQL Server Reporting Services!
Have yopu check "Use SSL..." checkbox in the installation wizard?
CU
tosc
|||Hi John,
Unless you changed it manually, Reporting Services is given an instance name just like the database service. Try adding "$SQLEXPRESS" (without quotes) to the end of your URL. Needless to say, if you installed to a different instance name, use that inplace of SQLEXPRESS.
Mike
|||I've tried all the url's and none of them work. Does IIS have to be configured in a particular way? also do I need to add permissions to my report server database? I would think that anyone on the intranet who knows the host computer name can put in the url and view the reportserver web page. Im not getting prompted for a login, my web browser just says the page cannot be displayed, that makes me think that it is network problem and not a configuration problem on the local machine.|||I have had similar troubles. I have a report server configured on a computer on the network. I've installed SQL Express 2005 and the toolkits to get hold of RS. The computer is running IIS 5 and is connected using MMC. Reports can be generated, deployed, and viewed using a browser and URL from this machine quite happily.
However, when I try to access the report server from a different computer on the network I also get a
Internet Explorer cannot display the webpage
message.
I have tried:
http://rs_name/reports
http://rs_name.network.local/reports
http://rs_name/reports$sqlexpress
I can ping the machines from eachother successfully and I have made profiles from within Report Manager for each user on these machines. Is this a Express thing? SURELY, you must be able to access these reports across a Windows network.
Many thanks.
Leslie
|||You sould ask this question in the Report Services forum to get a better answer. (http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=82&SiteID=1)
Mike
|||OK. I'll ask them over there. Thank you very much, and apoligies for being in the wrong place.
L
