Need help to connect report server of sql server2005

Hello,

I have a local installation of SQL Server 2005 (evaluation ) on window 2000
sp4, with Reporting Services, Integration Services, and Analysis Server
installed.

I can connect to Integration Services and Analysis Server via the SQL Server
Management Studio, but not to the Report Server. I also can't access and use
the Report Server installation via<http://myserver/Reports> and
<http://myserver/ReportServer>. The following is an error I got when i try to
connect report server by SSMS:

The request failed with HTTP status 407: Proxy Authentication Required ( The
ISA Server requires authorization to fulfill the request. Access to the Web
Proxy service is denied. ). (Microsoft.SqlServer.Management.UI.RSClient)

Can anyone helps me out ? Any suggestion is welcome. Thanks.

======================================================

Karen Chen | (204) 983-2761 | <mailto:kchen@grainscanada.gc.ca>
| facsimile / tlcopieur (204) 983-0248
Programmer/Analyst /Programmeure/analyste
Applications & Development / Applications & dveloppement
Corporate Services / Services à l'organisme
Canadian Grain Commission | 700-303 Main Street, Winnipeg, MB R3C 3G8
Commission canadienne des grains | 303, rue Main, pièce 700 | Winnipeg, MB R3C 3G8
Government of Canada | Gouvernement du Canada

[3473 byte] By [KarenChen] at [2007-12-17]
# 1
Have you tried running the configuration tool to see if something is not configured correctly?
DanielReib at 2007-10-6 > top of Msdn Tech,SQL Server,SQL Server Reporting Services...
# 2
Hi Daniel,

Thanks you get back to me. Yes I did and here is what i had in configured report server:

1. Server status: server is runnung
2. RS virtural Directory setting:
Name: ReportServer$S2005 (S2005 is instance name)
Website: Default Web Site
3. Report manager directory setting:
Name: Reports$S2005
Website: Default Web Site
4. Database Setup:
Server Name: CGC-I03515\S2005
DB Name; ReportServer$S2005
Credentials: Service Credentials

5. Initialization and Web setting: Yes
6.Encrption Keys: NO
7. Executin account: No
8. Web Services Identity: For some reason can't configure it (no editable). What is ASP.NET service account? what did you put in there?

Please give me some idea and thanks again.

Karen

KarenChen at 2007-10-6 > top of Msdn Tech,SQL Server,SQL Server Reporting Services...
# 3
Are you using a pre-RTM release of SQL 2005? From the description of the config tool it seems so. Can you upgrade?

-Daniel

DanielReib at 2007-10-6 > top of Msdn Tech,SQL Server,SQL Server Reporting Services...

SQL Server

Site Classified