Migrate ISA 2006 logs to MS SQL 2000 using DTS

Posted on 2009-07-07
Last Modified: 2013-11-30

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 ?

Question by:AZZA-KHAMEES
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 3
LVL 29

Accepted Solution

pwindell earned 500 total points
ID: 24805403
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.
It is designed to be that way.  This probably not only keeps you from connecting with the Enterprise Manager but also connecting from another database to be able to pull the data from it.
Troubleshooting Logging
This is the relevant quote from that link:
Cannot Connect to MSDE Database Remotely
Problem: Attempting to connect remotely to the MSDE database located on the ISA Server computer fails.
Cause: The MSDE instance used by ISA Server has network protocols disabled. Therefore, you cannot connect to it remotely. You can only connect using the SQL Enterprise Manager when Enterprise Manager is installed on the ISA Server computer.
Solution: Use the SQL Enterprise Manager installed on the ISA Server computer to connect to the MSDE database.

Author Comment

ID: 24805777
Dear pwindell,
Thanks for the comments. if I install the SQL Enterprise manager on the ISA server, how do I create a DTS to read the MSDE database and convert it to SQL database given that the MSDE database name is chaning every day?
LVL 29

Expert Comment

ID: 24805789
I don't know.
 I don't know that you will ever be able to do what you are wanting.
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!


Author Comment

ID: 24806076
Thanks pwindell.
LVL 29

Expert Comment

ID: 24806402
I was thinking some more.
You probably know a lot more about SQL Server than I do,...but if you load the Enterprise Manager on the ISA and open the DB Engine,...then maybe you can enable the "features" than MS left disabled.  I don't know for sure,...but it is just a thought.

Author Closing Comment

ID: 31600977

Featured Post

Get 15 Days FREE Full-Featured Trial

Benefit from a mission critical IT monitoring with Monitis Premium or get it FREE for your entry level monitoring needs.
-Over 200,000 users
-More than 300,000 websites monitored
-Used in 197 countries
-Recommended by 98% of users

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

What if you have to shut down the entire Citrix infrastructure for hardware maintenance, software upgrades or "the unknown"? I developed this plan for "the unknown" and hope that it helps you as well. This article explains how to properly shut down …
It is possible to export the data of a SQL Table in SSMS and generate INSERT statements. It's neatly tucked away in the generate scripts option of a database.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.

717 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question