RS2003 Ent Install Failing

I get the following error when doing RSW2K3 ENT Installation on WS2K3 SP1
(DC) and SQL Server 2000 SP4 environment. There is no option to ignore the
Error 1603 message , the only option is to cancel and rollback the
installation.
There is a parsing error is in the "LoadRSCatalog" Function- (see end of log)
Has anyone seen this problem before, any suggestions greatefully
appreciated,
<Func Name='CService::~CService'>
Action 22:07:52: Do_sqlScript. Configuring Microsoft SQL Server
SQL_SUCCESS_WITH_INFO (1) in SQLDriverConnectW
sqlstate=01000, level=0, state=0, native_error=5701, msg=Changed database
context to 'master'.
sqlstate=01000, level=0, state=0, native_error=5703, msg=Changed language
setting to us_english.
use master
SQL_SUCCESS_WITH_INFO (1) in SQLExecDirectW
sqlstate=01000, level=0, state=1, native_error=5701, msg=Changed database
context to 'master'.
IF (DB_ID('ReportServer') IS NULL) BEGIN CREATE DATABASE ReportServer
COLLATE Latin1_General_CI_AS_KS_WS END
0
Action 22:07:52: Do_sqlScript. Configuring Microsoft SQL Server
Do_sqlScript: Running SQL Statement
SQL_SUCCESS_WITH_INFO (1) in SQLExecDirectW
sqlstate=01000, level=0, state=1, native_error=1805, msg=The CREATE DATABASE
process is allocating 0.63 MB on disk 'ReportServer'.
sqlstate=01000, level=0, state=1, native_error=1805, msg=The CREATE DATABASE
process is allocating 0.49 MB on disk 'ReportServer_log'.
ALTER DATABASE ReportServer SET RECOVERY FULL
0
IF CHARINDEX('\', 'NT AUTHORITY\NETWORK SERVICE') != 0 BEGIN EXEC
sp_grantlogin 'NT AUTHORITY\NETWORK SERVICE' END
0
SQL_SUCCESS_WITH_INFO (1) in SQLExecDirectW
sqlstate=01000, level=0, state=1, native_error=15481, msg=Granted login
access to 'NT AUTHORITY\NETWORK SERVICE'.
IF (DB_ID('ReportServerTempDB') IS NULL) BEGIN CREATE DATABASE
ReportServerTempDB COLLATE Latin1_General_CI_AS_KS_WS END
0
SQL_SUCCESS_WITH_INFO (1) in SQLExecDirectW
sqlstate=01000, level=0, state=1, native_error=1805, msg=The CREATE DATABASE
process is allocating 0.63 MB on disk 'ReportServerTempDB'.
sqlstate=01000, level=0, state=1, native_error=1805, msg=The CREATE DATABASE
process is allocating 0.49 MB on disk 'ReportServerTempDB_log'.
ALTER DATABASE ReportServerTempDB SET RECOVERY SIMPLE
0
use ReportServerTempDB
SQL_SUCCESS_WITH_INFO (1) in SQLExecDirectW
sqlstate=01000, level=0, state=1, native_error=5701, msg=Changed database
context to 'ReportServerTempDB'.
IF NOT EXISTS (SELECT * FROM dbo.sysusers WHERE name='RSExecRole' AND
issqlrole=1) EXEC sp_addrole 'RSExecRole'
0
SQL_SUCCESS_WITH_INFO (1) in SQLExecDirectW
sqlstate=01000, level=0, state=1, native_error=15424, msg=New role added.
DECLARE @.pname AS sysname DECLARE @.i AS INT IF LOWER('NT AUTHORITY\NETWORK
SERVICE') != 'sa' AND NOT EXISTS (SELECT db1.dbid FROM
master.dbo.sysdatabases AS db1, master.dbo.syslogins AS logins1 WHERE db1.sid
= logins1.sid AND logins1.name = 'NT AUTHORITY\NETWORK SERVICE' AND db1.name
= 'ReportServerTempDB') AND NOT EXISTS (SELECT users1.name FROM dbo.sysusers
AS users1, master.dbo.syslogins AS logins1 WHERE users1.sid = logins1.sid AND
logins1.name = 'NT AUTHORITY\NETWORK SERVICE') BEGIN SET @.i = 0 SET @.pname = 'NT AUTHORITY\NETWORK SERVICE' WHILE EXISTS (SELECT name FROM dbo.sysusers
WHERE name=@.pname) BEGIN SET @.i = @.i + 1 SET @.pname = @.pname +
CONVERT(NVARCHAR(10), @.i) END EXEC sp_grantdbaccess 'NT AUTHORITY\NETWORK
SERVICE', @.pname END
0
SQL_SUCCESS_WITH_INFO (1) in SQLExecDirectW
sqlstate=01000, level=0, state=1, native_error=15341, msg=Granted database
access to 'NT AUTHORITY\NETWORK SERVICE'.
DECLARE @.pname AS sysname IF LOWER('NT AUTHORITY\NETWORK SERVICE') != 'sa'
AND NOT EXISTS (SELECT db1.dbid FROM master.dbo.sysdatabases AS db1,
master.dbo.syslogins AS logins1 WHERE db1.sid = logins1.sid AND logins1.name
= 'NT AUTHORITY\NETWORK SERVICE' AND db1.name = 'ReportServerTempDB') BEGIN
SELECT @.pname = (SELECT users1.name FROM dbo.sysusers AS users1,
master.dbo.syslogins AS logins1 WHERE users1.sid = logins1.sid AND
logins1.name = 'NT AUTHORITY\NETWORK SERVICE') EXEC sp_addrolemember
'RSExecRole', @.pname END
0
SQL_SUCCESS_WITH_INFO (1) in SQLExecDirectW
sqlstate=01000, level=0, state=1, native_error=15488, msg='NT
AUTHORITY\NETWORK SERVICE' added to role 'RSExecRole'.
D:\Program Files\Microsoft SQL Server\MSSQL\Reporting
Services\ReportServer\CatalogTempDB.sql
17
Action 22:07:52: Do_sqlScript. Configuring Microsoft SQL Server
Do_sqlScript: Running SQL Script: D:\Program Files\Microsoft SQL
Server\MSSQL\Reporting Services\ReportServer\CatalogTempDB.sql
<Func Name='LoadRSCatalog'>
error parsing script file D:\Program Files\Microsoft SQL
Server\MSSQL\Reporting Services\ReportServer\CatalogTempDB.sql: 87
Error 29525. SQL Setup failed to execute a command for server configuration.
Refer to the Server error logs and setup logs for detailed error information.
MSI (s) (F4!C8) [22:08:37:874]: Product: Microsoft SQL Server 2000 Reporting
Services Enterprise Edition -- Error 29525. SQL Setup failed to execute a
command for server configuration. Refer to the Server error logs and setup
logs for detailed error information.
<EndFunc Name='SqlScriptHlpr' Return='1603' GetLastError='0'>
<EndFunc Name='Do_sqlScript' Return='1603' GetLastError='0'>
Gathering darwin properties for failure handling.
<Func Name='DisplayErrorDialog'>
regardsIts RS2000 Enterprise Edition not RSY2K3 ENT.
"Graham Smith" wrote:
> I get the following error when doing RSW2K3 ENT Installation on WS2K3 SP1
> (DC) and SQL Server 2000 SP4 environment. There is no option to ignore the
> Error 1603 message , the only option is to cancel and rollback the
> installation.
> There is a parsing error is in the "LoadRSCatalog" Function- (see end of log)
> Has anyone seen this problem before, any suggestions greatefully
> appreciated,
>
> <Func Name='CService::~CService'>
> Action 22:07:52: Do_sqlScript. Configuring Microsoft SQL Server
> SQL_SUCCESS_WITH_INFO (1) in SQLDriverConnectW
> sqlstate=01000, level=0, state=0, native_error=5701, msg=Changed database
> context to 'master'.
> sqlstate=01000, level=0, state=0, native_error=5703, msg=Changed language
> setting to us_english.
> use master
> SQL_SUCCESS_WITH_INFO (1) in SQLExecDirectW
> sqlstate=01000, level=0, state=1, native_error=5701, msg=Changed database
> context to 'master'.
> IF (DB_ID('ReportServer') IS NULL) BEGIN CREATE DATABASE ReportServer
> COLLATE Latin1_General_CI_AS_KS_WS END
> 0
> Action 22:07:52: Do_sqlScript. Configuring Microsoft SQL Server
> Do_sqlScript: Running SQL Statement
> SQL_SUCCESS_WITH_INFO (1) in SQLExecDirectW
> sqlstate=01000, level=0, state=1, native_error=1805, msg=The CREATE DATABASE
> process is allocating 0.63 MB on disk 'ReportServer'.
> sqlstate=01000, level=0, state=1, native_error=1805, msg=The CREATE DATABASE
> process is allocating 0.49 MB on disk 'ReportServer_log'.
> ALTER DATABASE ReportServer SET RECOVERY FULL
> 0
> IF CHARINDEX('\', 'NT AUTHORITY\NETWORK SERVICE') != 0 BEGIN EXEC
> sp_grantlogin 'NT AUTHORITY\NETWORK SERVICE' END
> 0
> SQL_SUCCESS_WITH_INFO (1) in SQLExecDirectW
> sqlstate=01000, level=0, state=1, native_error=15481, msg=Granted login
> access to 'NT AUTHORITY\NETWORK SERVICE'.
> IF (DB_ID('ReportServerTempDB') IS NULL) BEGIN CREATE DATABASE
> ReportServerTempDB COLLATE Latin1_General_CI_AS_KS_WS END
> 0
> SQL_SUCCESS_WITH_INFO (1) in SQLExecDirectW
> sqlstate=01000, level=0, state=1, native_error=1805, msg=The CREATE DATABASE
> process is allocating 0.63 MB on disk 'ReportServerTempDB'.
> sqlstate=01000, level=0, state=1, native_error=1805, msg=The CREATE DATABASE
> process is allocating 0.49 MB on disk 'ReportServerTempDB_log'.
> ALTER DATABASE ReportServerTempDB SET RECOVERY SIMPLE
> 0
> use ReportServerTempDB
> SQL_SUCCESS_WITH_INFO (1) in SQLExecDirectW
> sqlstate=01000, level=0, state=1, native_error=5701, msg=Changed database
> context to 'ReportServerTempDB'.
> IF NOT EXISTS (SELECT * FROM dbo.sysusers WHERE name='RSExecRole' AND
> issqlrole=1) EXEC sp_addrole 'RSExecRole'
> 0
> SQL_SUCCESS_WITH_INFO (1) in SQLExecDirectW
> sqlstate=01000, level=0, state=1, native_error=15424, msg=New role added.
> DECLARE @.pname AS sysname DECLARE @.i AS INT IF LOWER('NT AUTHORITY\NETWORK
> SERVICE') != 'sa' AND NOT EXISTS (SELECT db1.dbid FROM
> master.dbo.sysdatabases AS db1, master.dbo.syslogins AS logins1 WHERE db1.sid
> = logins1.sid AND logins1.name = 'NT AUTHORITY\NETWORK SERVICE' AND db1.name
> = 'ReportServerTempDB') AND NOT EXISTS (SELECT users1.name FROM dbo.sysusers
> AS users1, master.dbo.syslogins AS logins1 WHERE users1.sid = logins1.sid AND
> logins1.name = 'NT AUTHORITY\NETWORK SERVICE') BEGIN SET @.i = 0 SET @.pname => 'NT AUTHORITY\NETWORK SERVICE' WHILE EXISTS (SELECT name FROM dbo.sysusers
> WHERE name=@.pname) BEGIN SET @.i = @.i + 1 SET @.pname = @.pname +
> CONVERT(NVARCHAR(10), @.i) END EXEC sp_grantdbaccess 'NT AUTHORITY\NETWORK
> SERVICE', @.pname END
> 0
> SQL_SUCCESS_WITH_INFO (1) in SQLExecDirectW
> sqlstate=01000, level=0, state=1, native_error=15341, msg=Granted database
> access to 'NT AUTHORITY\NETWORK SERVICE'.
> DECLARE @.pname AS sysname IF LOWER('NT AUTHORITY\NETWORK SERVICE') != 'sa'
> AND NOT EXISTS (SELECT db1.dbid FROM master.dbo.sysdatabases AS db1,
> master.dbo.syslogins AS logins1 WHERE db1.sid = logins1.sid AND logins1.name
> = 'NT AUTHORITY\NETWORK SERVICE' AND db1.name = 'ReportServerTempDB') BEGIN
> SELECT @.pname = (SELECT users1.name FROM dbo.sysusers AS users1,
> master.dbo.syslogins AS logins1 WHERE users1.sid = logins1.sid AND
> logins1.name = 'NT AUTHORITY\NETWORK SERVICE') EXEC sp_addrolemember
> 'RSExecRole', @.pname END
> 0
> SQL_SUCCESS_WITH_INFO (1) in SQLExecDirectW
> sqlstate=01000, level=0, state=1, native_error=15488, msg='NT
> AUTHORITY\NETWORK SERVICE' added to role 'RSExecRole'.
> D:\Program Files\Microsoft SQL Server\MSSQL\Reporting
> Services\ReportServer\CatalogTempDB.sql
> 17
> Action 22:07:52: Do_sqlScript. Configuring Microsoft SQL Server
> Do_sqlScript: Running SQL Script: D:\Program Files\Microsoft SQL
> Server\MSSQL\Reporting Services\ReportServer\CatalogTempDB.sql
> <Func Name='LoadRSCatalog'>
> error parsing script file D:\Program Files\Microsoft SQL
> Server\MSSQL\Reporting Services\ReportServer\CatalogTempDB.sql: 87
> Error 29525. SQL Setup failed to execute a command for server configuration.
> Refer to the Server error logs and setup logs for detailed error information.
> MSI (s) (F4!C8) [22:08:37:874]: Product: Microsoft SQL Server 2000 Reporting
> Services Enterprise Edition -- Error 29525. SQL Setup failed to execute a
> command for server configuration. Refer to the Server error logs and setup
> logs for detailed error information.
> <EndFunc Name='SqlScriptHlpr' Return='1603' GetLastError='0'>
> <EndFunc Name='Do_sqlScript' Return='1603' GetLastError='0'>
> Gathering darwin properties for failure handling.
> <Func Name='DisplayErrorDialog'>
> regards
>

RS on Win2000 Server : Urgent help needed

Hello all
I have been having troubles installing RS Ent Edition on Win2000
server.
I tried with sql authentication and also NT/System account but always
get the error in the end saying
"could not activate RS. Have to activate manually before using"
I tried with rsactivate.exe but no progress.
Is there anything i am missing or blunderin here ?
the Win2k server is SP4
SQL server has Sp3a installed
Its a production server outside my domain and I only want to deploy my
reports there. So I didnt install VS.NET. can that be the problem ?
I currently have a development env where I have RS and SQL Server on
two diff Win2003 server boxes in the same domain.
What i am trying to achieve is to develop on my machine and deploy to
the RS on the production server.
Any suggestions will be sincerely appreciated.
Thx
BofoMaybe the rsactivate and rsconfig are using two different accounts. The
ReportServer service may also be using a different account that the
rsactivate and rsconfig.
"RemoteDeploy" wrote:
> Hello all
> I have been having troubles installing RS Ent Edition on Win2000
> server.
> I tried with sql authentication and also NT/System account but always
> get the error in the end saying
> "could not activate RS. Have to activate manually before using"
> I tried with rsactivate.exe but no progress.
> Is there anything i am missing or blunderin here ?
> the Win2k server is SP4
> SQL server has Sp3a installed
> Its a production server outside my domain and I only want to deploy my
> reports there. So I didnt install VS.NET. can that be the problem ?
> I currently have a development env where I have RS and SQL Server on
> two diff Win2003 server boxes in the same domain.
> What i am trying to achieve is to develop on my machine and deploy to
> the RS on the production server.
> Any suggestions will be sincerely appreciated.
> Thx
> Bofo
>