Using LocalDB with Full IIS, Part 2: Instance Ownership

This is the second post in a two-post mini-series on using LocalDB with Full IIS. Don’t miss the first post. Quick Recap In the first post of this mini-series we said there are two properties of LocalDB causing problems when running under full IIS: LocalDB needs user profile to be loaded LocalDB instance is owned by…


Using LocalDB with Full IIS, Part 1: User Profile

This is the first post in two-post mini-series on using LocalDB with Full IIS. If you found it useful make sure to continue to the second post. LocalDB and Full IIS In this recent post I described how to use SQL Server Express LocalDB with Visual Studio 2010. The approach I proposed works for all…


Announcing SQL Server 2012 Express LocalDB RC0

LocalDB RC0 is Here, with a Brand New MSI!Release Candidate 0 for SQL Server 2012 has just shipped, bringing a new update to SQL Server Express LocalDB! As announced here LocalDB is a version of SQL Server Express, introduced in the CTP3 of SQL Server 2012 and created specifically for developers. It is very easy to…


Using LocalDB in Visual Studio 2010

SSMS is a Success, But What About the VS? In my recent post I was using .NET Framework 4.0.2 to enable SQL Server Management Studio to connect to LocalDB. It all worked rather well and I declared success and moved on to another topic. I conveniently kept silent about connecting to LocalDB from Visual Studio 2010. For a good…


LocalDB: Where is My Database?

As I mentioned in the previous post LocalDB handles database files differently than regular SQL Server. The regular SQL Server assumes that it is actively managed by a DBA. The DBA carefully configures SQL Server during the installation and afterwards. The DBA decides where SQL Server binaries are installed. The DBA also decides where the…


.NET Framework 4 now supports LocalDB!

Updated 2011-11-11: Added a link to the post on how LocalDB handles database file locations. Updated 2012-01-03: Clarified that only SSMS from SQL Server 2012 (or newer) will work with the .NET 4 Update 4.0.2, since earlier SSMS versions are using .NET 3.5. .NET Framework 4 Update 4.0.2 .NET team has just released Update 4.0.2…


Introducing LocalDB, an improved SQL Express

Updated 2011-11-28: Added reference to the walkthrough of using LocalDB in Visual Studio 2010 and to the new LocalDB Installer. Updated 2011-11-02: Added reference to .NET Framework 4 support for LocalDB in the Q&A section. Introduction It gives me great pleasure to introduce a new version of SQL Express called SQL Express LocalDB. LocalDB is…


ClickOnce Bootstrapper for SQL Server 2008 R2 Express

I’d like to share this post about ClickOnce Bootstrapper for SQL Server 2008 R2 Express delivered for the community by Robin Shahan (RobinDotNet, MVP). It is great to see members of our community to step up and deliver where we failed to deliver. Thank you Robin!http://robindotnet.wordpress.com/2011/02/06/how-about-a-bootstrapper-package-for-sqlserver-express-2008-r2/ Disclaimer – this ClickOnce bootstrapper package is not supported…