Welcome to MSDN Blogs Sign in | Join | Help

Browse by Tags

All Tags » FAQ   (RSS)

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 Read More...
Posted Wednesday, April 22, 2009 11:31 PM by sqlexpress | 1 Comments
Filed under: ,

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 Read More...
Posted Thursday, October 02, 2008 8:07 PM by sqlexpress | 1 Comments
Filed under: ,

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 Read More...
Posted Friday, September 12, 2008 8:01 PM by sqlexpress | 6 Comments
Filed under:

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 Read More...
Posted Sunday, August 24, 2008 1:26 PM by sqlexpress | 5 Comments
Filed under: ,

What's up with SQL Server 2008 Express editions

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 it Read More...
Posted Thursday, August 07, 2008 7:49 PM by sqlexpress | 14 Comments
Filed under: , ,

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 Read More...
Posted Friday, February 22, 2008 8:07 PM by sqlexpress | 10 Comments
Filed under: , ,

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 Read More...
Posted Thursday, August 23, 2007 7:41 PM by sqlexpress | 10 Comments
Filed under: ,

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 Read More...
Posted Wednesday, November 22, 2006 10:33 PM by sqlexpress | 15 Comments
Filed under:

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 Read More...
Posted Wednesday, November 15, 2006 10:38 PM by sqlexpress | 5 Comments
Filed under: ,

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 Read More...
Posted Wednesday, October 11, 2006 2:26 PM by sqlexpress | 13 Comments
Filed under:

"Windows is searching for devenv.exe" when launching BIDS

A number of people have been experiencing a problem launching the Business Intelligence Developer's Studio after installing SQL Server 2005 Express Edition Toolkit. The problem is that the shortcut is pointing to a file named devenv.exe that isn't there. Read More...
Posted Wednesday, September 27, 2006 4:30 PM by sqlexpress | 4 Comments
Filed under:

Configuring SQL Express During Installation

In this post I'm going to explore the various ways you can configure SQL Server Express during installation. The easiest way is to just use the Setup UI, but that isn't ideal when you want to embed SQL Express into your own application installer. Command Read More...
Posted Wednesday, September 20, 2006 5:32 PM by sqlexpress | 1 Comments
Filed under:

FAQ: Detecting SQL Server 2005 using WMI

I've gotten a number of e-mails asking how to detect if SQL Express is installed on a computer. I'm finally getting around to putting this in the Blog so I don't have to keep typing the answer. We've made discovery much easier in SQL Server 2005 with Read More...
Posted Saturday, July 29, 2006 3:55 AM by sqlexpress | 3 Comments
Filed under: ,

FAQ: My data doesn't get saved in Visual Studio

The problem of data not being saved is usually the result the Copy to output directory property of the database file. The Copy to output directory property controls if and when a file is copied during deployment of a VS application, including when you Read More...
Posted Monday, July 17, 2006 11:56 PM by sqlexpress | 1 Comments
Filed under:

How to: Configure Express to accept remote connections

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 ----------------------------------------------------------------------------------- Read More...
Posted Thursday, May 05, 2005 4:32 PM by sqlexpress | 58 Comments
Filed under:
More Posts Next page »
 
Page view tracker