Can’t connect to local EPiServer database after upgrading to Windows 10 and Visual Studio 2015

After parental leave, vacation, upgrading to Windows 10 and getting Visual Studio 2015 up and running I thought it was safe to head back into the EPiServer waters.

Unfortunately my local database had been swallowed whole by the upgrade shark and my previously fantastic EPiServer site threw a YSOD in my face, complaining about the database connection.

YSOD

The error message is in Swedish. Sorry. But it’s something something database connection something something Local Database Runtime.

I was rocking the localdb version of v11.0 (SQL Server Express 2012) in my connection string. The first attempt was to get this up and running.

StartLocalDBV11

That sure didn’t work. The event log complains about access rights to a system folder. Seemed like a trip down the rabbit hole. Staying well clear of that one.

What’s up SQL Server? Which versions are good to go then?

StartMSSQLLocalDB

SQL Server Express 2014 reveals itself. It should just be a case of changing the connection string to use MSSQLLocalDB instead of v11.0, right?

NotCompatible

Not quite apparently. The database needs to be upgraded to SQL Server Express 2014. We’ll do this by creating a new connection to the database.

CreateNewConnection

Select Microsoft SQL Server as data source.

SelectMicrosoftSQLServer

Set the server name to (LocalDB)\MSSQLLocalDB

AddConnection

This should upgrade your EPiServer database to be compatible with SQL Server Express 2014 and you should be good to go. You might have to remove the connection you created and restart Visual Studio, otherwise it’ll create two connections and complain that the first one is in use.

The lesson learnt is that with a fresh install of Windows 10 and Visual Studio 2015 you’ll probably be missing SQL Server Express 2012. Any EPiServer database connection that uses this version may fail. You’ll need to upgrade the database to SQL Server Express 2014 and change the connection string setting to use the 2014 version (MSSQLLocalDB) instead of 2012 (v11.0).

daniel
daniel
Developer
Recommended Posts
  • Steve Celius

    VS2015 actually warned me about this when I opened a project using the older SQL version, and asked to update it. I guess you did not get this, since you ended up having to troubleshoot it. Excellent info, if it happened to you, it will happen to lots of others, I bet 🙂

    • Daniel Berg

      Actually I think it did warn me. But brain went: “go away you distracting popup of evil and let me get to the code!”. When the site wouldn’t run brain got back to me “that little popup thingie before was important, wasn’t it? Can we have it back?”.

      Perhaps the lesson learnt is read the important VS popups. 🙂

  • kommando tolken 🙂 it’s a nice title for the window…

  • Eric P

    The issue for my part was to completely reinstall Visual Studio 2015 to fully receive version 14.0 of SQL

Contact Us

We're not around right now. But you can send us an email and we'll get back to you, asap.

Not readable? Change text. captcha txt

Start typing and press Enter to search