Solved

SQL Server 2000 Error: mmc.exe has generated errors and will be closed.

Posted on 2004-10-05
4
244 Views
Last Modified: 2010-04-13
Hello, I have poked around the forums and googled for an answer to this problem but I'm a developer not an admin...so I'm a bit confused about this.  I am trying to use my sql server (its SQL Server 2000 running on Windows 2000 professional) and every time I click on "create new linked server" it gives me the mmc.exe has generated errors and shuts down sql server.

I'm not exactly sure how to fix this and was hoping someone could guide me through it.  If I go to start, run and type mmc.exe it opens up fine.  So, please help if you can!  Thanks!
0
Comment
Question by:Roxanne25
  • 2
  • 2
4 Comments
 
LVL 16

Expert Comment

by:JamesDS
ID: 12228577
Roxanne25
Try re-installing the SQL Server MMC Snapin from the CD

Cheers

JamesDS
0
 

Author Comment

by:Roxanne25
ID: 12228596
I don't have the SQL Server CD.
0
 
LVL 16

Accepted Solution

by:
JamesDS earned 250 total points
ID: 12234837
Roxanne25
Without the CD you will not be able to repair the installation.
You might get lucky by installing the latest service pack for SQL2000 (which I believe is SP3)

Cheers

JamesDS
0
 

Author Comment

by:Roxanne25
ID: 12240051
The service pack update fixed the problem.
0

Featured Post

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Exchange server 2003 sp2 local queue frozen mail 3 360
Block EXEs from running on shared NTFS folder 3 421
Cannot access port 443 4 575
Domain dunctional level. 4 313
NTFS file system has been developed by Microsoft that is widely used by Windows NT operating system and its advanced versions. It is the mostly used over FAT file system as it provides superior features like reliability, security, storage, efficienc…
Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …
Internet Business Fax to Email Made Easy - With  eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, f…

863 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

16 Experts available now in Live!

Get 1:1 Help Now