Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

MMC error after opening DTS packages

Posted on 2006-05-15
7
Medium Priority
?
366 Views
Last Modified: 2008-02-01
Hello,

I've been getting consistent errors in SQL Server 2000 after opening DTS packages in Enterprise Manager. In all cases, the error affects the user interface for DTS package editing. Originally, I could open a package, edit, and save it without problem. When
I opened a second package though the package window was blank and I would
get an mmc error advising me to terminate the application. Each time I
restated EM I could open and work with one package. The SQL server service
was not affected.

I am using SQL Server SP3a and OS is Windows 2003 server Enterprise R2. The erroris tied to the MMC.exe version is 5.2.3790.2560

Has anybody seen this kind of problem ? If yes, then what are the possible solutions?

Please advise...

Thanks!

Salman.
0
Comment
Question by:Salooo
  • 3
  • 3
7 Comments
 
LVL 75

Expert Comment

by:Anthony Perkins
ID: 16687507
Are you sure you have the same Service Pack for SQL Server on the workstation as the server?  This problem is typical with mismatched versions.
0
 

Author Comment

by:Salooo
ID: 16690493
I have 2 machines which are basically mirrors of each other. One is being used for Development and one for production. I have the same problem coming up in both machines.

As I had mentioned, I have Windows 2003 Server R2 as the OS which comes with MMC 3.0
Also both machines have SQL Server 2000 SP 3a.

So far to me it seems like a conflict between the R2 version of windows with MMC 3.0 and the DTS designer window/application.

Any ideas??

Thanks!
0
 

Author Comment

by:Salooo
ID: 16690513
I have Windows 2003 Server Enterprise R2 edition SP1 .....
Just wanted to clarify the version of OS again.

Thanks!
0
Industry Leaders: 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!

 
LVL 75

Expert Comment

by:Anthony Perkins
ID: 16692844
I am afraid I have no idea.
0
 

Author Comment

by:Salooo
ID: 16694775
Hello,

I called Microsoft support on the issue and it seems like this is a Windows issue. Unfortunately they do not have a fix out for this bug at this point of time. But for other folks out there who end up seeing this same problem you can don one of the following:

1) Move to a previous version of Windows (Enterprise SP1) if you hardare is supported. Currently Enterprise SP1 supports upto 8-way SMP (processors) and 32 GB of RAM.
2) Continue using the current environment and basically ignore the error message. You will have to reopen Enterprise Manager everytime it crashes!
3) Move to SQL Server 2005 and convert all of your DTS packages. (Not something I would do if there were a lot of dynamic properties objects being used)

Well at this point I have decided to go back to a previous version of Windows. So I will let you guys know if everything works.

Until then Adios Amigos!
0
 
LVL 75

Expert Comment

by:Anthony Perkins
ID: 16695915
Great!  Now please close the question.  See here from the EE Guidelines:

I answered my question myself. What do I do?
http://www.experts-exchange.com/Databases/Microsoft_SQL_Server/help.jsp#hi70
0
 

Accepted Solution

by:
GranMod earned 0 total points
ID: 16701954
Closed, 180 points refunded.
GranMod
The Experts Exchange
Community Support Moderator of all Ages
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying 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

This post looks at MongoDB and MySQL, and covers high-level MongoDB strengths, weaknesses, features, and uses from the perspective of an SQL user.
Your data is at risk. Probably more today that at any other time in history. There are simply more people with more access to the Web with bad intentions.
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…
Suggested Courses

810 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