This error came about when upgrading to MS SQL 2005 on a Windows 2003 SBS R2 Server from MS SQL 2000 on SBS 2003. During the process of upgrading we encountered a blocking condition which made us fully uninstall all instances of MS SQL 2000 Standard and the 2005 Desktop Engine.
To get this error we need to go to Computer Management and click on Services and Applications.
—————————
Fatal Error
—————————
Execution cannot continue as the language dependent resource file C:\Program Files\Microsoft SQL Server\80\Tools\Binn\Resources\3081\sqlmmc.RLL could not be loaded.
—————————
OK
—————————
After clicking on the OK button it appears that everything works correctly but it’s still annoying for the client and myself.
To get rid of this error I found a copy of sqlmmc.dll in the folder “C:\Program Files\Microsoft SQL Server\80\Tools\Binn” and copied it to C:\Program Files\Microsoft SQL Server\80\Tools\Binn\Resources\3081\ (I had to create the 3081 folder) and renamed the file extension to .rll.
The error has now disappeared.
On a Windows 2003 server you get the following error in the event log.
———————————————————–
Event Type: Warning
Event Source: MSDTC
Event Category: SVC
Event ID: 53258
Date: 6/06/2009
Time: 11:47:46 AM
User: N/A
Computer: XXXXXX
Description:
MS DTC could not correctly process a DC Promotion/Demotion event. MS DTC will continue to function and will use the existing security settings. Error Specifics: d:\nt\com\complus\dtc\dtc\
adme\uiname.cpp:9351, Pid: 1508
No Callstack,
CmdLine: C:\WINDOWS\system32\msdtc.exe
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
Data:
0000: 05 00 07 80 …€
———————————————————–
To fix this you will need to do the following:
* Go to Administrative Tools -> Component Services
* Click Console Root -> Component Services -> Computers -> My Computer
* Right-click My Computer and click Properties
* Select MSDTC tab
* Click on “Security Configuration”
* Click “OK” (without changing any settings)
* Click “OK” again (without changing any settings)
* Right-click My Computer and clicked “Stop MS DTC”
* Right-click My Computer and clicked “Start MS DTC”
* Close down Component Services
To start up your virtual machines automatically when a VMWave ESX server powers up you will need to log into your VMWare Infrastructure Client and then: Select the VMWare ESX server -> Configuration -> Virtual Machine Startup/Shutdown as circled below.
Then click on Properties towards the top right of the window.
Tick the “Allow virtual machines to start and stop automatically with the system”. All your VM’s should be set to Manual startup initially, you will need to select them one by one and click the “Move Up” button. I like to order my VM’s with a statup delay to allow time for the Domain Controllers to finish starting up before the Exchange and File & Print servers.
Microsoft SQL, Windows 2003 | Wayne | 
January 14, 2010 9:30 am | 
Comments (1)