2009/02/27 15:34:04 rs_init/12.6/EBF 14709 ESD#9/Intel Itanium/HP-UX B.11.23/1/OPT/Mon Jun 11 22:36:01 2007 2009/02/27 15:34:04 Confidential property of Sybase, Inc. Copyright 1992, 2007 Sybase, Inc. All rights reserved. Unpublished rights reserved under U.S. copyright laws. This software contains confidential and trade secret information of Sybase, Inc. Use, duplication or disclosure of the software and documentation by the U.S. Government is subject to restrictions set forth in a license agreement between the Government and Sybase, Inc. or other written agreement specifying the Government's rights to use the software and any applicable FAR provisions, for example, FAR 52.227-19. Sybase, Inc. One Sybase Drive, Dublin, CA 94568, USA 2009/02/27 15:34:04 BEGIN ENVIRONMENT INFORMATION USER ENVIRONMENT ---------------------------------------- user name: sybase current directory: /opt/sybase/REP-12_6/install character set: iso_1 language: us_english Component Directory: /opt/sybase/REP-12_6 working release directory: /opt/sybase 2009/02/27 15:34:04 END ENVIRONMENT INFORMATION 2009/02/27 15:34:04 Directory service provider: 'InterfacesDriver'. 2009/02/27 15:44:15 Running task: check the SQL Server. 2009/02/27 15:44:15 Task succeeded: check the SQL Server. 2009/02/27 15:44:15 Running task: verify users and their passwords. 2009/02/27 15:44:15 Verified that 'REP_SRV_ra' can log into Replication Server 'REP_SRV'. 2009/02/27 15:44:15 Verified that 'sa' can log into Replication Server 'REP_SRV'. 2009/02/27 15:44:15 Task succeeded: verify users and their passwords. 2009/02/27 15:44:15 Running task: check the database. 2009/02/27 15:44:15 Verified that database 'BASE_001' exists. 2009/02/27 15:44:15 Sending the following SQL command to the server: 'dbcc is_replication_enabled'. 2009/02/27 15:44:15 Verified that SQL Server 'DS_PROD' supports replication. 2009/02/27 15:44:15 Sending the following SQL command to the server: 'use master'. 2009/02/27 15:44:15 Sending the following SQL command to the server: 'use master'. 2009/02/27 15:44:15 Sending the following SQL command to the server: 'if exists (select * from sysobjects where name = 'rs_install_sql_proc_1') drop procedure rs_install_sql_proc_1'. 2009/02/27 15:44:15 Sending the following SQL command to the server: 'if exists (select * from sysobjects where name = 'rs_install_sql_proc_2') drop procedure rs_install_sql_proc_2'. 2009/02/27 15:44:15 Sending the following SQL command to the server: 'use BASE_001'. 2009/02/27 15:44:15 Sending the following SQL command to the server: 'if exists (select * from sysobjects where name = 'rs_install_sql_proc_2') drop procedure rs_install_sql_proc_2'. 2009/02/27 15:44:15 Sending the following SQL command to the server: 'use master'. 2009/02/27 15:44:15 Sending the following SQL command to the server: 'create procedure rs_install_sql_proc_1 as if exists (select name from syslogins where name = "BASE_001_maint") begin if exists (select * from BASE_001..sysusers, syslogins where BASE_001..sysusers.name = "BASE_001_maint" and BASE_001..sysusers.suid = syslogins.suid and (BASE_001..sysusers.name = syslogins.name or BASE_001..sysusers.uid = 1)) return 1 else begin if exists (select name from syslogins, BASE_001..sysalternates where syslogins.name = "BASE_001_maint" and syslogins.suid = BASE_001..sysalternates.suid) return 2 else return 3 end end else return 4'. 2009/02/27 15:44:15 Sending the following SQL command to the server: 'exec rs_install_sql_proc_1'. 2009/02/27 15:44:15 Verified that the maintenance user 'BASE_001_maint' is defined in database 'BASE_001'. 2009/02/27 15:44:15 Sending the following SQL command to the server: 'use master'. 2009/02/27 15:44:15 Sending the following SQL command to the server: 'if exists (select * from sysobjects where name = 'rs_install_sql_proc_1') drop procedure rs_install_sql_proc_1'. 2009/02/27 15:44:15 Sending the following SQL command to the server: 'if exists (select * from sysobjects where name = 'rs_install_sql_proc_2') drop procedure rs_install_sql_proc_2'. 2009/02/27 15:44:15 Sending the following SQL command to the server: 'use BASE_001'. 2009/02/27 15:44:15 Sending the following SQL command to the server: 'if exists (select * from sysobjects where name = 'rs_install_sql_proc_2') drop procedure rs_install_sql_proc_2'. 2009/02/27 15:44:15 Sending the following SQL command to the server: 'use master'. 2009/02/27 15:44:15 Sending the following SQL command to the server: 'use master'. 2009/02/27 15:44:15 Sending the following SQL command to the server: 'if exists (select * from sysobjects where name = 'rs_install_sql_proc_1') drop procedure rs_install_sql_proc_1'. 2009/02/27 15:44:15 Sending the following SQL command to the server: 'if exists (select * from sysobjects where name = 'rs_install_sql_proc_2') drop procedure rs_install_sql_proc_2'. 2009/02/27 15:44:15 Sending the following SQL command to the server: 'use BASE_001'. 2009/02/27 15:44:15 Sending the following SQL command to the server: 'if exists (select * from sysobjects where name = 'rs_install_sql_proc_2') drop procedure rs_install_sql_proc_2'. 2009/02/27 15:44:15 Sending the following SQL command to the server: 'use master'. 2009/02/27 15:44:15 Verified that maintenance user 'BASE_001_maint' can log into SQL Server 'DS_PROD'. 2009/02/27 15:44:15 Task succeeded: check the database. 2009/02/27 15:44:15 Running task: configure database for primary data. 2009/02/27 15:44:15 Loading script 'rs_install_primary.sql' into database 'BASE_001'. 2009/02/27 15:44:15 Sending the following SQL command to the server: 'use BASE_001'. 2009/02/27 15:44:16 Done 2009/02/27 15:44:16 Loaded script 'rs_install_primary.sql' successfully. 2009/02/27 15:44:16 Granting permissions on the lastcommit functions and rs_marker. 2009/02/27 15:44:16 Sending the following SQL command to the server: 'grant execute on rs_update_lastcommit to PUBLIC'. 2009/02/27 15:44:16 Sending the following SQL command to the server: 'grant execute on rs_marker to PUBLIC'. 2009/02/27 15:44:16 Sending the following SQL command to the server: 'grant execute on rs_check_repl_stat to PUBLIC'. 2009/02/27 15:44:16 Granting permissions on the lastcommit functions. 2009/02/27 15:44:16 Sending the following SQL command to the server: 'sp_setreplicate rs_lastcommit,false'. 2009/02/27 15:44:16 SQL Server message: msg 17962, level 16, state 1 2009/02/27 15:44:18 WARNING: "The replication status for 'rs_lastcommit' is already set to false. Replication status for 'rs_lastcommit' does not change." 2009/02/27 15:44:18 Sending the following SQL command to the server: 'sp_setreplicate rs_update_lastcommit,true'. 2009/02/27 15:44:18 Sending the following SQL command to the server: 'grant execute on rs_get_lastcommit to BASE_001_maint'. 2009/02/27 15:44:18 Sending the following SQL command to the server: 'grant all on rs_lastcommit to BASE_001_maint'. 2009/02/27 15:44:18 Granted maintenance user permissions on the lastcommit functions and rs_marker. 2009/02/27 15:44:18 Sending the following SQL command to the server: 'sp_role "grant", replication_role, BASE_001_maint'. 2009/02/27 15:44:18 Granted replication role to maintenance user 2009/02/27 15:44:18 Task succeeded: configure database for primary data. 2009/02/27 15:44:18 Running task: configure the Replication Agent. 2009/02/27 15:44:18 Sending the following SQL command to the server: 'use BASE_001'. 2009/02/27 15:44:18 Sending the following SQL command to the server: 'exec sp_config_rep_agent "BASE_001", enable,"REP_SRV", "REP_SRV_ra", "REP_SRV_ra_ps"'. 2009/02/27 15:44:18 Sending the following SQL command to the server: 'exec sp_config_rep_agent "BASE_001", "send warm",true '. 2009/02/27 15:44:18 Task succeeded: configure the Replication Agent. 2009/02/27 15:44:18 Running task: set connection to the database. 2009/02/27 15:44:18 Adding database 'BASE_001' to the replication system. 2009/02/27 15:44:18 Sending the following SQL command to the server: 'admin version'. 2009/02/27 15:44:18 Sending the following SQL command to the server: 'admin logical_status,"DS_PROD","BASE_001"'. 2009/02/27 15:44:18 Sending the following SQL command to the server: 'drop connection to "DS_PROD"."BASE_001"'. 2009/02/27 15:44:18 Sending the following SQL command to the server: 'create connection to "DS_PROD"."BASE_001" set error class rs_sqlserver_error_class set function string class rs_sqlserver_function_class set username "BASE_001_maint" set password "BASE_001_maint_ps" with log transfer on as active for "L_DS_PROD"."L_BASE_001"'. 2009/02/27 15:44:18 SQL Server message: msg 15223, level 12, state 0 2009/02/27 15:44:20 WARNING: "Active database or logical connection to L_DS_PROD.L_BASE_001 does not exist or is not controlled by this site" 2009/02/27 15:44:33 Unable to execute query 'create connection to "DS_PROD"."BASE_001" set error class rs_sqlserver_error_class set function string class rs_sqlserver_function_class set username "BASE_001_maint" set password "BASE_001_maint_ps" with log transfer on as active for "L_DS_PROD"."L_BASE_001"' against server 'REP_SRV'. 2009/02/27 15:44:33 Task failed: set connection to the database. Terminating configuration. 2009/02/27 15:44:34 Configuration failed. 2009/02/27 15:45:30 Running task: check the SQL Server. 2009/02/27 15:45:30 Task succeeded: check the SQL Server. 2009/02/27 15:45:30 Running task: verify users and their passwords. 2009/02/27 15:45:30 Verified that 'REP_SRV_ra' can log into Replication Server 'REP_SRV'. 2009/02/27 15:45:30 Verified that 'sa' can log into Replication Server 'REP_SRV'. 2009/02/27 15:45:30 Task succeeded: verify users and their passwords. 2009/02/27 15:45:30 Running task: check the database. 2009/02/27 15:45:30 Verified that database 'BASE_001' exists. 2009/02/27 15:45:30 Sending the following SQL command to the server: 'dbcc is_replication_enabled'. 2009/02/27 15:45:30 Verified that SQL Server 'DS_PROD' supports replication. 2009/02/27 15:45:30 Sending the following SQL command to the server: 'use master'. 2009/02/27 15:45:30 Sending the following SQL command to the server: 'use master'. 2009/02/27 15:45:30 Sending the following SQL command to the server: 'if exists (select * from sysobjects where name = 'rs_install_sql_proc_1') drop procedure rs_install_sql_proc_1'. 2009/02/27 15:45:30 Sending the following SQL command to the server: 'if exists (select * from sysobjects where name = 'rs_install_sql_proc_2') drop procedure rs_install_sql_proc_2'. 2009/02/27 15:45:30 Sending the following SQL command to the server: 'use BASE_001'. 2009/02/27 15:45:30 Sending the following SQL command to the server: 'if exists (select * from sysobjects where name = 'rs_install_sql_proc_2') drop procedure rs_install_sql_proc_2'. 2009/02/27 15:45:30 Sending the following SQL command to the server: 'use master'. 2009/02/27 15:45:30 Sending the following SQL command to the server: 'create procedure rs_install_sql_proc_1 as if exists (select name from syslogins where name = "BASE_001_maint") begin if exists (select * from BASE_001..sysusers, syslogins where BASE_001..sysusers.name = "BASE_001_maint" and BASE_001..sysusers.suid = syslogins.suid and (BASE_001..sysusers.name = syslogins.name or BASE_001..sysusers.uid = 1)) return 1 else begin if exists (select name from syslogins, BASE_001..sysalternates where syslogins.name = "BASE_001_maint" and syslogins.suid = BASE_001..sysalternates.suid) return 2 else return 3 end end else return 4'. 2009/02/27 15:45:30 Sending the following SQL command to the server: 'exec rs_install_sql_proc_1'. 2009/02/27 15:45:30 Verified that the maintenance user 'BASE_001_maint' is defined in database 'BASE_001'. 2009/02/27 15:45:30 Sending the following SQL command to the server: 'use master'. 2009/02/27 15:45:30 Sending the following SQL command to the server: 'if exists (select * from sysobjects where name = 'rs_install_sql_proc_1') drop procedure rs_install_sql_proc_1'. 2009/02/27 15:45:30 Sending the following SQL command to the server: 'if exists (select * from sysobjects where name = 'rs_install_sql_proc_2') drop procedure rs_install_sql_proc_2'. 2009/02/27 15:45:30 Sending the following SQL command to the server: 'use BASE_001'. 2009/02/27 15:45:30 Sending the following SQL command to the server: 'if exists (select * from sysobjects where name = 'rs_install_sql_proc_2') drop procedure rs_install_sql_proc_2'. 2009/02/27 15:45:30 Sending the following SQL command to the server: 'use master'. 2009/02/27 15:45:30 Sending the following SQL command to the server: 'use master'. 2009/02/27 15:45:30 Sending the following SQL command to the server: 'if exists (select * from sysobjects where name = 'rs_install_sql_proc_1') drop procedure rs_install_sql_proc_1'. 2009/02/27 15:45:30 Sending the following SQL command to the server: 'if exists (select * from sysobjects where name = 'rs_install_sql_proc_2') drop procedure rs_install_sql_proc_2'. 2009/02/27 15:45:30 Sending the following SQL command to the server: 'use BASE_001'. 2009/02/27 15:45:30 Sending the following SQL command to the server: 'if exists (select * from sysobjects where name = 'rs_install_sql_proc_2') drop procedure rs_install_sql_proc_2'. 2009/02/27 15:45:30 Sending the following SQL command to the server: 'use master'. 2009/02/27 15:45:30 Verified that maintenance user 'BASE_001_maint' can log into SQL Server 'DS_PROD'. 2009/02/27 15:45:30 Task succeeded: check the database. 2009/02/27 15:45:30 Running task: configure database for primary data. 2009/02/27 15:45:30 Loading script 'rs_install_primary.sql' into database 'BASE_001'. 2009/02/27 15:45:30 Sending the following SQL command to the server: 'use BASE_001'. 2009/02/27 15:45:30 Done 2009/02/27 15:45:30 Loaded script 'rs_install_primary.sql' successfully. 2009/02/27 15:45:30 Granting permissions on the lastcommit functions and rs_marker. 2009/02/27 15:45:30 Sending the following SQL command to the server: 'grant execute on rs_update_lastcommit to PUBLIC'. 2009/02/27 15:45:30 Sending the following SQL command to the server: 'grant execute on rs_marker to PUBLIC'. 2009/02/27 15:45:30 Sending the following SQL command to the server: 'grant execute on rs_check_repl_stat to PUBLIC'. 2009/02/27 15:45:30 Granting permissions on the lastcommit functions. 2009/02/27 15:45:30 Sending the following SQL command to the server: 'sp_setreplicate rs_lastcommit,false'. 2009/02/27 15:45:30 SQL Server message: msg 17962, level 16, state 1 2009/02/27 15:45:32 WARNING: "The replication status for 'rs_lastcommit' is already set to false. Replication status for 'rs_lastcommit' does not change." 2009/02/27 15:45:32 Sending the following SQL command to the server: 'sp_setreplicate rs_update_lastcommit,true'. 2009/02/27 15:45:32 Sending the following SQL command to the server: 'grant execute on rs_get_lastcommit to BASE_001_maint'. 2009/02/27 15:45:32 Sending the following SQL command to the server: 'grant all on rs_lastcommit to BASE_001_maint'. 2009/02/27 15:45:32 Granted maintenance user permissions on the lastcommit functions and rs_marker. 2009/02/27 15:45:32 Sending the following SQL command to the server: 'sp_role "grant", replication_role, BASE_001_maint'. 2009/02/27 15:45:32 Granted replication role to maintenance user 2009/02/27 15:45:32 Task succeeded: configure database for primary data. 2009/02/27 15:45:32 Running task: configure the Replication Agent. 2009/02/27 15:45:32 Sending the following SQL command to the server: 'use BASE_001'. 2009/02/27 15:45:32 Sending the following SQL command to the server: 'exec sp_config_rep_agent "BASE_001", enable,"REP_SRV", "REP_SRV_ra", "REP_SRV_ra_ps"'. 2009/02/27 15:45:32 SQL Server message: msg 18382, level 16, state 1 2009/02/27 15:45:34 WARNING: "Database 'BASE_001' is already configured to use Replication Agent. Request to enable Replication Agent has been ignored." 2009/02/27 15:45:38 Unable to execute query 'exec sp_config_rep_agent "BASE_001", enable,"REP_SRV", "REP_SRV_ra", "REP_SRV_ra_ps"' against server 'DS_PROD'. 2009/02/27 15:45:58 Task failed: configure the Replication Agent. Terminating configuration. 2009/02/27 15:45:59 Configuration failed. 2009/02/27 15:49:14 Running task: check the SQL Server. 2009/02/27 15:49:14 Task succeeded: check the SQL Server. 2009/02/27 15:49:14 Running task: verify users and their passwords. 2009/02/27 15:49:14 Verified that 'REP_SRV_ra' can log into Replication Server 'REP_SRV'. 2009/02/27 15:49:14 Verified that 'sa' can log into Replication Server 'REP_SRV'. 2009/02/27 15:49:14 Task succeeded: verify users and their passwords. 2009/02/27 15:49:14 Running task: check the database. 2009/02/27 15:49:14 Verified that database 'BASE_001' exists. 2009/02/27 15:49:14 Sending the following SQL command to the server: 'dbcc is_replication_enabled'. 2009/02/27 15:49:14 Verified that SQL Server 'DS_PROD' supports replication. 2009/02/27 15:49:14 Sending the following SQL command to the server: 'use master'. 2009/02/27 15:49:14 Sending the following SQL command to the server: 'use master'. 2009/02/27 15:49:14 Sending the following SQL command to the server: 'if exists (select * from sysobjects where name = 'rs_install_sql_proc_1') drop procedure rs_install_sql_proc_1'. 2009/02/27 15:49:14 Sending the following SQL command to the server: 'if exists (select * from sysobjects where name = 'rs_install_sql_proc_2') drop procedure rs_install_sql_proc_2'. 2009/02/27 15:49:14 Sending the following SQL command to the server: 'use BASE_001'. 2009/02/27 15:49:14 Sending the following SQL command to the server: 'if exists (select * from sysobjects where name = 'rs_install_sql_proc_2') drop procedure rs_install_sql_proc_2'. 2009/02/27 15:49:14 Sending the following SQL command to the server: 'use master'. 2009/02/27 15:49:14 Sending the following SQL command to the server: 'create procedure rs_install_sql_proc_1 as if exists (select name from syslogins where name = "BASE_001_maint") begin if exists (select * from BASE_001..sysusers, syslogins where BASE_001..sysusers.name = "BASE_001_maint" and BASE_001..sysusers.suid = syslogins.suid and (BASE_001..sysusers.name = syslogins.name or BASE_001..sysusers.uid = 1)) return 1 else begin if exists (select name from syslogins, BASE_001..sysalternates where syslogins.name = "BASE_001_maint" and syslogins.suid = BASE_001..sysalternates.suid) return 2 else return 3 end end else return 4'. 2009/02/27 15:49:14 Sending the following SQL command to the server: 'exec rs_install_sql_proc_1'. 2009/02/27 15:49:14 Verified that the maintenance user 'BASE_001_maint' is defined in database 'BASE_001'. 2009/02/27 15:49:14 Sending the following SQL command to the server: 'use master'. 2009/02/27 15:49:14 Sending the following SQL command to the server: 'if exists (select * from sysobjects where name = 'rs_install_sql_proc_1') drop procedure rs_install_sql_proc_1'. 2009/02/27 15:49:14 Sending the following SQL command to the server: 'if exists (select * from sysobjects where name = 'rs_install_sql_proc_2') drop procedure rs_install_sql_proc_2'. 2009/02/27 15:49:14 Sending the following SQL command to the server: 'use BASE_001'. 2009/02/27 15:49:14 Sending the following SQL command to the server: 'if exists (select * from sysobjects where name = 'rs_install_sql_proc_2') drop procedure rs_install_sql_proc_2'. 2009/02/27 15:49:14 Sending the following SQL command to the server: 'use master'. 2009/02/27 15:49:14 Sending the following SQL command to the server: 'use master'. 2009/02/27 15:49:14 Sending the following SQL command to the server: 'if exists (select * from sysobjects where name = 'rs_install_sql_proc_1') drop procedure rs_install_sql_proc_1'. 2009/02/27 15:49:14 Sending the following SQL command to the server: 'if exists (select * from sysobjects where name = 'rs_install_sql_proc_2') drop procedure rs_install_sql_proc_2'. 2009/02/27 15:49:14 Sending the following SQL command to the server: 'use BASE_001'. 2009/02/27 15:49:14 Sending the following SQL command to the server: 'if exists (select * from sysobjects where name = 'rs_install_sql_proc_2') drop procedure rs_install_sql_proc_2'. 2009/02/27 15:49:14 Sending the following SQL command to the server: 'use master'. 2009/02/27 15:49:14 Verified that maintenance user 'BASE_001_maint' can log into SQL Server 'DS_PROD'. 2009/02/27 15:49:14 Task succeeded: check the database. 2009/02/27 15:49:14 Running task: configure database for primary data. 2009/02/27 15:49:14 Loading script 'rs_install_primary.sql' into database 'BASE_001'. 2009/02/27 15:49:14 Sending the following SQL command to the server: 'use BASE_001'. 2009/02/27 15:49:14 Done 2009/02/27 15:49:14 Loaded script 'rs_install_primary.sql' successfully. 2009/02/27 15:49:14 Granting permissions on the lastcommit functions and rs_marker. 2009/02/27 15:49:14 Sending the following SQL command to the server: 'grant execute on rs_update_lastcommit to PUBLIC'. 2009/02/27 15:49:14 Sending the following SQL command to the server: 'grant execute on rs_marker to PUBLIC'. 2009/02/27 15:49:14 Sending the following SQL command to the server: 'grant execute on rs_check_repl_stat to PUBLIC'. 2009/02/27 15:49:14 Granting permissions on the lastcommit functions. 2009/02/27 15:49:14 Sending the following SQL command to the server: 'sp_setreplicate rs_lastcommit,false'. 2009/02/27 15:49:14 SQL Server message: msg 17962, level 16, state 1 2009/02/27 15:49:16 WARNING: "The replication status for 'rs_lastcommit' is already set to false. Replication status for 'rs_lastcommit' does not change." 2009/02/27 15:49:16 Sending the following SQL command to the server: 'sp_setreplicate rs_update_lastcommit,true'. 2009/02/27 15:49:16 Sending the following SQL command to the server: 'grant execute on rs_get_lastcommit to BASE_001_maint'. 2009/02/27 15:49:16 Sending the following SQL command to the server: 'grant all on rs_lastcommit to BASE_001_maint'. 2009/02/27 15:49:16 Granted maintenance user permissions on the lastcommit functions and rs_marker. 2009/02/27 15:49:16 Sending the following SQL command to the server: 'sp_role "grant", replication_role, BASE_001_maint'. 2009/02/27 15:49:16 Granted replication role to maintenance user 2009/02/27 15:49:16 Task succeeded: configure database for primary data. 2009/02/27 15:49:16 Running task: configure the Replication Agent. 2009/02/27 15:49:16 Sending the following SQL command to the server: 'use BASE_001'. 2009/02/27 15:49:16 Sending the following SQL command to the server: 'exec sp_config_rep_agent "BASE_001", enable,"REP_SRV", "REP_SRV_ra", "REP_SRV_ra_ps"'. 2009/02/27 15:49:16 Sending the following SQL command to the server: 'exec sp_config_rep_agent "BASE_001", "send warm",true '. 2009/02/27 15:49:16 Task succeeded: configure the Replication Agent. 2009/02/27 15:49:16 Running task: set connection to the database. 2009/02/27 15:49:16 Adding database 'BASE_001' to the replication system. 2009/02/27 15:49:16 Sending the following SQL command to the server: 'admin version'. 2009/02/27 15:49:16 Sending the following SQL command to the server: 'admin logical_status,"DS_PROD","BASE_001"'. 2009/02/27 15:49:16 Sending the following SQL command to the server: 'drop connection to "DS_PROD"."BASE_001"'. 2009/02/27 15:49:16 Sending the following SQL command to the server: 'create connection to "DS_PROD"."BASE_001" set error class rs_sqlserver_error_class set function string class rs_sqlserver_function_class set username "BASE_001_maint" set password "BASE_001_maint_ps" with log transfer on as active for "L_DS_PROD"."L_BASE_001"'. 2009/02/27 15:49:16 Successfully executed 'create connection'. Database 'BASE_001' is now managed by Replication Server 'REP_SRV'. 2009/02/27 15:49:16 Task succeeded: set connection to the database. 2009/02/27 15:49:16 Running task: start the Replication Agent. 2009/02/27 15:49:16 Sending the following SQL command to the server: 'exec sp_start_rep_agent "BASE_001" '. 2009/02/27 15:49:16 Task succeeded: start the Replication Agent. 2009/02/27 15:50:17 Configuration completed successfully. 2009/02/27 15:54:09 Must be 'active' or 'standby' 2009/02/27 15:58:10 Running task: check the SQL Server. 2009/02/27 15:58:10 Task succeeded: check the SQL Server. 2009/02/27 15:58:10 Running task: verify users and their passwords. 2009/02/27 15:58:10 Verified that 'REP_SRV_ra' can log into Replication Server 'REP_SRV'. 2009/02/27 15:58:10 Verified that 'sa' can log into Replication Server 'REP_SRV'. 2009/02/27 15:58:10 Task succeeded: verify users and their passwords. 2009/02/27 15:58:10 Running task: check the database. 2009/02/27 15:58:10 Verified that database 'BASE_001' exists. 2009/02/27 15:58:10 Sending the following SQL command to the server: 'dbcc is_replication_enabled'. 2009/02/27 15:58:10 Verified that SQL Server 'DS_PROD' supports replication. 2009/02/27 15:58:10 Sending the following SQL command to the server: 'use master'. 2009/02/27 15:58:10 Sending the following SQL command to the server: 'use master'. 2009/02/27 15:58:10 Sending the following SQL command to the server: 'if exists (select * from sysobjects where name = 'rs_install_sql_proc_1') drop procedure rs_install_sql_proc_1'. 2009/02/27 15:58:10 Sending the following SQL command to the server: 'if exists (select * from sysobjects where name = 'rs_install_sql_proc_2') drop procedure rs_install_sql_proc_2'. 2009/02/27 15:58:10 Sending the following SQL command to the server: 'use BASE_001'. 2009/02/27 15:58:10 Sending the following SQL command to the server: 'if exists (select * from sysobjects where name = 'rs_install_sql_proc_2') drop procedure rs_install_sql_proc_2'. 2009/02/27 15:58:10 Sending the following SQL command to the server: 'use master'. 2009/02/27 15:58:10 Sending the following SQL command to the server: 'create procedure rs_install_sql_proc_1 as if exists (select name from syslogins where name = "BASE_001_maint") begin if exists (select * from BASE_001..sysusers, syslogins where BASE_001..sysusers.name = "BASE_001_maint" and BASE_001..sysusers.suid = syslogins.suid and (BASE_001..sysusers.name = syslogins.name or BASE_001..sysusers.uid = 1)) return 1 else begin if exists (select name from syslogins, BASE_001..sysalternates where syslogins.name = "BASE_001_maint" and syslogins.suid = BASE_001..sysalternates.suid) return 2 else return 3 end end else return 4'. 2009/02/27 15:58:10 Sending the following SQL command to the server: 'exec rs_install_sql_proc_1'. 2009/02/27 15:58:10 Verified that the maintenance user 'BASE_001_maint' is defined in database 'BASE_001'. 2009/02/27 15:58:10 Sending the following SQL command to the server: 'use master'. 2009/02/27 15:58:10 Sending the following SQL command to the server: 'if exists (select * from sysobjects where name = 'rs_install_sql_proc_1') drop procedure rs_install_sql_proc_1'. 2009/02/27 15:58:10 Sending the following SQL command to the server: 'if exists (select * from sysobjects where name = 'rs_install_sql_proc_2') drop procedure rs_install_sql_proc_2'. 2009/02/27 15:58:10 Sending the following SQL command to the server: 'use BASE_001'. 2009/02/27 15:58:10 Sending the following SQL command to the server: 'if exists (select * from sysobjects where name = 'rs_install_sql_proc_2') drop procedure rs_install_sql_proc_2'. 2009/02/27 15:58:10 Sending the following SQL command to the server: 'use master'. 2009/02/27 15:58:10 Sending the following SQL command to the server: 'use master'. 2009/02/27 15:58:10 Sending the following SQL command to the server: 'if exists (select * from sysobjects where name = 'rs_install_sql_proc_1') drop procedure rs_install_sql_proc_1'. 2009/02/27 15:58:10 Sending the following SQL command to the server: 'if exists (select * from sysobjects where name = 'rs_install_sql_proc_2') drop procedure rs_install_sql_proc_2'. 2009/02/27 15:58:10 Sending the following SQL command to the server: 'use BASE_001'. 2009/02/27 15:58:10 Sending the following SQL command to the server: 'if exists (select * from sysobjects where name = 'rs_install_sql_proc_2') drop procedure rs_install_sql_proc_2'. 2009/02/27 15:58:10 Sending the following SQL command to the server: 'use master'. 2009/02/27 15:58:10 Verified that maintenance user 'BASE_001_maint' can log into SQL Server 'DS_PROD'. 2009/02/27 15:58:10 Verified that maintenance user 'BASE_001_maint' can log into SQL Server 'cd09_sec'. 2009/02/27 15:58:10 Task succeeded: check the database. 2009/02/27 15:58:10 Running task: configure database for primary data. 2009/02/27 15:58:10 Sending the following SQL command to the server: 'use BASE_001'. 2009/02/27 15:58:10 Sending the following SQL command to the server: 'grant all on rs_update_lastcommit to BASE_001_maint'. 2009/02/27 15:58:10 Sending the following SQL command to the server: 'grant execute on rs_get_lastcommit to BASE_001_maint'. 2009/02/27 15:58:10 Sending the following SQL command to the server: 'grant all on rs_lastcommit to BASE_001_maint'. 2009/02/27 15:58:10 Granted maintenance user permissions on the lastcommit functions and rs_marker. 2009/02/27 15:58:10 WARNING: Please verify that suids in the syslogins table of the Standby SQL server correspond to syslogins of the Active SQL Server 2009/02/27 15:58:10 Sending the following SQL command to the server: 'sp_role "grant", replication_role, BASE_001_maint'. 2009/02/27 15:58:10 Granted replication role to maintenance user 2009/02/27 15:58:10 Task succeeded: configure database for primary data. 2009/02/27 15:58:10 Running task: configure the Replication Agent. 2009/02/27 15:58:10 Sending the following SQL command to the server: 'use BASE_001'. 2009/02/27 15:58:10 Sending the following SQL command to the server: 'exec sp_config_rep_agent "BASE_001", enable,"REP_SRV", "REP_SRV_ra", "REP_SRV_ra_ps"'. 2009/02/27 15:58:10 SQL Server message: msg 18382, level 16, state 1 2009/02/27 15:58:13 WARNING: "Database 'BASE_001' is already configured to use Replication Agent. Request to enable Replication Agent has been ignored." 2009/02/27 15:58:15 Unable to execute query 'exec sp_config_rep_agent "BASE_001", enable,"REP_SRV", "REP_SRV_ra", "REP_SRV_ra_ps"' against server 'cd09_sec'. 2009/02/27 15:58:16 Task failed: configure the Replication Agent. Terminating configuration. 2009/02/27 15:58:19 Configuration failed.