Wednesday, March 21, 2012

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
>

No comments:

Post a Comment