Cannot connect to SQL 2005 Reporting Services

In SQL Server Management Studio, I try to connect to the Reporting Services.
I got the following messages.
'Cannot connect to KSIU-LT\SQL2005'
Additional information: The request failed with HTTP status 407:Proxy Access
Denied
I installed the SQL 2005 Developer Edition Sep CTP in XP Professional.
and the Reporting services is started.
please helpOn Wed, 5 Oct 2005 20:55:02 -0700, Kam <Kam@.discussions.microsoft.com>
wrote:
>In SQL Server Management Studio, I try to connect to the Reporting Services.
>I got the following messages.
>'Cannot connect to KSIU-LT\SQL2005'
>Additional information: The request failed with HTTP status 407:Proxy Access
>Denied
>I installed the SQL 2005 Developer Edition Sep CTP in XP Professional.
>and the Reporting services is started.
>please help
Is the Reporting Services 2005 installed locally or remotely?
It may be a permissions issue on the remote server outside Reporting
Services 2005.
Andrew Watt
MVP - InfoPath|||all SQL 2005 services are installed locally, including Reporting Services 2005.
of course the proxy server is on the network, not in my machine.
If you can give me some indication about the security area that I need to
look at, it will be very helpful.
but I am using a domain administrator account to login in.
"Andrew Watt [MVP - InfoPath]" wrote:
> On Wed, 5 Oct 2005 20:55:02 -0700, Kam <Kam@.discussions.microsoft.com>
> wrote:
> >In SQL Server Management Studio, I try to connect to the Reporting Services.
> >I got the following messages.
> >
> >'Cannot connect to KSIU-LT\SQL2005'
> >Additional information: The request failed with HTTP status 407:Proxy Access
> >Denied
> >
> >I installed the SQL 2005 Developer Edition Sep CTP in XP Professional.
> >and the Reporting services is started.
> >
> >please help
> Is the Reporting Services 2005 installed locally or remotely?
> It may be a permissions issue on the remote server outside Reporting
> Services 2005.
> Andrew Watt
> MVP - InfoPath
>|||Kam,
Let's go back a step.
If you have everything installed locally, did you choose (I have to
think hard here - a checkbox?) the option to use the default
configuration at install? Or did you customise it later?
Also if you use your browser to navigate to http://localhost/reports
and http://localhost/reportserver what do you get?
Andrew Watt
MVP - InfoPath
On Thu, 6 Oct 2005 15:25:08 -0700, Kam <Kam@.discussions.microsoft.com>
wrote:
>all SQL 2005 services are installed locally, including Reporting Services 2005.
>of course the proxy server is on the network, not in my machine.
>If you can give me some indication about the security area that I need to
>look at, it will be very helpful.
>but I am using a domain administrator account to login in.
>"Andrew Watt [MVP - InfoPath]" wrote:
>> On Wed, 5 Oct 2005 20:55:02 -0700, Kam <Kam@.discussions.microsoft.com>
>> wrote:
>> >In SQL Server Management Studio, I try to connect to the Reporting Services.
>> >I got the following messages.
>> >
>> >'Cannot connect to KSIU-LT\SQL2005'
>> >Additional information: The request failed with HTTP status 407:Proxy Access
>> >Denied
>> >
>> >I installed the SQL 2005 Developer Edition Sep CTP in XP Professional.
>> >and the Reporting services is started.
>> >
>> >please help
>> Is the Reporting Services 2005 installed locally or remotely?
>> It may be a permissions issue on the remote server outside Reporting
>> Services 2005.
>> Andrew Watt
>> MVP - InfoPath|||I use the customise. If I use default the sample will not be included.
the http://localhost/reports look like working fine, but the
http://localhost/reportserver didn't work. (I think). It show
localhost//ReportServer on the title and didn't have any meaningful content.
at the bottom it say Microsoft SQL Server Reporting Services Version
9.00.1314.00.
the services is not up and running. I can't use SQL Server Management Studio
to open the Reporting Services, but In the SQL Configuration Manager show the
reporting services is started.
please help
"Andrew Watt [MVP - InfoPath]" wrote:
> Kam,
> Let's go back a step.
> If you have everything installed locally, did you choose (I have to
> think hard here - a checkbox?) the option to use the default
> configuration at install? Or did you customise it later?
> Also if you use your browser to navigate to http://localhost/reports
> and http://localhost/reportserver what do you get?
> Andrew Watt
> MVP - InfoPath
> On Thu, 6 Oct 2005 15:25:08 -0700, Kam <Kam@.discussions.microsoft.com>
> wrote:
> >all SQL 2005 services are installed locally, including Reporting Services 2005.
> >of course the proxy server is on the network, not in my machine.
> >
> >If you can give me some indication about the security area that I need to
> >look at, it will be very helpful.
> >
> >but I am using a domain administrator account to login in.
> >
> >"Andrew Watt [MVP - InfoPath]" wrote:
> >
> >> On Wed, 5 Oct 2005 20:55:02 -0700, Kam <Kam@.discussions.microsoft.com>
> >> wrote:
> >>
> >> >In SQL Server Management Studio, I try to connect to the Reporting Services.
> >> >I got the following messages.
> >> >
> >> >'Cannot connect to KSIU-LT\SQL2005'
> >> >Additional information: The request failed with HTTP status 407:Proxy Access
> >> >Denied
> >> >
> >> >I installed the SQL 2005 Developer Edition Sep CTP in XP Professional.
> >> >and the Reporting services is started.
> >> >
> >> >please help
> >>
> >> Is the Reporting Services 2005 installed locally or remotely?
> >>
> >> It may be a permissions issue on the remote server outside Reporting
> >> Services 2005.
> >>
> >> Andrew Watt
> >> MVP - InfoPath
> >>
>|||Kim,
If I understand your situation correctly it is this:
1. Report Manager is working correctly (I assume it is listing folders
and reports and will display reports, as selected)
2. Using http://localhost/reportserver fails to list the reports you
see in Report Manager. Is that correct?
3. You cannot access Reporting Servers from SQL Server Management
Studio.
From SQL Server Management Studio if you try to use Registered Servers
to register a new reporting service and call it . (a single period
character) can you connect?
Andrew Watt
MVP - InfoPath
On Sun, 9 Oct 2005 06:17:05 -0700, Kam <Kam@.discussions.microsoft.com>
wrote:
>I use the customise. If I use default the sample will not be included.
>the http://localhost/reports look like working fine, but the
>http://localhost/reportserver didn't work. (I think). It show
>localhost//ReportServer on the title and didn't have any meaningful content.
>at the bottom it say Microsoft SQL Server Reporting Services Version
>9.00.1314.00.
>the services is not up and running. I can't use SQL Server Management Studio
>to open the Reporting Services, but In the SQL Configuration Manager show the
>reporting services is started.
>please help
>"Andrew Watt [MVP - InfoPath]" wrote:
>> Kam,
>> Let's go back a step.
>> If you have everything installed locally, did you choose (I have to
>> think hard here - a checkbox?) the option to use the default
>> configuration at install? Or did you customise it later?
>> Also if you use your browser to navigate to http://localhost/reports
>> and http://localhost/reportserver what do you get?
>> Andrew Watt
>> MVP - InfoPath
>> On Thu, 6 Oct 2005 15:25:08 -0700, Kam <Kam@.discussions.microsoft.com>
>> wrote:
>> >all SQL 2005 services are installed locally, including Reporting Services 2005.
>> >of course the proxy server is on the network, not in my machine.
>> >
>> >If you can give me some indication about the security area that I need to
>> >look at, it will be very helpful.
>> >
>> >but I am using a domain administrator account to login in.
>> >
>> >"Andrew Watt [MVP - InfoPath]" wrote:
>> >
>> >> On Wed, 5 Oct 2005 20:55:02 -0700, Kam <Kam@.discussions.microsoft.com>
>> >> wrote:
>> >>
>> >> >In SQL Server Management Studio, I try to connect to the Reporting Services.
>> >> >I got the following messages.
>> >> >
>> >> >'Cannot connect to KSIU-LT\SQL2005'
>> >> >Additional information: The request failed with HTTP status 407:Proxy Access
>> >> >Denied
>> >> >
>> >> >I installed the SQL 2005 Developer Edition Sep CTP in XP Professional.
>> >> >and the Reporting services is started.
>> >> >
>> >> >please help
>> >>
>> >> Is the Reporting Services 2005 installed locally or remotely?
>> >>
>> >> It may be a permissions issue on the remote server outside Reporting
>> >> Services 2005.
>> >>
>> >> Andrew Watt
>> >> MVP - InfoPath
>> >>
>>|||1. I don't know. as I need to use vs to connect to the reporting services to
delpoy the report. but I failed to use either vs or Management studio to
connect.
2.yes fail to connect to http://localhost/reportserver
3. yes
my localhost is registered, but I can't connect to it
"Andrew Watt [MVP - InfoPath]" wrote:
> Kim,
> If I understand your situation correctly it is this:
> 1. Report Manager is working correctly (I assume it is listing folders
> and reports and will display reports, as selected)
> 2. Using http://localhost/reportserver fails to list the reports you
> see in Report Manager. Is that correct?
> 3. You cannot access Reporting Servers from SQL Server Management
> Studio.
> From SQL Server Management Studio if you try to use Registered Servers
> to register a new reporting service and call it . (a single period
> character) can you connect?
> Andrew Watt
> MVP - InfoPath
> On Sun, 9 Oct 2005 06:17:05 -0700, Kam <Kam@.discussions.microsoft.com>
> wrote:
> >I use the customise. If I use default the sample will not be included.
> >the http://localhost/reports look like working fine, but the
> >http://localhost/reportserver didn't work. (I think). It show
> >localhost//ReportServer on the title and didn't have any meaningful content.
> >at the bottom it say Microsoft SQL Server Reporting Services Version
> >9.00.1314.00.
> >
> >the services is not up and running. I can't use SQL Server Management Studio
> >to open the Reporting Services, but In the SQL Configuration Manager show the
> >reporting services is started.
> >
> >please help
> >
> >"Andrew Watt [MVP - InfoPath]" wrote:
> >
> >> Kam,
> >>
> >> Let's go back a step.
> >>
> >> If you have everything installed locally, did you choose (I have to
> >> think hard here - a checkbox?) the option to use the default
> >> configuration at install? Or did you customise it later?
> >>
> >> Also if you use your browser to navigate to http://localhost/reports
> >> and http://localhost/reportserver what do you get?
> >>
> >> Andrew Watt
> >> MVP - InfoPath
> >>
> >> On Thu, 6 Oct 2005 15:25:08 -0700, Kam <Kam@.discussions.microsoft.com>
> >> wrote:
> >>
> >> >all SQL 2005 services are installed locally, including Reporting Services 2005.
> >> >of course the proxy server is on the network, not in my machine.
> >> >
> >> >If you can give me some indication about the security area that I need to
> >> >look at, it will be very helpful.
> >> >
> >> >but I am using a domain administrator account to login in.
> >> >
> >> >"Andrew Watt [MVP - InfoPath]" wrote:
> >> >
> >> >> On Wed, 5 Oct 2005 20:55:02 -0700, Kam <Kam@.discussions.microsoft.com>
> >> >> wrote:
> >> >>
> >> >> >In SQL Server Management Studio, I try to connect to the Reporting Services.
> >> >> >I got the following messages.
> >> >> >
> >> >> >'Cannot connect to KSIU-LT\SQL2005'
> >> >> >Additional information: The request failed with HTTP status 407:Proxy Access
> >> >> >Denied
> >> >> >
> >> >> >I installed the SQL 2005 Developer Edition Sep CTP in XP Professional.
> >> >> >and the Reporting services is started.
> >> >> >
> >> >> >please help
> >> >>
> >> >> Is the Reporting Services 2005 installed locally or remotely?
> >> >>
> >> >> It may be a permissions issue on the remote server outside Reporting
> >> >> Services 2005.
> >> >>
> >> >> Andrew Watt
> >> >> MVP - InfoPath
> >> >>
> >>
> >>
>