Cannot Connect to RS in SSMS

This relates to my previously unanswered post "HTTP Error 401.2" but when I
try to connect to Reporting Services via SSMS using Windows Authentication
(signed on as Administrator) I get "Cannot connect to MYMACHINE\SQL2005. The
request failed with HTTP status 401: Unauthorized.
(Microsoft.SqlServer.Management.UI.RSClient)"
So, what needs to be configured to connect? Should I reinstall something?
I'm lost here, and dead in the water until I can connect, thanks for any
help.On Oct 22, 4:43 pm, "Don Miller" <nos...@.nospam.com> wrote:
> This relates to my previously unanswered post "HTTP Error 401.2" but when I
> try to connect to Reporting Services via SSMS using Windows Authentication
> (signed on as Administrator) I get "Cannot connect to MYMACHINE\SQL2005. The
> request failed with HTTP status 401: Unauthorized.
> (Microsoft.SqlServer.Management.UI.RSClient)"
> So, what needs to be configured to connect? Should I reinstall something?
> I'm lost here, and dead in the water until I can connect, thanks for any
> help.
This link might be helpful.
http://blogs.msdn.com/david.wang/archive/2005/07/14/HOWTO_Diagnose_IIS_401_Access_Denied.aspx
Regards,
Enrique Martinez
Sr. Software Consultant|||Thanks for the reference although I didn't come up with how to fix IIS or RS
so they will work together.
Here's the abbreviated logs when trying to open RS using SSMS
#Software: Microsoft Internet Information Services 6.0
#Version: 1.0
2007-10-23 POST /reportserver/ReportService2005.asmx - 80 - 401 2 2148074254
2007-10-23 POST /reportserver/ReportService2005.asmx - 80 - 401 1 0
2007-10-23 POST /reportserver/ReportService2005.asmx - 80 - 401 1 2148074248
And here's the log when trying to open reports with browser, with signon
dialog displayed first (and I signed on as the Administrator)
2007-10-23 GET /reports - 80 - Mozilla/4.0+ 401 2 2148074254
2007-10-23 GET /reports - 80 - Mozilla/4.0+ 401 1 0
Any ideas?
"EMartinez" <emartinez.pr1@.gmail.com> wrote in message
news:1193101429.784868.12330@.t8g2000prg.googlegroups.com...
> On Oct 22, 4:43 pm, "Don Miller" <nos...@.nospam.com> wrote:
>> This relates to my previously unanswered post "HTTP Error 401.2" but when
>> I
>> try to connect to Reporting Services via SSMS using Windows
>> Authentication
>> (signed on as Administrator) I get "Cannot connect to MYMACHINE\SQL2005.
>> The
>> request failed with HTTP status 401: Unauthorized.
>> (Microsoft.SqlServer.Management.UI.RSClient)"
>> So, what needs to be configured to connect? Should I reinstall something?
>> I'm lost here, and dead in the water until I can connect, thanks for any
>> help.
>
> This link might be helpful.
> http://blogs.msdn.com/david.wang/archive/2005/07/14/HOWTO_Diagnose_IIS_401_Access_Denied.aspx
> Regards,
> Enrique Martinez
> Sr. Software Consultant
>|||Solved! (after two days of random permutations and finally a tip from
Enrique Martinez - Thanks again, Enrique).
I used AuthDiag mentioned in the article and found out that Enable HTTP
Keep-Alives was unchecked for the website in IIS and NLTM requires
Keep-Alives. How that checkbox ever got unchecked I will never know.
"Don Miller" <nospam@.nospam.com> wrote in message
news:%23j4pEQXFIHA.3548@.TK2MSFTNGP06.phx.gbl...
> Thanks for the reference although I didn't come up with how to fix IIS or
> RS so they will work together.
> Here's the abbreviated logs when trying to open RS using SSMS
> #Software: Microsoft Internet Information Services 6.0
> #Version: 1.0
> 2007-10-23 POST /reportserver/ReportService2005.asmx - 80 - 401 2
> 2148074254
> 2007-10-23 POST /reportserver/ReportService2005.asmx - 80 - 401 1 0
> 2007-10-23 POST /reportserver/ReportService2005.asmx - 80 - 401 1
> 2148074248
> And here's the log when trying to open reports with browser, with signon
> dialog displayed first (and I signed on as the Administrator)
> 2007-10-23 GET /reports - 80 - Mozilla/4.0+ 401 2 2148074254
> 2007-10-23 GET /reports - 80 - Mozilla/4.0+ 401 1 0
> Any ideas?
>
> "EMartinez" <emartinez.pr1@.gmail.com> wrote in message
> news:1193101429.784868.12330@.t8g2000prg.googlegroups.com...
>> On Oct 22, 4:43 pm, "Don Miller" <nos...@.nospam.com> wrote:
>> This relates to my previously unanswered post "HTTP Error 401.2" but
>> when I
>> try to connect to Reporting Services via SSMS using Windows
>> Authentication
>> (signed on as Administrator) I get "Cannot connect to MYMACHINE\SQL2005.
>> The
>> request failed with HTTP status 401: Unauthorized.
>> (Microsoft.SqlServer.Management.UI.RSClient)"
>> So, what needs to be configured to connect? Should I reinstall
>> something?
>> I'm lost here, and dead in the water until I can connect, thanks for any
>> help.
>>
>> This link might be helpful.
>> http://blogs.msdn.com/david.wang/archive/2005/07/14/HOWTO_Diagnose_IIS_401_Access_Denied.aspx
>> Regards,
>> Enrique Martinez
>> Sr. Software Consultant
>