SQL Server Express WebLog

Updated The information in this posting is superseded by the following KB Article: 914277 How to configure SQL Server 2005 to allow remote connections http://support.microsoft.com/default.aspx?scid=kb;EN-US;914277 ------------------------------...

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 ...

For those of you who are interested in database management tools for SQL Express, I’d like to tell you about a new product that Microsoft will be releasing soon called SQL Server Express Manager (or XM for short). XM is a lightweight tool built...

This is the short version, the longer version is further down, also make sure and review the SQL Express BOL and the Mini BOL . Follow these steps: 1. Make sure express is running correctly (assumes a default install) Drop to a cmd prompt ...

Great news for SQL Server Express users today! We increased the maximum database size in SQL Server 2008 R2 Express from 4GB to 10GB . You can try it out today – just go to SQL Server 2008 R2 Download Page and select...

Many of you are working with User Instances , sometimes without even realizing it. Briefly, a User Instances is special process of SQL Express that can be started by an application at runtime and allows SQL Express to emulate some of the characteristics...

It's been a long road filled with many shouts of "Are we there yet?", so I'm happy to say that yes, we're there now. SP2 has finally be released. You can find the SQL Express SP2 bits on the SQL Express download page along with several other related downloads...

The full Beta 2 version of SQL Express is coming soon. While the Beta 2 release will not add any new features, it does contain many bug fixes that were not in the Tech Preview. We recommend upgrading to Beta 2 as soon as it is available. Unfortunately...

Hi, I'm attending Teched Europe where we announced the Express Products earlier this week. Several people here have asked me the difference between MSDE and SQL Server Express. I thought that that I'd include a quick high level summary here: ...

When installing SQL Server 2005 RTM/SP1/SP2 and SQL Server 2008 RTM on Windows 7 RC it presents you with a warning message. The message says that this SQL Server version has a known compatibility issues with Windows 7 RC. This warning is genuine and applies...

Microsoft has announced the release of SQL Server 2008 and that means it time for another post about SQL Server Express. The press release indicated that SQL Express is already available, but those of you who have followed the link have found that...

There are two options for installing SQL Server 2008 Express. 1. Basic: Choose this option to install SQL Server Express with minimal effort by using the Web Platform Installer and a pre-defined defaults. Visit SQL Server Express download page to perform...

With Windows 8 Consumer Preview released I thought it would be good to clarify for our users which SQL Server Express versions will be supported on Windows 8. Here they are: SQL Server 2008 Express SP3 and above. SQL Server 2008 R2 Express SP1...

Normal 0 false false false EN-US X-NONE X-NONE ...

Clearly, the names of our components are getting too long, but that's a matter for another post… Many of you have noticed that the VS bootstrapper for SQL Express 2008 (and similarly the bootstrapper for Windows Installer 4.5) are installed by the...

SQL Server Express will be free to use and redistribute. The only requirement that we have is that you register to redistribute the product. The reason we require registration for redistribution is that we want to ensure that we can get critical security...

Brian has a great sample on MSDN that shows off new features in the express SKUs. It really looks cool and pretty simple in terms of code. Please give us feedback as we have more samples planned. -Euan Garden Product Unit Manager SQL Server...

Are you using SQL Server 2005 Express Edition and want to contribute to helping us continue to improve it? Now is your chance. We are about to start a beta program for the next update to SQL Express and are looking for beta testers who have experience...

About a month ago, Microsoft released the first Beta version of SQL Server Express. We hope everyone who was interested has had a chance to try out this new product and let us know how we can make the final release better. One of the goals of SQL Server...

Update: After a recent article on CNNMoney.com (see my post with the link to the article) I thought I would add to this post to clarify that SQL Express SP1 is supported for use on Windows Vista. As discussed in this post, there are some issues that SP2...

I've gotten a number of questions recently asking how SQL Express uses resources during idle time, and how that behavior impacts the way SQL Express behaves "on first connection" after being idle for a period of time. While many of these questions have...

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...

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...

There have been a few blog postings (most notably Eric Nelson's post on July 12) about the fact that MSDE 1.0 and 2000 will not be supported on Windows Vista and Longhorn. It's high time I made it official: MSDE 1.0 and 2000 will not be supported...

As of this morning SQL Express Beta 2 is available for download from http://lab.msdn.microsoft.com/express/sql/ . Before upgrading please follow all the steps listed on the download page or at http://blogs.msdn.com/sqlexpress/archive/2004/07/21/190738...