I have 3 SQL Server instances running on our server (dont ask why)!
2xSQL Server 2008 Workgroup (Default and MSSQLServer2) 1xSQL Server Express 2008 R2 (sqlexpress)
Now I have a Windows Service/App that runs a process in the background. The databases are pretty much the same, however whenever I try and run the service on the MSSQLServer2 instance NHibernate throws an exception.
I have checked my connections strings and it seems fine, as I've been able to copy the others, to be sure.
I've reset the account password I am using and checked that I can connected to it using Management Studio with the new creds.
I dont know what else to test. The app loads (as it creates a Log4View entry) but as soon as it makes its first NHibernate request it crashes, with a the following dump and no additional event log:
Description: Stopped working
Problem signature: Problem Event Name: CLR20r3 Problem Signature 01: R2K3ITVW3VUVRUM1CITUNG1NSZBMATAX
Problem Signature 02: 188.8.131.52
Problem Signature 03: 4de87428
Problem Signature 04: NHibernate
Problem Signature 05: 184.108.40.20600
Problem Signature 06: 4639a07f
Problem Signature 07: 2ad Problem Signature 08: 78 Problem Signature 09: NHibernate.LazyInitialization OS Version: 6.0.6001.2.1.0.272.7 Locale ID: 2057
Read our privacy statement: