4 days and still can't get my report to depoly (help)...
in [Reports]
|
From: trint on 26 Sep 2007 14:42 On Sep 26, 2:33 pm, "Bruce L-C [MVP]" <bruce_lcNOS...(a)hotmail.com> wrote: > Open up IIS Manager and see if you have the two websites: Reports and > ReportServer. If you do not then something went wrong during your install > and I suggest uninstalling and reinstall RS (not SQL 2005, just Reporting > Services). Make sure that the login you use to the server is a member of the > local administrator group when installing. > > -- > Bruce Loehle-Conger > MVP SQL Server Reporting Services > > "trint" <trinity.sm...(a)gmail.com> wrote in message > > news:1190829660.683856.249390(a)50g2000hsm.googlegroups.com... > > > > > On Sep 26, 1:11 pm, "Bruce L-C [MVP]" <bruce_lcNOS...(a)hotmail.com> > > wrote: > >> That's your problem. Nothing will work without that. Report Manager (the > >> portal that ships with RS) uses web services. You need to get that Green. > >> For ASP.Net Service account I have NT Authority\NetworkService > > >> For the application pools I use ReportServer for both. > > >> -- > >> Bruce Loehle-Conger > >> MVP SQL Server Reporting Services > > >> "trint" <trinity.sm...(a)gmail.com> wrote in message > > >>news:1190824593.744787.46820(a)k79g2000hse.googlegroups.com... > > >> > On Sep 26, 12:16 pm, "Bruce L-C [MVP]" <bruce_lcNOS...(a)hotmail.com> > >> > wrote: > >> >> Run the program files->Microsoft SQL 2005->Configuration Tools -> > >> >> reporting > >> >> services configuration > > >> >> Make sure you have no red X's. > > >> >> -- > >> >> Bruce Loehle-Conger > >> >> MVP SQL Server Reporting Services > > >> >> "trint" <trinity.sm...(a)gmail.com> wrote in message > > >> >>news:1190820960.305074.169310(a)r29g2000hsg.googlegroups.com... > > >> >> > On Sep 25, 10:51 am, "Bruce L-C [MVP]" <bruce_lcNOS...(a)hotmail.com> > >> >> > wrote: > >> >> >> First things first. You need to make sure that you can open up > >> >> >> Report > >> >> >> Manager (that is the portal that ships with RS). Sure, there won't > >> >> >> be > >> >> >> any > >> >> >> reports if none have been deployed but that is fine. It will show > >> >> >> you > >> >> >> that > >> >> >> everything is setup and working and that you have rights. > > >> >> >> It sounds like in your case the easiest thing to do is to first > >> >> >> remote > >> >> >> desktop to the server and then do this: > > >> >> >>http://localhost/Reports/Pages/Folder.aspx > > >> >> >> Do not try anything else until this comes up for you. If you have > >> >> >> been > >> >> >> changing permissions in the database or in IIS after installing RS > >> >> >> then > >> >> >> you > >> >> >> have most likely just messed things up. You should never have to be > >> >> >> doing > >> >> >> either one. Everything from a security perspective can be done > >> >> >> using > >> >> >> Report > >> >> >> Manager. > > >> >> >> If IIS has set the two RS websites to anonymous then this will come > >> >> >> up > >> >> >> but > >> >> >> you will not be able to deploy because with anonymous no-one has > >> >> >> rights > >> >> >> to > >> >> >> deploy. > > >> >> >> RS uses roles. Read up on how roles are used. > > >> >> >> -- > >> >> >> Bruce Loehle-Conger > >> >> >> MVP SQL Server Reporting Services > > >> >> >> "trint" <trinity.sm...(a)gmail.com> wrote in message > > >> >> >>news:1190668106.834755.26140(a)22g2000hsm.googlegroups.com... > > >> >> >> >I have had a great deal of success in the past on other systems > >> >> >> >with > >> >> >> > deploying reports... > >> >> >> > BUT now, to save my life, I haven't been able to get the first > >> >> >> > report > >> >> >> > to deploy. I get these > >> >> >> > errors: > > >> >> >> > A connection could not be made to the report server > >> >> >> > http://###.###.##.###/reportserver. > >> >> >> > Additional information: > >> >> >> > The attempt to connect to the reoprt server failed. Check your > >> >> >> > connection information and that the report server is a compatible > >> >> >> > version. (Microsoft.ReportingServices.Designer) > > >> >> >> > I change the TargetServerURL (after remote desktoping to the > >> >> >> > Report > >> >> >> > Server itself) to: > >> >> >> >http://GCC/ReportServerorhttp://localhost/ReportServerandget > >> >> >> > another type of error: > > >> >> >> > A connection could not be made to the report server > >> >> >> >http://localhost/reportserver > >> >> >> > The request failed with HTTP status 404: Bad Request > >> >> >> > (System.Web.Service) > > >> >> >> > I've tried all the configurations I know and granted all > >> >> >> > permissions > >> >> >> > and turned off the firewall. > >> >> >> > Any help (especially at this point) is very appreciated. > > >> >> >> > Thanks, > >> >> >> >Trint- Hide quoted text - > > >> >> >> - Show quoted text - > > >> >> > Bruce, > >> >> > Something is bad...I get the Reporting Services type screen, you > >> >> > know, > >> >> > it's not the avereage > >> >> > looking html page with the two lines at the top, a big red X in a > >> >> > red > >> >> > circle and the message after the lines: > >> >> > "The request failed with HTTP status 400: Bad Request." > >> >> > and that's all there is on the page. > >> >> > I could get that, unless i used the full ip address of the server > >> >> > it's > >> >> > on, because I would just get the same > >> >> > message on a regular http page using "localhost" or gcc, which is > >> >> > the > >> >> > virtual folder. > >> >> > Thanks for you help! > >> >> > I sure hope I don't have to drive ALL the way over to Virginia > >> >> > (where > >> >> > my server is) and reinstall SQL '05 > >> >> >Trint- Hide quoted text - > > >> >> - Show quoted text - > > >> > Bruce, > >> > I have one red x. It is on "Web Service Identity". > >> > Thanks, > >> >Trint- Hide quoted text - > > >> - Show quoted text - > > > Bruce, > > I did as you said and the (more information on this error) gave me > > this: > > > ReportServicesConfigUI.WMIProvider.WMIProviderException: A virtual > > directory must first be created before performing this operation. > > > at > > ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.SetWebServiceIdentitÂy(String > > applicationPool) > > > Thanks, > >Trint- Hide quoted text - > > - Show quoted text - Bruce, Both of those virtual directories exist. Reports, ReportServer and Reporting Services. They are all under Default Website. Thanks, Trint
From: Bruce L-C [MVP] on 26 Sep 2007 15:55 Trint, you should only have two websites. Did you install more than once? The only suggestion I have on cleaning this up is to Uninstall RS. Then re-install it. Something is definitely wrong with your setup. -- Bruce Loehle-Conger MVP SQL Server Reporting Services "trint" <trinity.smith(a)gmail.com> wrote in message news:1190832145.285348.198540(a)o80g2000hse.googlegroups.com... On Sep 26, 2:33 pm, "Bruce L-C [MVP]" <bruce_lcNOS...(a)hotmail.com> wrote: > Open up IIS Manager and see if you have the two websites: Reports and > ReportServer. If you do not then something went wrong during your install > and I suggest uninstalling and reinstall RS (not SQL 2005, just Reporting > Services). Make sure that the login you use to the server is a member of > the > local administrator group when installing. > > -- > Bruce Loehle-Conger > MVP SQL Server Reporting Services Snip Bruce, Both of those virtual directories exist. Reports, ReportServer and Reporting Services. They are all under Default Website. Thanks, Trint
From: trint on 26 Sep 2007 16:00 On Sep 26, 3:55 pm, "Bruce L-C [MVP]" <bruce_lcNOS...(a)hotmail.com> wrote: > Trint, you should only have two websites. Did you install more than once? > > The only suggestion I have on cleaning this up is to Uninstall RS. Then > re-install it. Something is definitely wrong with your setup. > > -- > Bruce Loehle-Conger > MVP SQL Server Reporting Services > > "trint" <trinity.sm...(a)gmail.com> wrote in message > > news:1190832145.285348.198540(a)o80g2000hse.googlegroups.com... > On Sep 26, 2:33 pm, "Bruce L-C [MVP]" <bruce_lcNOS...(a)hotmail.com> > wrote:> Open up IIS Manager and see if you have the two websites: Reports and > > ReportServer. If you do not then something went wrong during your install > > and I suggest uninstalling and reinstall RS (not SQL 2005, just Reporting > > Services). Make sure that the login you use to the server is a member of > > the > > local administrator group when installing. > > > -- > > Bruce Loehle-Conger > > MVP SQL Server Reporting Services > > Snip > > Bruce, > Both of those virtual directories exist. > Reports, ReportServer and Reporting Services. They are all under > Default Website. > Thanks,Trint I think you are right...Seems like I remember having a problem on the first install. Do I delete one of them? Thanks, Trint
From: trint on 26 Sep 2007 16:21 On Sep 26, 4:00 pm, trint <trinity.sm...(a)gmail.com> wrote: > On Sep 26, 3:55 pm, "Bruce L-C [MVP]" <bruce_lcNOS...(a)hotmail.com> > wrote: > > > > > > >Trint, you should only have two websites. Did you install more than once? > > > The only suggestion I have on cleaning this up is to Uninstall RS. Then > > re-install it. Something is definitely wrong with your setup. > > > -- > > Bruce Loehle-Conger > > MVP SQL Server Reporting Services > > > "trint" <trinity.sm...(a)gmail.com> wrote in message > > >news:1190832145.285348.198540(a)o80g2000hse.googlegroups.com... > > On Sep 26, 2:33 pm, "Bruce L-C [MVP]" <bruce_lcNOS...(a)hotmail.com> > > wrote:> Open up IIS Manager and see if you have the two websites: Reports and > > > ReportServer. If you do not then something went wrong during your install > > > and I suggest uninstalling and reinstall RS (not SQL 2005, just Reporting > > > Services). Make sure that the login you use to the server is a member of > > > the > > > local administrator group when installing. > > > > -- > > > Bruce Loehle-Conger > > > MVP SQL Server Reporting Services > > > Snip > > > Bruce, > > Both of those virtual directories exist. > > Reports, ReportServer and Reporting Services. They are all under > > Default Website. > > Thanks,Trint > > I think you are right...Seems like I remember having a problem on the > first install. > Do I delete one of them? > Thanks,Trint- Hide quoted text - > > - Show quoted text - Bruce, I see why I tried installing it twice... When I click on the "Reporting Services" virtual directory, I see all the needed virtual folders except "Reports". Could I just try to delete the Reporting Services virtual directory and see if that fixes it and leave the ones alone that are directly under default websites? Thanks, Trint
From: Bruce L-C [MVP] on 26 Sep 2007 16:49
I don't know if the reporting services configuration tool will allow you to pick the correct virtual directory or not. See if it allows you to pick. If it is just showing it and not allowing you to pick then it is reading registry values or database values from somewhere and an unistall reinstall would be best. If you unistall then if the websites are still around you should manually delete them. -- Bruce Loehle-Conger MVP SQL Server Reporting Services "trint" <trinity.smith(a)gmail.com> wrote in message news:1190838091.043680.270420(a)k79g2000hse.googlegroups.com... > On Sep 26, 4:00 pm, trint <trinity.sm...(a)gmail.com> wrote: >> On Sep 26, 3:55 pm, "Bruce L-C [MVP]" <bruce_lcNOS...(a)hotmail.com> >> wrote: >> >> >> >> >> >> >Trint, you should only have two websites. Did you install more than >> >once? >> >> > The only suggestion I have on cleaning this up is to Uninstall RS. Then >> > re-install it. Something is definitely wrong with your setup. >> >> > -- >> > Bruce Loehle-Conger >> > MVP SQL Server Reporting Services >> >> > "trint" <trinity.sm...(a)gmail.com> wrote in message >> >> >news:1190832145.285348.198540(a)o80g2000hse.googlegroups.com... >> > On Sep 26, 2:33 pm, "Bruce L-C [MVP]" <bruce_lcNOS...(a)hotmail.com> >> > wrote:> Open up IIS Manager and see if you have the two websites: >> > Reports and >> > > ReportServer. If you do not then something went wrong during your >> > > install >> > > and I suggest uninstalling and reinstall RS (not SQL 2005, just >> > > Reporting >> > > Services). Make sure that the login you use to the server is a member >> > > of >> > > the >> > > local administrator group when installing. >> >> > > -- >> > > Bruce Loehle-Conger >> > > MVP SQL Server Reporting Services >> >> > Snip >> >> > Bruce, >> > Both of those virtual directories exist. >> > Reports, ReportServer and Reporting Services. They are all under >> > Default Website. >> > Thanks,Trint >> >> I think you are right...Seems like I remember having a problem on the >> first install. >> Do I delete one of them? >> Thanks,Trint- Hide quoted text - >> >> - Show quoted text - > > Bruce, > I see why I tried installing it twice... > When I click on the "Reporting Services" virtual directory, I see all > the > needed virtual folders except "Reports". > Could I just try to delete the Reporting Services virtual directory > and see > if that fixes it and leave the ones alone that are directly under > default websites? > Thanks, > Trint > |