Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Migrate ISA 2006 logs to MS SQL 2000 using DTS

Posted on 2009-07-07
6
Medium Priority
?
402 Views
Last Modified: 2013-11-30
Hello,

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.


Cheers

Have any one tried this scenario before ?

Thanks
0
Comment
Question by:AZZA-KHAMEES
[X]
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
6 Comments
 
LVL 29

Accepted Solution

by:
pwindell earned 1500 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
http://technet.microsoft.com/en-us/library/cc302540.aspx#SQLVersions
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.
 
0
 

Author Comment

by:AZZA-KHAMEES
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?
Regards
0
 
LVL 29

Expert Comment

by:pwindell
ID: 24805789
I don't know.
 I don't know that you will ever be able to do what you are wanting.
0
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 

Author Comment

by:AZZA-KHAMEES
ID: 24806076
Thanks pwindell.
0
 
LVL 29

Expert Comment

by:pwindell
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.
 
0
 

Author Closing Comment

by:AZZA-KHAMEES
ID: 31600977
Thanks
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

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

I have a large data set and a SSIS package. How can I load this file in multi threading?
This month, Experts Exchange sat down with resident SQL expert, Jim Horn, for an in-depth look into the makings of a successful career in SQL.
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, show how to extract information from SQL Server on Database, Connection and Server properties

618 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