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.
MIM Survival Guide for Service Desk Managers

Major incidents can send mastered service desk processes into disorder. Systems and tools produce the data needed to resolve these incidents, but your challenge is getting that information to the right people fast. Check out the Survival Guide and begin bringing order to chaos.


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

Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

Question has a verified solution.

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

Suggested Solutions

Introduction SQL Server Integration Services can read XML files, that’s known by every BI developer.  (If you didn’t, don’t worry, I’m aiming this article at newcomers as well.) But how far can you go?  When does the XML Source component become …
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

737 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