Troubleshooting the corrupt file error when using the SQL Server 2008 Express Setup Package

I’ve seen a number of people bringing this message up in the forums recently so I thought I would blog about it rather than type the answer over and over. (I’m lazy that way.) Problem When you run the installer you get the following error after the download of the SQL Server 2008 Express installation…

1

FAQ: Error creating a Service-based database in Visual Studio 2008 SP1

A few of you have run into problems when trying to add a new Service-based database to your project in Visual Studio 2008 SP1. This problem has been reported to Microsoft Connect and the Visual Studio team is working on a fix, but I thought I would provide some details on a workaround in the…

3

FAQ: "Installing" the SQL Server 2008 Express ClickOnce Bootstrapper for Visual Studio 2008 SP1

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 Visual Studio 2008 Express SP1 products, but not by the VS SP1 patch…

13

FAQ: Switching between SQL Server 2008 edtions

There is an extra step that you need to take when upgrading from one edition of SQL Server 2008 to another, for example when upgrading from Express to Express with Tools. This extra step is called Edition Upgrade (sometimes SKU Upgrade) and the net result is that you have to run the install wizard twice…

6

What’s up with SQL Server 2008 Express editions

<?xml:namespace prefix = w ns = “urn:schemas-microsoft-com:office:word” /> Microsoft has announced the release of SQL Server 2008 and that means it time for another post about SQL Server Express.<?xml:namespace prefix = o ns = “urn:schemas-microsoft-com:office:office” /> The press release indicated that SQL Express is already available, but those of you who have followed the link have…

16

Understanding SQL Express behavior: Idle time resource usage, AUTO_CLOSE and User Instances

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 been related to web hosting, the behavior is a general behavior for…

13

DIY SQL Express SP2 Bootstrapper

I’ve waited far too long to communicate this disappointing news to everyone, so here it is… I’m not going to be releasing the SQL Express SP2 Bootstrapper manifests that I had discussed in a long ago blog posting. I’ll spare you the sob story of my efforts to create this; suffice it to say that…

10

Connecting to SQL Express User Instances in Management Studio

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 of embedded databases. User Instances were added to SQL Express in order to…

23

SQL Express SP2 and Windows Vista UAC

Now that SQL Server 2005 SP2 has been released I thought I should make good on my promise to explain more about how we handle Windows Vista User Access Control in SQL Express SP2. I explained earlier that UAC works by removing the administrator ACEs from your User Token when you are a member of…

6

Getting things working on Vista (aka – Dealing with User Account Control)

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 addresses, so I still say deploying SP2 is the…

13