Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

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

Posted on 2004-10-05
4
Medium Priority
?
260 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
[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
  • 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 1000 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

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

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

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…
When trying to connect from SSMS v17.x to a SQL Server Integration Services 2016 instance or previous version, you get the error “Connecting to the Integration Services service on the computer failed with the following error: 'The specified service …
In this video you will find out how to export Office 365 mailboxes using the built in eDiscovery tool. Bear in mind that although this method might be useful in some cases, using PST files as Office 365 backup is troublesome in a long run (more on t…
In this video, Percona Director of Solution Engineering Jon Tobin discusses the function and features of Percona Server for MongoDB. How Percona can help Percona can help you determine if Percona Server for MongoDB is the right solution for …

661 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