Can't install RS

I got a windows XP pro with SQL 2000 SP4 installed. I'm trying to install
Reporting services, it tells me that it requires SP3a and wont let me
continue. I can't uninstall SP4. I installed it a while ago and since it
worked OK did not keep the backed up version of the databases pre-SP4.
Anyone knows how I can get Reporting services installed on this machine?
Thanks for any help.
BobWhat is the result of running the following TSQL:
master.dbo.xp_msver 'ProductVersion'
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Bob" <bdufour@.sgiims.com> wrote in message
news:u9dLVMJtFHA.460@.TK2MSFTNGP15.phx.gbl...
>I got a windows XP pro with SQL 2000 SP4 installed. I'm trying to install
>Reporting services, it tells me that it requires SP3a and wont let me
>continue. I can't uninstall SP4. I installed it a while ago and since it
>worked OK did not keep the backed up version of the databases pre-SP4.
> Anyone knows how I can get Reporting services installed on this machine?
> Thanks for any help.
> Bob
>|||Index = 2
Name = ProductVersion
InternalValue = 524288
Character_value = 8.00.194
Bob
"Daniel Reib [MSFT]" <danreib@.online.microsoft.com> wrote in message
news:ul0dddJtFHA.464@.TK2MSFTNGP15.phx.gbl...
> What is the result of running the following TSQL:
> master.dbo.xp_msver 'ProductVersion'
>
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>
> "Bob" <bdufour@.sgiims.com> wrote in message
> news:u9dLVMJtFHA.460@.TK2MSFTNGP15.phx.gbl...
>>I got a windows XP pro with SQL 2000 SP4 installed. I'm trying to install
>>Reporting services, it tells me that it requires SP3a and wont let me
>>continue. I can't uninstall SP4. I installed it a while ago and since it
>>worked OK did not keep the backed up version of the databases pre-SP4.
>> Anyone knows how I can get Reporting services installed on this machine?
>> Thanks for any help.
>> Bob
>>
>|||This doesn't appear to be SP4 of SQL server. The results should be
Index Name Internal_Value Character_Value
-- -- -- --
2 ProductVersion 524288 8.00.2039
RS setup looks for a value greater then 8.00.760. It will not allow you to
setup if this value is less. (For some situations we require 8.00.859 or
greater). If you are sure you have SP4 installed then you would first need
to find out why the version number is not correct before you can install RS.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Bob" <bdufour@.sgiims.com> wrote in message
news:OKsG7sJtFHA.4076@.TK2MSFTNGP11.phx.gbl...
> Index = 2
> Name = ProductVersion
> InternalValue = 524288
> Character_value = 8.00.194
> Bob
> "Daniel Reib [MSFT]" <danreib@.online.microsoft.com> wrote in message
> news:ul0dddJtFHA.464@.TK2MSFTNGP15.phx.gbl...
>> What is the result of running the following TSQL:
>> master.dbo.xp_msver 'ProductVersion'
>>
>> --
>> -Daniel
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>> "Bob" <bdufour@.sgiims.com> wrote in message
>> news:u9dLVMJtFHA.460@.TK2MSFTNGP15.phx.gbl...
>>I got a windows XP pro with SQL 2000 SP4 installed. I'm trying to install
>>Reporting services, it tells me that it requires SP3a and wont let me
>>continue. I can't uninstall SP4. I installed it a while ago and since it
>>worked OK did not keep the backed up version of the databases pre-SP4.
>> Anyone knows how I can get Reporting services installed on this machine?
>> Thanks for any help.
>> Bob
>>
>>
>|||Thanks.
Since I had nothing in the databases locally yet, I just completely
uninstalled SQL and did a reinstall from scratch up to and including Sp3a.
Now report server install ok and I also managed to install RS SP2.
However when I call the URL localhost/reports I now get
Access to the path "D:\Program Files\Microsoft SQL Server\MSSQL\Reporting
Services\ReportManager\bin" is denied.
Description: An unhandled exception occurred during the execution of the
current web request. Please review the stack trace for more information
about the error and where it originated in the code.
Exception Details: System.UnauthorizedAccessException: Access to the path
"D:\Program Files\Microsoft SQL Server\MSSQL\Reporting
Services\ReportManager\bin" is denied.
ASP.NET is not authorized to access the requested resource. Consider
granting access rights to the resource to the ASP.NET request identity.
ASP.NET has a base process identity (typically {MACHINE}\ASPNET on IIS 5 or
Network Service on IIS 6) that is used if the application is not
impersonating. If the application is impersonating via <identity
impersonate="true"/>, the identity will be the anonymous user (typically
IUSR_MACHINENAME) or the authenticated request user.
To grant ASP.NET write access to a file, right-click the file in Explorer,
choose "Properties" and select the Security tab. Click "Add" to add the
appropriate user or group. Highlight the ASP.NET account, and check the
boxes for the desired access.
Source Error:
An unhandled exception was generated during the execution of the
current web request. Information regarding the origin and location of the
exception can be identified using the exception stack trace below.
Stack Trace:
[UnauthorizedAccessException: Access to the path "D:\Program Files\Microsoft
SQL Server\MSSQL\Reporting Services\ReportManager\bin" is denied.]
System.IO.__Error.WinIOError(Int32 errorCode, String str) +393
System.IO.Directory.InternalGetFileDirectoryNames(String fullPath, String
userPath, Boolean file) +229
System.IO.Directory.InternalGetDirectories(String path, String userPath,
String searchPattern) +24
System.IO.Directory.GetDirectories(String path, String searchPattern)
+477
Microsoft.ReportingServices.Diagnostics.Localization.GetInstalledCultures()
Microsoft.ReportingServices.Diagnostics.Localization..cctor()
[TypeInitializationException: The type initializer for
"Microsoft.ReportingServices.Diagnostics.Localization" threw an exception.]
Microsoft.ReportingServices.Diagnostics.Localization.SetCultureFromPriorityList(String[]
localeList) +0
Microsoft.ReportingServices.UI.GlobalApp.Application_BeginRequest(Object
sender, EventArgs e)
System.Web.SyncEventExecutionStep.System.Web.HttpApplication+IExecutionStep.Execute()
+60
System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean&
completedSynchronously) +87
----
Version Information: Microsoft .NET Framework Version:1.1.4322.2032; ASP.NET
Version:1.1.4322.2032
I'm logged in with domain administrator privileges and the domain account
domain.iwam_asp.net has full privileges to this folder. Any idea what I
might need to do now to get this working.
This Win XP pro is part of a small domain. Might this have something to do
with it? The installation went OK this time.
Thanks for any help,
Bob
"Daniel Reib [MSFT]" <danreib@.online.microsoft.com> wrote in message
news:OEutF2JtFHA.908@.tk2msftngp13.phx.gbl...
> This doesn't appear to be SP4 of SQL server. The results should be
> Index Name Internal_Value Character_Value
> -- -- -- --
> 2 ProductVersion 524288 8.00.2039
> RS setup looks for a value greater then 8.00.760. It will not allow you
> to setup if this value is less. (For some situations we require 8.00.859
> or greater). If you are sure you have SP4 installed then you would first
> need to find out why the version number is not correct before you can
> install RS.
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>
> "Bob" <bdufour@.sgiims.com> wrote in message
> news:OKsG7sJtFHA.4076@.TK2MSFTNGP11.phx.gbl...
>> Index = 2
>> Name = ProductVersion
>> InternalValue = 524288
>> Character_value = 8.00.194
>> Bob
>> "Daniel Reib [MSFT]" <danreib@.online.microsoft.com> wrote in message
>> news:ul0dddJtFHA.464@.TK2MSFTNGP15.phx.gbl...
>> What is the result of running the following TSQL:
>> master.dbo.xp_msver 'ProductVersion'
>>
>> --
>> -Daniel
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>> "Bob" <bdufour@.sgiims.com> wrote in message
>> news:u9dLVMJtFHA.460@.TK2MSFTNGP15.phx.gbl...
>>I got a windows XP pro with SQL 2000 SP4 installed. I'm trying to
>>install Reporting services, it tells me that it requires SP3a and wont
>>let me continue. I can't uninstall SP4. I installed it a while ago and
>>since it worked OK did not keep the backed up version of the databases
>>pre-SP4.
>> Anyone knows how I can get Reporting services installed on this
>> machine?
>> Thanks for any help.
>> Bob
>>
>>
>>
>|||Is the ASP.Net worker process running as the domain account or as the local
ASPNET account. If it is the local one does it have permissions to the
folder?
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Bob" <bdufour@.sgiims.com> wrote in message
news:uwL9dpKtFHA.2064@.TK2MSFTNGP09.phx.gbl...
> Thanks.
> Since I had nothing in the databases locally yet, I just completely
> uninstalled SQL and did a reinstall from scratch up to and including Sp3a.
> Now report server install ok and I also managed to install RS SP2.
> However when I call the URL localhost/reports I now get
> Access to the path "D:\Program Files\Microsoft SQL Server\MSSQL\Reporting
> Services\ReportManager\bin" is denied.
> Description: An unhandled exception occurred during the execution of the
> current web request. Please review the stack trace for more information
> about the error and where it originated in the code.
> Exception Details: System.UnauthorizedAccessException: Access to the path
> "D:\Program Files\Microsoft SQL Server\MSSQL\Reporting
> Services\ReportManager\bin" is denied.
> ASP.NET is not authorized to access the requested resource. Consider
> granting access rights to the resource to the ASP.NET request identity.
> ASP.NET has a base process identity (typically {MACHINE}\ASPNET on IIS 5
> or Network Service on IIS 6) that is used if the application is not
> impersonating. If the application is impersonating via <identity
> impersonate="true"/>, the identity will be the anonymous user (typically
> IUSR_MACHINENAME) or the authenticated request user.
> To grant ASP.NET write access to a file, right-click the file in Explorer,
> choose "Properties" and select the Security tab. Click "Add" to add the
> appropriate user or group. Highlight the ASP.NET account, and check the
> boxes for the desired access.
> Source Error:
>
> An unhandled exception was generated during the execution of the
> current web request. Information regarding the origin and location of the
> exception can be identified using the exception stack trace below.
>
> Stack Trace:
>
> [UnauthorizedAccessException: Access to the path "D:\Program
> Files\Microsoft SQL Server\MSSQL\Reporting Services\ReportManager\bin" is
> denied.]
> System.IO.__Error.WinIOError(Int32 errorCode, String str) +393
> System.IO.Directory.InternalGetFileDirectoryNames(String fullPath,
> String userPath, Boolean file) +229
> System.IO.Directory.InternalGetDirectories(String path, String userPath,
> String searchPattern) +24
> System.IO.Directory.GetDirectories(String path, String searchPattern)
> +477
> Microsoft.ReportingServices.Diagnostics.Localization.GetInstalledCultures()
> Microsoft.ReportingServices.Diagnostics.Localization..cctor()
> [TypeInitializationException: The type initializer for
> "Microsoft.ReportingServices.Diagnostics.Localization" threw an
> exception.]
> Microsoft.ReportingServices.Diagnostics.Localization.SetCultureFromPriorityList(String[]
> localeList) +0
> Microsoft.ReportingServices.UI.GlobalApp.Application_BeginRequest(Object
> sender, EventArgs e)
> System.Web.SyncEventExecutionStep.System.Web.HttpApplication+IExecutionStep.Execute()
> +60
> System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean&
> completedSynchronously) +87
>
>
> ----
> Version Information: Microsoft .NET Framework Version:1.1.4322.2032;
> ASP.NET Version:1.1.4322.2032
> I'm logged in with domain administrator privileges and the domain account
> domain.iwam_asp.net has full privileges to this folder. Any idea what I
> might need to do now to get this working.
> This Win XP pro is part of a small domain. Might this have something to do
> with it? The installation went OK this time.
> Thanks for any help,
> Bob
> "Daniel Reib [MSFT]" <danreib@.online.microsoft.com> wrote in message
> news:OEutF2JtFHA.908@.tk2msftngp13.phx.gbl...
>> This doesn't appear to be SP4 of SQL server. The results should be
>> Index Name Internal_Value Character_Value
>> -- -- -- --
>> 2 ProductVersion 524288 8.00.2039
>> RS setup looks for a value greater then 8.00.760. It will not allow you
>> to setup if this value is less. (For some situations we require 8.00.859
>> or greater). If you are sure you have SP4 installed then you would first
>> need to find out why the version number is not correct before you can
>> install RS.
>> --
>> -Daniel
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>> "Bob" <bdufour@.sgiims.com> wrote in message
>> news:OKsG7sJtFHA.4076@.TK2MSFTNGP11.phx.gbl...
>> Index = 2
>> Name = ProductVersion
>> InternalValue = 524288
>> Character_value = 8.00.194
>> Bob
>> "Daniel Reib [MSFT]" <danreib@.online.microsoft.com> wrote in message
>> news:ul0dddJtFHA.464@.TK2MSFTNGP15.phx.gbl...
>> What is the result of running the following TSQL:
>> master.dbo.xp_msver 'ProductVersion'
>>
>> --
>> -Daniel
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>> "Bob" <bdufour@.sgiims.com> wrote in message
>> news:u9dLVMJtFHA.460@.TK2MSFTNGP15.phx.gbl...
>>I got a windows XP pro with SQL 2000 SP4 installed. I'm trying to
>>install Reporting services, it tells me that it requires SP3a and wont
>>let me continue. I can't uninstall SP4. I installed it a while ago and
>>since it worked OK did not keep the backed up version of the databases
>>pre-SP4.
>> Anyone knows how I can get Reporting services installed on this
>> machine?
>> Thanks for any help.
>> Bob
>>
>>
>>
>>
>|||Both the ASPNET machine local account And the ASPNet account for the domain
have been given full rights to that folder. I even went in IIS and enabled
anonymous access and I still get same message.
Thanks again,
Bob
"Daniel Reib [MSFT]" <danreib@.online.microsoft.com> wrote in message
news:eLgesxKtFHA.3500@.TK2MSFTNGP09.phx.gbl...
> Is the ASP.Net worker process running as the domain account or as the
> local ASPNET account. If it is the local one does it have permissions to
> the folder?
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>
> "Bob" <bdufour@.sgiims.com> wrote in message
> news:uwL9dpKtFHA.2064@.TK2MSFTNGP09.phx.gbl...
>> Thanks.
>> Since I had nothing in the databases locally yet, I just completely
>> uninstalled SQL and did a reinstall from scratch up to and including
>> Sp3a. Now report server install ok and I also managed to install RS SP2.
>> However when I call the URL localhost/reports I now get
>> Access to the path "D:\Program Files\Microsoft SQL Server\MSSQL\Reporting
>> Services\ReportManager\bin" is denied.
>> Description: An unhandled exception occurred during the execution of the
>> current web request. Please review the stack trace for more information
>> about the error and where it originated in the code.
>> Exception Details: System.UnauthorizedAccessException: Access to the path
>> "D:\Program Files\Microsoft SQL Server\MSSQL\Reporting
>> Services\ReportManager\bin" is denied.
>> ASP.NET is not authorized to access the requested resource. Consider
>> granting access rights to the resource to the ASP.NET request identity.
>> ASP.NET has a base process identity (typically {MACHINE}\ASPNET on IIS 5
>> or Network Service on IIS 6) that is used if the application is not
>> impersonating. If the application is impersonating via <identity
>> impersonate="true"/>, the identity will be the anonymous user (typically
>> IUSR_MACHINENAME) or the authenticated request user.
>> To grant ASP.NET write access to a file, right-click the file in
>> Explorer, choose "Properties" and select the Security tab. Click "Add" to
>> add the appropriate user or group. Highlight the ASP.NET account, and
>> check the boxes for the desired access.
>> Source Error:
>>
>> An unhandled exception was generated during the execution of the
>> current web request. Information regarding the origin and location of the
>> exception can be identified using the exception stack trace below.
>>
>> Stack Trace:
>>
>> [UnauthorizedAccessException: Access to the path "D:\Program
>> Files\Microsoft SQL Server\MSSQL\Reporting Services\ReportManager\bin" is
>> denied.]
>> System.IO.__Error.WinIOError(Int32 errorCode, String str) +393
>> System.IO.Directory.InternalGetFileDirectoryNames(String fullPath,
>> String userPath, Boolean file) +229
>> System.IO.Directory.InternalGetDirectories(String path, String
>> userPath, String searchPattern) +24
>> System.IO.Directory.GetDirectories(String path, String searchPattern)
>> +477
>> Microsoft.ReportingServices.Diagnostics.Localization.GetInstalledCultures()
>> Microsoft.ReportingServices.Diagnostics.Localization..cctor()
>> [TypeInitializationException: The type initializer for
>> "Microsoft.ReportingServices.Diagnostics.Localization" threw an
>> exception.]
>> Microsoft.ReportingServices.Diagnostics.Localization.SetCultureFromPriorityList(String[]
>> localeList) +0
>> Microsoft.ReportingServices.UI.GlobalApp.Application_BeginRequest(Object
>> sender, EventArgs e)
>> System.Web.SyncEventExecutionStep.System.Web.HttpApplication+IExecutionStep.Execute()
>> +60
>> System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean&
>> completedSynchronously) +87
>>
>>
>> ----
>> Version Information: Microsoft .NET Framework Version:1.1.4322.2032;
>> ASP.NET Version:1.1.4322.2032
>> I'm logged in with domain administrator privileges and the domain account
>> domain.iwam_asp.net has full privileges to this folder. Any idea what I
>> might need to do now to get this working.
>> This Win XP pro is part of a small domain. Might this have something to
>> do with it? The installation went OK this time.
>> Thanks for any help,
>> Bob
>> "Daniel Reib [MSFT]" <danreib@.online.microsoft.com> wrote in message
>> news:OEutF2JtFHA.908@.tk2msftngp13.phx.gbl...
>> This doesn't appear to be SP4 of SQL server. The results should be
>> Index Name Internal_Value Character_Value
>> -- -- -- --
>> 2 ProductVersion 524288 8.00.2039
>> RS setup looks for a value greater then 8.00.760. It will not allow you
>> to setup if this value is less. (For some situations we require
>> 8.00.859 or greater). If you are sure you have SP4 installed then you
>> would first need to find out why the version number is not correct
>> before you can install RS.
>> --
>> -Daniel
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>> "Bob" <bdufour@.sgiims.com> wrote in message
>> news:OKsG7sJtFHA.4076@.TK2MSFTNGP11.phx.gbl...
>> Index = 2
>> Name = ProductVersion
>> InternalValue = 524288
>> Character_value = 8.00.194
>> Bob
>> "Daniel Reib [MSFT]" <danreib@.online.microsoft.com> wrote in message
>> news:ul0dddJtFHA.464@.TK2MSFTNGP15.phx.gbl...
>> What is the result of running the following TSQL:
>> master.dbo.xp_msver 'ProductVersion'
>>
>> --
>> -Daniel
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>> "Bob" <bdufour@.sgiims.com> wrote in message
>> news:u9dLVMJtFHA.460@.TK2MSFTNGP15.phx.gbl...
>>I got a windows XP pro with SQL 2000 SP4 installed. I'm trying to
>>install Reporting services, it tells me that it requires SP3a and wont
>>let me continue. I can't uninstall SP4. I installed it a while ago and
>>since it worked OK did not keep the backed up version of the databases
>>pre-SP4.
>> Anyone knows how I can get Reporting services installed on this
>> machine?
>> Thanks for any help.
>> Bob
>>
>>
>>
>>
>>
>