I'm a developer and running a SQL Server 2008 SP1 instance (default instance) on my local machine (Windows 7 RC 32-Bit). Sometimes when the program I'm developing sends a query to the SQL Server, the whole SQL Server crashes. The SQL queries are not complex, just simple CRUD queries. When I restart the server, the next query kills him again.
The event log entry states that an error happens because of MS DTC. Unfortunately I don't have any idea why. When I'm using the SQL Server for other purposes through SQL Server Management Studio, I haven't encountered any problems, so I don't think it has to do with my operation system.
Does anybody have ideas why SQL Server crashes? It makes development really difficult, sometimes even impossible.
PS: Here is the event log entry.
An MS DTC component has generated an exception. Error Specifics: The process '"C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\Binn\sqlservr.exe" -sMSSQLSERVER' hit an exception in a MSDTC related component.
The following exception (0xc0000005) was generated at 0x 00FEAC8C, Pid:7400.
The process is being terminated.
Additional information useful in a debugger:
You can do '.exr 0x0369E930' to display the exception record.
You can do '.cxr 0x0369E94C' to display the context at the time of the exception.