Solved

Migrate ISA 2006 logs to MS SQL 2000 using DTS

Posted on 2009-07-07
6
342 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
  • 3
  • 3
6 Comments
 
LVL 29

Accepted Solution

by:
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
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
How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

 

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 Gift Card with Acronis Backup Purchase!

Backup any data in any location: local and remote systems, physical and virtual servers, private and public clouds, Macs and PCs, tablets and mobile devices, & more! For limited time only, buy any Acronis backup products and get a FREE Amazon/Best Buy gift card worth up to $200!

Join & Write a Comment

Introduction In my previous article (http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SSIS/A_9150-Loading-XML-Using-SSIS.html) I showed you how the XML Source component can be used to load XML files into a SQL Server database, us…
Ever wondered why sometimes your SQL Server is slow or unresponsive with connections spiking up but by the time you go in, all is well? The following article will show you how to install and configure a SQL job that will send you email alerts includ…
Via a live example, show how to shrink a transaction log file down to a reasonable size.
Viewers will learn how the fundamental information of how to create a table.

757 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

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now