Wednesday, March 21, 2012

Help with reporting services

Ok, here's the deal.

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?

|||

GregSQL wrote:

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

No comments:

Post a Comment