Showing posts with label life. Show all posts
Showing posts with label life. Show all posts

Tuesday, March 27, 2012

A curious error message, local temp vs. global temp tables?!?!?

Hi all,

Looking at BOL for temp tables help, I discover that a local temp table (I want to only have life within my stored proc) SHOULD be visible to all (child) stored procs called by the papa stored proc.

However, the following code works just peachy when I use a GLOBAL temp table (i.e., ##MyTempTbl) but fails when I use a local temp table (i.e., #MyTempTable). Through trial and error, and careful weeding efforts, I know that the error I get on the local version is coming from the xp_sendmail call. The error I get is: ODBC error 208 (42S02) Invalid object name '#MyTempTbl'.

Here is the code that works:SET NOCOUNT ON

CREATE TABLE ##MyTempTbl (SeqNo int identity, MyWords varchar(1000))
INSERT ##MyTempTbl values ('Put your long message here.')
INSERT ##MyTempTbl values ('Put your second long message here.')
INSERT ##MyTempTbl values ('put your really, really LONG message (yeah, every guy says his message is the longest...whatever!')
DECLARE @.cmd varchar(256)
DECLARE @.LargestEventSize int
DECLARE @.Width int, @.Msg varchar(128)
SELECT @.LargestEventSize = Max(Len(MyWords))
FROM ##MyTempTbl

SET @.cmd = 'SELECT Cast(MyWords AS varchar(' +
CONVERT(varchar(5), @.LargestEventSize) +
')) FROM ##MyTempTbl order by SeqNo'
SET @.Width = @.LargestEventSize + 1
SET @.Msg = 'Here is the junk you asked about' + CHAR(13) + '---------'
EXECUTE Master.dbo.xp_sendmail
'YoMama@.WhoKnows.com',
@.query = @.cmd,
@.no_header= 'TRUE',
@.width = @.Width,
@.dbuse = 'MyDB',
@.subject='none of your darn business',
@.message= @.Msg
DROP TABLE ##MyTempTbl

The only thing I change to make it fail is the table name, change it from ##MyTempTbl to #MyTempTbl, and it dashes the email hopes of the stored procedure upon the jagged rocks of electronic despair.

Any insight anyone? Or is BOL just full of...well..."stuff"?I would still like to hear if anyone knows anything different, but while looking into Des' sendmail problem, I found this lil' tidbit in BOL for xp_sendmail If query is specified, xp_sendmail logs in to SQL Server as a client and executes the specified query. SQL Mail makes a separate connection to SQL Server; it does not share the same connection as the original client connection issuing xp_sendmail. I suspect the "separate connection to SQL Server" is the issue here?!?!?! Hmmmm...perhaps the local temp table can be seen by child processes called by the proc that creates the table EXCEPT in xp_sendmail, etc.|||You hit the problem right on the head... xp_sendmail does execute the query in a different context, meaning that it can't see local variables, settings, or temp tables. You can think of it almost as though xp_sendmail were cranking up OSQL.EXE to execute your query (that isn't what actually happens, but it is logically pretty close).

-PatP

Saturday, February 11, 2012

4 days and still can't get my report to depoly (help)...

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/ReportServer or http://localhost/ReportServer and get
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,
TrintFirst 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.smith@.gmail.com> wrote in message
news:1190668106.834755.26140@.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/ReportServer or http://localhost/ReportServer and get
> 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
>|||On Sep 25, 10:51 am, "Bruce L-C [MVP]" <bruce_lcNOS...@.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...@.gmail.com> wrote in message
> news:1190668106.834755.26140@.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/ReportServerand get
> > 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,
I'm going to try this right now! Please stay with me on this
I will be right back with you.
Thanks for your help!
Trint|||On Sep 25, 10:51 am, "Bruce L-C [MVP]" <bruce_lcNOS...@.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...@.gmail.com> wrote in message
> news:1190668106.834755.26140@.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/ReportServerand get
> > 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|||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.smith@.gmail.com> wrote in message
news:1190820960.305074.169310@.r29g2000hsg.googlegroups.com...
> On Sep 25, 10:51 am, "Bruce L-C [MVP]" <bruce_lcNOS...@.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...@.gmail.com> wrote in message
>> news:1190668106.834755.26140@.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/ReportServerand get
>> > 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
>|||On Sep 26, 12:16 pm, "Bruce L-C [MVP]" <bruce_lcNOS...@.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...@.gmail.com> wrote in message
> news:1190820960.305074.169310@.r29g2000hsg.googlegroups.com...
>
> > On Sep 25, 10:51 am, "Bruce L-C [MVP]" <bruce_lcNOS...@.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...@.gmail.com> wrote in message
> >>news:1190668106.834755.26140@.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|||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@.gmail.com> wrote in message
news:1190824593.744787.46820@.k79g2000hse.googlegroups.com...
> On Sep 26, 12:16 pm, "Bruce L-C [MVP]" <bruce_lcNOS...@.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...@.gmail.com> wrote in message
>> news:1190820960.305074.169310@.r29g2000hsg.googlegroups.com...
>>
>> > On Sep 25, 10:51 am, "Bruce L-C [MVP]" <bruce_lcNOS...@.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...@.gmail.com> wrote in message
>> >>news:1190668106.834755.26140@.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
>|||On Sep 26, 1:11 pm, "Bruce L-C [MVP]" <bruce_lcNOS...@.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...@.gmail.com> wrote in message
> news:1190824593.744787.46820@.k79g2000hse.googlegroups.com...
>
> > On Sep 26, 12:16 pm, "Bruce L-C [MVP]" <bruce_lcNOS...@.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...@.gmail.com> wrote in message
> >>news:1190820960.305074.169310@.r29g2000hsg.googlegroups.com...
> >> > On Sep 25, 10:51 am, "Bruce L-C [MVP]" <bruce_lcNOS...@.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...@.gmail.com> wrote in message
> >> >>news:1190668106.834755.26140@.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|||On Sep 26, 1:11 pm, "Bruce L-C [MVP]" <bruce_lcNOS...@.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...@.gmail.com> wrote in message
> news:1190824593.744787.46820@.k79g2000hse.googlegroups.com...
>
> > On Sep 26, 12:16 pm, "Bruce L-C [MVP]" <bruce_lcNOS...@.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...@.gmail.com> wrote in message
> >>news:1190820960.305074.169310@.r29g2000hsg.googlegroups.com...
> >> > On Sep 25, 10:51 am, "Bruce L-C [MVP]" <bruce_lcNOS...@.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...@.gmail.com> wrote in message
> >> >>news:1190668106.834755.26140@.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|||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@.gmail.com> wrote in message
news:1190829660.683856.249390@.50g2000hsm.googlegroups.com...
> On Sep 26, 1:11 pm, "Bruce L-C [MVP]" <bruce_lcNOS...@.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...@.gmail.com> wrote in message
>> news:1190824593.744787.46820@.k79g2000hse.googlegroups.com...
>>
>> > On Sep 26, 12:16 pm, "Bruce L-C [MVP]" <bruce_lcNOS...@.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...@.gmail.com> wrote in message
>> >>news:1190820960.305074.169310@.r29g2000hsg.googlegroups.com...
>> >> > On Sep 25, 10:51 am, "Bruce L-C [MVP]" <bruce_lcNOS...@.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...@.gmail.com> wrote in message
>> >> >>news:1190668106.834755.26140@.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
>|||On Sep 26, 2:33 pm, "Bruce L-C [MVP]" <bruce_lcNOS...@.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...@.gmail.com> wrote in message
> news:1190829660.683856.249390@.50g2000hsm.googlegroups.com...
>
> > On Sep 26, 1:11 pm, "Bruce L-C [MVP]" <bruce_lcNOS...@.hotmail.com>
> > wrote:
> >> That's your problem. Nothing will work without that. Report Manager (t=he
> >> portal that ships with RS) uses web services. You need to get that Gre=en.
> >> 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...@.gmail.com> wrote in message
> >>news:1190824593.744787.46820@.k79g2000hse.googlegroups.com...
> >> > On Sep 26, 12:16 pm, "Bruce L-C [MVP]" <bruce_lcNOS...@.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...@.gmail.com> wrote in message
> >> >>news:1190820960.305074.169310@.r29g2000hsg.googlegroups.com...
> >> >> > On Sep 25, 10:51 am, "Bruce L-C [MVP]" <bruce_lcNOS...@.hotmail.c=om>
> >> >> > 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 c=ome
> >> >> >> 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...@.gmail.com> wrote in message
> >> >> >>news:1190668106.834755.26140@.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 compati=ble
> >> >> >> > 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.SetWebServiceIde=ntit=ADy(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|||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@.gmail.com> wrote in message
news:1190832145.285348.198540@.o80g2000hse.googlegroups.com...
On Sep 26, 2:33 pm, "Bruce L-C [MVP]" <bruce_lcNOS...@.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|||On Sep 26, 3:55 pm, "Bruce L-C [MVP]" <bruce_lcNOS...@.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...@.gmail.com> wrote in message
> news:1190832145.285348.198540@.o80g2000hse.googlegroups.com...
> On Sep 26, 2:33 pm, "Bruce L-C [MVP]" <bruce_lcNOS...@.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|||On Sep 26, 4:00 pm, trint <trinity.sm...@.gmail.com> wrote:
> On Sep 26, 3:55 pm, "Bruce L-C [MVP]" <bruce_lcNOS...@.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...@.gmail.com> wrote in message
> >news:1190832145.285348.198540@.o80g2000hse.googlegroups.com...
> > On Sep 26, 2:33 pm, "Bruce L-C [MVP]" <bruce_lcNOS...@.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|||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@.gmail.com> wrote in message
news:1190838091.043680.270420@.k79g2000hse.googlegroups.com...
> On Sep 26, 4:00 pm, trint <trinity.sm...@.gmail.com> wrote:
>> On Sep 26, 3:55 pm, "Bruce L-C [MVP]" <bruce_lcNOS...@.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...@.gmail.com> wrote in message
>> >news:1190832145.285348.198540@.o80g2000hse.googlegroups.com...
>> > On Sep 26, 2:33 pm, "Bruce L-C [MVP]" <bruce_lcNOS...@.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
>|||On Sep 26, 4:49 pm, "Bruce L-C [MVP]" <bruce_lcNOS...@.hotmail.com>
wrote:
> 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.sm...@.gmail.com> wrote in message
> news:1190838091.043680.270420@.k79g2000hse.googlegroups.com...
>
> > On Sep 26, 4:00 pm,trint<trinity.sm...@.gmail.com> wrote:
> >> On Sep 26, 3:55 pm, "Bruce L-C [MVP]" <bruce_lcNOS...@.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...@.gmail.com> wrote in message
> >> >news:1190832145.285348.198540@.o80g2000hse.googlegroups.com...
> >> > On Sep 26, 2:33 pm, "Bruce L-C [MVP]" <bruce_lcNOS...@.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- Hide quoted text -
> - Show quoted text -
Bruce,
You have no idea how much I appreciate your assistance.
If anything else pops up, I can't think of anyone else I'd rather
answer my questions...If you can't give me a contact, I understand...
But thank you so much...I'm sure I'll get it running correctly soon.
Trinit|||On Sep 26, 5:29 pm, trint <trinity.sm...@.gmail.com> wrote:
> On Sep 26, 4:49 pm, "Bruce L-C [MVP]" <bruce_lcNOS...@.hotmail.com>
> wrote:
>
>
> > 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.sm...@.gmail.com> wrote in message
> >news:1190838091.043680.270420@.k79g2000hse.googlegroups.com...
> > > On Sep 26, 4:00 pm,trint<trinity.sm...@.gmail.com> wrote:
> > >> On Sep 26, 3:55 pm, "Bruce L-C [MVP]" <bruce_lcNOS...@.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...@.gmail.com> wrote in message
> > >> >news:1190832145.285348.198540@.o80g2000hse.googlegroups.com...
> > >> > On Sep 26, 2:33 pm, "Bruce L-C [MVP]" <bruce_lcNOS...@.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- Hide quoted text -
> > - Show quoted text -
> Bruce,
> You have no idea how much I appreciate your assistance.
> If anything else pops up, I can't think of anyone else I'd rather
> answer my questions...If you can't give me a contact, I understand...
> But thank you so much...I'm sure I'll get it running correctly soon.
> Trinit- Hide quoted text -
> - Show quoted text -
Here is what fixed my problem:
I disabled the Execution Account with the Reporting Services
Configuration Manager.
Thanks,
Trint