I'm trying to figure out a way to copy the ISA 2006 MDSE database to MS SQL server 2000 using DTS. I want to maintain the MSDE tables in ISA 2006 server and schedule daily DTS job to copy the MSDE enytries to another server hosting MS SQL server 2000 standard edition. I know I can configure ISA 2006 to connect directly to the SQL 2000 but in this case I will loose some important features such as live monitoring and scheduled reporting.
I tried to connect remotely using OSQL -E -S myserver\MSFW and also using SQL 2000 Enterprise Manager but both attempts failed. I even opened all ports in ISA but still with no success.
Have any one tried this scenario before ?