4 days and still can't get my report to depoly (help)...
in [Reports]
|
From: trint on 26 Sep 2007 12:36 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
From: Bruce L-C [MVP] on 26 Sep 2007 13:11 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.smith(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 >
From: trint on 26 Sep 2007 13:57 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, What do I do to fix this? I need your help and am very appreciative. Thanks, Trint
From: trint on 26 Sep 2007 14:01 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.SetWebServiceIdentity(String applicationPool) Thanks, Trint
From: Bruce L-C [MVP] on 26 Sep 2007 14:33
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.smith(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.SetWebServiceIdentity(String > applicationPool) > > Thanks, > Trint > |