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

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!
Roxanne25Asked:
Who is Participating?
 
JamesDSConnect With a Mentor Commented:
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
 
JamesDSCommented:
Roxanne25
Try re-installing the SQL Server MMC Snapin from the CD

Cheers

JamesDS
0
 
Roxanne25Author Commented:
I don't have the SQL Server CD.
0
 
Roxanne25Author Commented:
The service pack update fixed the problem.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.