Thursday, January 11, 2007

SQL server MMC error

I got this a error when trying to open SQL enterprise manager;

AppName: mmc.exe AppVer: 5.1.2600.2180 ModName: mmc.exe
ModVer: 5.1.2600.2180 Offset: 0001f07e

After some (much) searching I found this on http://www.sqljunkies.com/Forums/ShowPost.aspx?PostID=9302

-         It happens to be an error with the MMC application data file for enterprise manager in my user profile.

From windows explorer, browse to the "MMC" folder under C:\Documents and Settings\[user_profile]\Applicaiton Data\Microsoft\ (This is a hidden folder and to be able to view it you must show hidden files and folders in the "Tools" --> "Folder Options" --> "View" settings). There should be a file named "SQL Server Enterprise Manager". You can either delete or rename this file (I prefer the latter). MMC will re-create this file the next time you access Enterprise Manager and should then be working properly.

Fixed the problem

1 comment:

Anonymous said...

YEAH!, it solved it!...



AppName: mmc.exe AppVer: 5.1.2600.2180 ModName: mmc.exe ModVer: 5.1.2600.2180 Offset: 0001f07e