Question: I use MSDE locally and with the default connection string generated, which uses SSPI integrated security I get deadlocks. What's the reason for this? ** Solution:** Some group policy lock downs of windows systems can cause deadlocks or even the fact that you can't log into your MSDE using SSPI security settings in your connection string. Try to use SqlServer security instead.