Microsoft MS SQL Server Express

Topics: ASP.NET 2.0, Business Logic Layer
Jan 19, 2010 at 4:39 PM

Can Blogengine be used with MIcrosoft MS SQL Express editions?

Thank you

Coordinator
Jan 20, 2010 at 5:12 AM

Yes, you can use the Express edition.  The only difference is to use a connection string in the web.config file that works for SQL Server Express edition.

The connection string is different depending on whether you have an MDF file in the App_Data folder you are attaching to, or if the DB is attached to the Express engine the "normal" way.

You can see example connection strings for SQL Server here.

Jan 21, 2010 at 6:56 AM

Thank you, then I would assume since my web hoster does not use MS SQL Express on the server I would need to have 2 web configs, one to connect locally with the Express edition and another to connect on the server with MS SQL.  I believe I can backup locally and have the database restored on the server.