We need to setup publishing and subscription between two MS SQL databases..
The publisher will be transactional, and is running SQL 2000
The subscription is running SQL 2005.
Any step by step guides for this scenario , additional caveats would be useful. Problems at the minute appear to be IP address / DNS related so any info on testing the correct connectivity would also be superb.