Yesterday I was trying to add a database to the App_Data folder of a simple web application I was creating.  During one of my computer re-installs, I didn't install SQL Express since I normally use a full blown SQL instance, so I really had no need for it.  Now that I did need it, I wanted to run SQL Express 2008.  I am running Windows Vista x64, so I proceeded to download SQL Express 2008 x64.  I installed it and loaded up SQL Server Management Studio to make sure the instance was working (I just used the default of SQLEXPRESS for the instance name).  Everything was fine.  I then fired up Visual Studio, right-clicked on the App_Data folder of the web app, and... error (Figure 1).

Figure 1 - Connections to SQL require SQL Express

More...

I was looking for a list of Ping Services for BlogEngine.NET and came across Roman Clarkson's post on the topic.  As you may or may not know, BlogEngine.NET supports either XML or SQL for storage of posts, settings, etc.  Roman has a pingservices.xml file available on his site, which can be downloaded and used with BlogEngine.NET's XML provider. 

When migrating to BlogEngine.NET, we decided to use SQL Server instead of XML, so I decided I would create a SQL script which does the same thing as Roman's XML but for those of you that use SQL storage for BlogEngine.NET. 

You can download the file here: BlogEnginePingServiceList.zip, the zip file contains the SQL script that you can run against your DB.