Benki Chendu (2/27/2013)
I have recently installed a SQL Server 2012 instance and have deployed a few databases on it.However, the server is restaring abruptly and nothing is clear from SQL Server logs.
I see some wierd messages in event viewer like the below ones:
Product: SQL Server 2012 Database Engine Services - Update '{402234FB3-7241-4B6D-83A4-92323BCS3DC8}' could not be installed. Error code 1642. Windows Installer can create logs to help troubleshoot issues with installing software packages. Use the following link for instructions on turning on logging support: http://go.microsoft.com/fwlink/?LinkId=23127
Windows detected your registry file is still in use by other applications or services. The file will be unloaded now. The applications or services that hold your registry file may not function properly afterwards.
DETAIL -
2 user registry handles leaked from \Registry\User\S-1-5-80-1651743498233-604422593-37299121234-4324324703093-311232196992:
Process 6056 (\Device\HarddiskVolume3\Windows\System32\conhost.exe) has opened key \REGISTRY\USER\S-1-5-80-16517234234233-12334442-3729906164-4251703093-3124596992\Control Panel\International
Process 6044 (\Device\HarddiskVolume4\Program Files\Microsoft SQL Server\MSSQL11.DEV\MSSQL\Binn\fdhost.exe) has opened key \REGISTRY\USER\S-1-5-80-1651231233-6021312593-31232139906164-42556757573093-3124596992\Control Panel\International
Whats the reason for the SQL restart? Would a Service pack upgrade help?
I agree with Gail on this one. This is one for the folks at MS.
--Jeff Moden
Change is inevitable... Change for the better is not.