Before you proceed, make sure that the previous assumptions are met.
The centralfailover user will be used by the other node for replication. You can use an alternate username, but make sure it is the same username on both machines.
Note: The first time that you click Clear SQL Rep..., if you receive error messages that state that there is nothing to replicate, you can ignore these errors.
You might also need to change the Copy from value on the Copy statistics database dialog thatl appears. If you encounter 'From' directory does not exist or cannot be accessed errors, use the following command-line sequence to confirm the following:
C:\>net use H: \\192.168.3.172\micstats /user:centralfailover
The password or user name is invalid for \\192.168.3.172\micstats.
Enter the password for 'centralfailover' to connect to '192.168.3.172': *******
The command completed successfully.
C:\>H:
H:\>dir stats.myi
09/22/2005 02:28 AM 53,248 stats.MYI
H:\>copy stats.myi c:\
1 file(s) copied.
You do not want the SQL Server database to be replicated because Node 1 and Node 2 share the same SQL Server database.