Problem with SQL 2000 Reporting Services in Windows Server 2000 IIS 5.0

Hi,

I′m having a problem with the SQL 2000 Reporting Services.
I′ve installed it in a windows 2000 server with IIS 5.0 and after i′ve installed the Reporting Services (even with the SP2 os Reporting Services installed), when i try to log on to the reports webside in order to start creating the folders of the reports that i want to create i get an error (ACCESS DENIED) and i′m trying to access it locally.

How can i solve this?

Regards,

Ricardo

Are you trying to open the website on the installed server or via another computer ?

HTH, Jens SUessmeyer.

http://www.sqlserver2005.de

|||Hi,

I′m trying to open the website on the instaled server. Even if i try to open it from a diferent computer, the error is the same.|||

Try using the rskeymgmt utility to backup the encryption key, and rsactivate utility to activate the site.

Check to see if the Default Application Pool in IIS is using the Network account identity.

Filemon from www.sysinternals.com may also help identify where the issue is.

cheers,

Andrew

|||Do you get an rsAccessDenied or the IIS Access Denied ?

HTH, Jens SUessmeyer.

http://www.sqlserver2005.de

Problem with setting up IIS - You are not authorized to view this page

I am trying to set up IIS on our server (Windows 2003 with SQL Server 2000) and when I try to run a query in a browser I keep getting the following messsage:-
You are not authorized to view this page
I have followed the tutorial (XMLStartup.doc) which was placed in C:\Program Files\Microsoft SQL Server\80\Tools\DevTools\Samples\xml\XMLStartup on installation, but still get the above message when I get to the point of querying the database.
Is there something I am doing wrong or is there some security measure I have not taken into account yet that is preventing me from runing queries?
any help appreciated - Thanks
The problem is probably not in SQL Server but in NTFS and IIS permissions. The IUSR_<server name> user or your local account user (if you are surfing from the server) must have NTFS permissions to read the page you are trying to access, both in IIS and NTFS. Check the NTFS security first and disable "simple file sharing" in WinExplorer if it's by any chance turned on and set the propper permissions on the files you are trying to access.

Problem with Reporting Services 2005

I installed SQL SERVER 2005 with RS2005 - it worked great.
Cause of a problem we had to re-installed the IIS so the virtual directories
of RS where gone...
To continue with errors i deleted the DB of RS
So now i try to re-install the RS but i get this error:
Reason: Your upgrade is blocked. For more information about upgrade support,
see the "Version and Edition Upgrades" and "Hardware and Software
Requirements" topics in SQL Server 2005 Setup Help or SQL Server 2005 Books
Online.
Build version check:
Your upgrade is blocked because the existing component is a later version
than the version you are trying to upgrade to. To modify an existing SQL
Server component, go to Add or Remove Programs in Control Panel, select the
component you would like to modify, and then click Change/Remove.
So what should i do?when i try to it from Add/Remove it also don't work...
My version is :
Microsoft SQL Server Management Studio 9.00.2047.00
But when it try to install the RS it say : 9.1.2047.00
So what's the problem?Can you just try recreating the virtual directories and the databases using
Reporting services configuration manager instead of a complete reinstall?
--
Ramu
This posting is provided "AS IS" with no warranties, and confers no rights.
"ש×?×?×?" wrote:
> I installed SQL SERVER 2005 with RS2005 - it worked great.
> Cause of a problem we had to re-installed the IIS so the virtual directories
> of RS where gone...
> To continue with errors i deleted the DB of RS
> So now i try to re-install the RS but i get this error:
> Reason: Your upgrade is blocked. For more information about upgrade support,
> see the "Version and Edition Upgrades" and "Hardware and Software
> Requirements" topics in SQL Server 2005 Setup Help or SQL Server 2005 Books
> Online.
> Build version check:
> Your upgrade is blocked because the existing component is a later version
> than the version you are trying to upgrade to. To modify an existing SQL
> Server component, go to Add or Remove Programs in Control Panel, select the
> component you would like to modify, and then click Change/Remove.
>
> So what should i do?when i try to it from Add/Remove it also don't work...
> My version is :
> Microsoft SQL Server Management Studio 9.00.2047.00
> But when it try to install the RS it say : 9.1.2047.00
> So what's the problem?
>|||thanks,it helped
what amazing tool!!!
"Ramu_MSFT" wrote:
> Can you just try recreating the virtual directories and the databases using
> Reporting services configuration manager instead of a complete reinstall?
> --
> Ramu
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "ש×?×?×?" wrote:
> > I installed SQL SERVER 2005 with RS2005 - it worked great.
> > Cause of a problem we had to re-installed the IIS so the virtual directories
> > of RS where gone...
> > To continue with errors i deleted the DB of RS
> > So now i try to re-install the RS but i get this error:
> >
> > Reason: Your upgrade is blocked. For more information about upgrade support,
> > see the "Version and Edition Upgrades" and "Hardware and Software
> > Requirements" topics in SQL Server 2005 Setup Help or SQL Server 2005 Books
> > Online.
> >
> > Build version check:
> > Your upgrade is blocked because the existing component is a later version
> > than the version you are trying to upgrade to. To modify an existing SQL
> > Server component, go to Add or Remove Programs in Control Panel, select the
> > component you would like to modify, and then click Change/Remove.
> >
> >
> > So what should i do?when i try to it from Add/Remove it also don't work...
> >
> > My version is :
> > Microsoft SQL Server Management Studio 9.00.2047.00
> > But when it try to install the RS it say : 9.1.2047.00
> >
> > So what's the problem?
> >