Inaccuracies in recent CNNMoney.com article about SQL Express and Windows Vista

Owen Thomas wrote an article for the Business 2.0 secton of CNNMoney.com on December 15,2006 that made some inaccurate claims about SQL Express compatibility with the upcomming Windows Vista operating system. Mr. Thomas wrote that you “can’t run the current version of SQL Server” on Windows Vista. This is not true, SQL Express SP1 is fully supported on…

3

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

Database Publishing Wizard – CTP2

Our web hosting team within SQL Server has reached another milestone with the second CTP of the Database Publishing Wizard. Congratulations to the team! Here is the announcements in their own words explaining some of the updates and changes.  – Mike Today, we’re excited to announce the release of the 2nd CTP of the SQL…

2

SQL Express SP2 – November CTP now available

The November CTP of SQL Express SP2 is available at a download center near you. As I’ve written before, SQL Express SP1 has a few known issues when running on Windows Vista, SP2 is where we’ve addressed these issues and is what we recommend using for Vista compatibility in your applications. The CTP is available…

1

Database Publishing Wizard CTP

Getting a database from your development computer onto your web hosters computer can be a challenge. We’ve been working to make this process easier by developing a tool to completely script out your database so that you can run the script on your hosters computer. I encourage you to download and test the first CTP…

0

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

"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. Resolution Redirect the BIDS shortcut to the location where devenv.exe actually exists. From the Start menu,…

7

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 Line Installation The SQL Setup program supports a number of…

3

Source code for Embedding Webcast (Finally)

Updated Sample Available!   Steve Lasker (of SQL Server Compact fame) and I spent some time reworking this deployment sample for a presentation that Steve did at TechEd Barcelona at the end of 2007. You can find Steve’s post including links to all his presentations here. Of particular interest to this group is the updated Deploying Database…

0