I'm just learning sql express and I'm trying to get my reporting
services worked out. I have everything installed and I have managed to
connect to the report server at http://<computername>/Reports
my problem is I can only connect to this page when I am at the machine
where the sql database, reporting database, etc... I cannot log on to
this site from any other computer no my network? Does any one know why
?
I have also tried installing on a different machine and I get an error "Server Error in /ReportServer application..... failed to access IIS metabase.
IIS is installed on this machine.
Thanks!!!
As long as you are inserting the correct computer name in your URL string, I don't see why it shouldn't connect. Obviously you wouldn't want to use http://localhost/Reports to connect from a client machine. Are both the server and client under the same domain?
What happens when you try http://<computername>/reportserver ?
|||I've tried using the computer name when trying to connect from a client machine and I get the same result. Both machines are on the same domain but using different user accounts. Would that matter?|||Jamaz wrote:
I've tried using the computer name when trying to connect from a client machine and I get the same result. Both machines are on the same domain but using different user accounts. Would that matter?
No that wouldn't matter.
What happens when you try http://<computername>/reportserver from a client machine where computername is the name of the computer with SQL server?
|||Jamaz wrote: I've tried using the computer name when trying to connect from a client machine and I get the same result. Both machines are on the same domain but using different user accounts. Would that matter?
No that wouldn't matter.
What happens when you try http://<computername>/reportserver from a client machine where computername is the name of the computer with SQL server?
That's the only way I had tried it. Should I be making computer name the name of the computer I happen to be on ? I didn't think that was the way it worked ?|||No, it should be the name of the computer on which SQL server resides. What is the error message you are getting?|||
Server Error in '/Reports' Application.
Failed to access IIS metabase.
I uninstalled SQL on the first machine i was trying it on ... and have now installed SQL on a new machine and I have run through the set up the same way I did before and I am getting this error now. I get this error when trying to connect from the server machine .. and when I try to connect from a client machine I get a page not found error in the browser
|||
Oh I see. I thought it was working on the server.
Check this forum: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=116989&SiteID=1
