56 posts from: SQL Server Express WebLog
SQL Server 2008 R2 Express has been released
(Indexed 2010-04-26):
The final release of SQL Server 2008 R2 was made publically available last week on April 21, 2010! SQL Server Express continues to ship in 4 different packages, but we made several changes to the installation wizard to simply the installation process. For the November CTP release, I documented the installation process at http://blogs.msdn.com/petersad/archive/2009/11/13/how-to-ins...(truncated)... The Process has not changed since the November CTP, except some messages have been changed to indic...(truncated)...
SQL Server 2008 R2 Express Database Size Limit Increased to 10GB
(Indexed 2010-04-21):
Great news for SQL Server Express users today! Weincreased the maximum database size in SQL Server 2008 R2 Express from 4GB to10GB.You can try it out today just go to SQL Server 2008 R2 DownloadPage and select SQL Server 2008 R2 Express from the menu on the left side ofthe page:http://www.microsoft.com/sqlserver/2008/en/us/R2Downloads.aspx FAQIs the database sizelimit increased in all editions of SQL Server 2008 R2 Express?Yes, SQL Server 2008 R2 Express with Tools and SQL Server2008 R2 Expres...(truncated)...
How to take ownership of your local SQL Server 2008 Express
(Indexed 2010-02-24):
Ward Beattie, one of our developers, has published a nice script thatallows you to get sysadmin privilege to your local SQL Server Express instance.Obviously, you need to have administrative rights on your machine or access toan account that does. The script can be very useful in the following situation:When Visual Studio 2010 RC is installed by one user andbeing used by another user, the second user is unable to create databases,tables and other objects in SQL Server 2008 Express instance that ...(truncated)...
Visual Studio 2010 Release Candidate is shipped!
(Indexed 2010-02-11):
Visual Studio 2010 Release Candidate is available fordownload. Congratulations to the Visual Studio team! You can get it here:http://www.microsoft.com/visualstudio/en-us/products/20...(truncated)... SQL Server Express point of view, Visual Studio 2010brings two changes:First, .NET Framework 4 support I described in the previous post,which allows you to build .NET Framework 4 applications that use and installSQL Server Express without forcing the end user to install two .NET Frameworkversions.Sec...(truncated)...
SQL Server Express and .NET Framework 4
(Indexed 2009-12-09):
We have just shipped a new package of SQL Server 2008 Express SP1 that supports .NET Framework 4 Beta 2, extending the range of .NET Framework versions supported by SQL Server 2008 Express SP1 to .NET 2.0 SP2, 3.5 SP1 and 4 Beta 2.The reason for this change is that Visual Studio 2010 Beta 2 ships with .NET Framework 4 Beta 2. It also distributes SQL Server 2008 Express, which originally required .Net 2.0 SP2 or 3.5 SP1. As a result Visual Studio team had to include two versions of .NET Framework...(truncated)...
SQL Server 2008 R2 November CTp Is released
(Indexed 2009-11-13):
With the release of the SQL Server 2008 R2 November CTP, we have simplified the SQL Server Express (all editions and package) installation process. In this release, we have completed the following: Reduced the number of clicks by 50% when performing an install. All inputs are defaulted on Vista and above operating systems. (many inputs are defaults on Windows XP and Windows 2003, except for the service accounts) Skip (auto advance) through the UI, meaning non-essential di...(truncated)...
Embedding SQL Server Express Survey
(Indexed 2009-09-08):
Microsoft is committed to making the SQL Server the best database in the industry for embedding with your application. For us to achieve this goal, we need your candid feedback on your experience with embedding SQL Server Express. If you have used several different versions of SQL Server Express, focus on the latest version that you have used. When SQL Server 2008 Customer Technical Preview 3 is released, feel free to complete this survey again since several installation improvements...(truncated)...
General SQL Server Express Survey
(Indexed 2009-09-08):
Microsoft is committed to making the SQL Server Express installation experience the best in industry. For us to achieve this goal, we need your candid feedback on your experience with installing SQL Server Express. If you have used several different versions of SQL Server Express, focus on the latest version that you have used. When SQL Server 2008 Customer Technical Preview 3 is released, feel free to complete this survey again since several installation improvements have been made....(truncated)...
ClickOnce bootstrapper for SQL Server 2008 Express with Tools
(Indexed 2009-09-03):
Id like to share the link to a blog post by Brock Weaver, where he explains how to add SQL Server 2008 Express with Tools to the list of prerequisites for ClickOnce packages:http://youarenotexpectedtounderstandthis.blogspot.c...(truncated)... is great to see people from the community extend our platform! Thanks Brock! Thats what we always hope for and thats why we always try to design our software in an open and extensible fashion.Disclaimer this ClickOnce bootstrapper package is not supported ...(truncated)...
Microsoft SQL Server 2008 R2 August CTP
(Indexed 2009-08-14):
The August CTP of Microsoft SQL Server 2008 R2 is now published: http://technet.microsoft.com/en-us/evalcenter/ee315247.aspx. Give it a try and give us feedback!!! This release does not have many changes around the Express when compared to SQL Server 2008. But the next CTP will contains several improvements as a result of your feedback. Here are some of the changes that will be in the SQL Server 2008 R2 Express product: The Express runtime package is smaller Setup UI Chang...(truncated)...
Troubleshooting .NET 2.0/3.5 Installation errors
(Indexed 2009-08-10):
The installation of .NET 3.5 can fail for several reasons. Sometimes the .NET 3.5 install fails and sometime SQL Server Setup fails to detect .NET is already on the machine. If you view the %temp%sqlsetup.log you can determine whether the .NET 3.5 installation failed or SQL Server Setup incorrectly detected .NET was already installed. Here is an example were .NET 3.5 SP1 failed to install. 05/21/2008 07:32:55.750 =============================================================...(truncated)...
Installing SQL Server Express through the Web Platform Installer
(Indexed 2009-08-03):
This topic will be expanded in the near future, but currently is a placeholder. [Image]
SQL Server 2008 Express Edition will be updated through Automatic Update
(Indexed 2009-07-30):
Starting in September, we are considering automatically updating SQL Server 2008 including all Express Edition to Service Pack 1 (SP1). See http://blogs.msdn.com/petersad/archive/2009/07/30/sql-server...(truncated)... for details. Provide us feedback on this change.[Image]
Embedding SQL Server 2008 Express in an Application technical Article
(Indexed 2009-07-09):
We recently published a technical article on how to embed and run SQL Server 2008 Express in unattended mode. The article is at http://msdn.microsoft.com/en-us/library/dd981032.aspx. We expect to revise this article at a later point in time. To ensure we continually improve the Express embedding experience, please provide us feedback. You can provide your feedback through this blog site or through the Microsoft connect site at https://connect.microsoft.com/SQLServer/Feedback. It is prefera...(truncated)...
Installing SQL Server 2008 Guidance
(Indexed 2009-06-15):
This blog will provide guidance on where to install SQL Server 2008 Express. [Image]
How should I Install SQL Server 2008
(Indexed 2009-06-15):
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 a basic install. The Microsoft Web Platform Installer will only perform an installation will all features with an Instance Name called SQLExpress. 2. Customize: If you need to customize the installation or install on a Domai...(truncated)...
We need your Express Setup FeedBack
(Indexed 2009-06-10):
In the next release of SQL Server, called SQL Server 2008 R2 we are working on addressing issues that complicated the installation of SQL Server Express. As the timeframe to address these issues is tight for this release we wont be able to address all issues. However, still take the time to file your issue at http://connect.microsoft.com/. If we cant address in SQL Server 2008 R2, we will consider addressing in the next major release. Thanks, Peter Saddow Program Manager SQL Se...(truncated)...
SQL Server 2005 Express edition, SP3 update on Windows 7
(Indexed 2009-06-04):
On June 23rd, we will publish the Express SQL Server 2005 SP3 updates for Windows 7. This is just a change in the detection logic to offer to a Windows 7 system. The SQL Server 2005 SP3 packages that have already been released to Microsoft Update and the Microsoft download center are unchanged. These Express updates are affected: Microsoft SQL Server 2005 Express Edition Service Pack 3 (KB955706) Microsoft SQL Server 2005 Express Edition with Advanced Services Service Pack 3 (KB955706) Micro...(truncated)...
SQL Server 2005 Express edition, SP3 update for Windows 7
(Indexed 2009-06-04):
On June 23rd, we will publish the Express SQL Server 2005 SP3 updates for Windows 7 through Microsoft Update. This is just a change in the detection logic to offer to a Windows 7 system. The SQL Server 2005 SP3 packages that have already been released to Microsoft Update and the Microsoft download center are unchanged. These Express updates are affected: Microsoft SQL Server 2005 Express Edition Service Pack 3 (KB955706) Microsoft SQL Server 2005 Express Edition with Ad...(truncated)...
Creating a SQL Server 2008 Management Studio Express Slipstream drop
(Indexed 2009-05-29):
I have put together steps for you to build an Express Management Studio with Service Pack 1. See these steps at http://blogs.msdn.com/petersad/archive/2009/05/29/creating-a...(truncated)...
Installing SQL Server Express on Windows 7 Release Candidate
(Indexed 2009-05-14):
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 to all SQL Server editions, including all Express editions. The incompatibility was fixed in SQL Server 2008 Service Pack1 and SQL Server 2005 Service Pack 3. You can safely continue the installation by clicking "Run program" button and apply...(truncated)...
I have SQL Server Express installed and I want to upgrade to Service Pack 1
(Indexed 2009-05-11):
The easiest way to upgrade to Service Pack 1 is to search for the update through Microsoft Update. The service pack 1 update will not be NOT be automatically installed to your system. If getting the update from Microsoft Update is not an option you must obtain the update from the download center from here. Peter Saddow[Image]
service Pack 1 for SQL Server Express 2008 is Available
(Indexed 2009-05-08):
The SQL Server 2008 Express package with Service Pack 1 is now available. The simplest location to install from is here, select Download and Install now. (Currently the other links on this package point to the original media. This will be revised soon). This tool will determine if the pre-requisites are installed and if not will install them for you. Next, the tool will install the edition that you have selected. This tool allows you to install SQL Server 2008 Express Advanced and SQ...(truncated)...
Troubleshooting the corrupt file error when using the SQL Server 2008 Express Setup Package
(Indexed 2009-04-23):
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.)ProblemWhen you run the installer you get the following error after the download of the SQL Server 2008 Express installation package:An error occurred during the installation of SQL Server 2008 Express.The downloaded file appears to be corrupt.If you view the log you see an error that looks something like this: Verbo...(truncated)...
Survey: SQL Express 2008 and Patching
(Indexed 2008-12-16):
We are working on the patching model that will be used for SQL Server 2008 Express and we're considering a change that I wanted to get your feedback on. Please take a moment to answer a few questions; feel free to answer through a comment to this post or by clicking the EMAIL link at the top of the blog.We are considering separating the patching process from the new install process such that the SQL Express package (such as SQLEXPR_x86_ENU.exe) would be used for new installations of the most cur...(truncated)...
SQL Server 2008 Upgrade Whitepaper
(Indexed 2008-12-05):
The SQL Server Engineering team has released a masive white paper that details upgrading to SQL Server 2008. It's all good information, but if you're reading this blog you're probably interested in chapter 10, which specifically covers SQL Server 2008 Express. You can find more information here.- Mike[Image]
Getting SQL Server 2008 Express on a DVD
(Indexed 2008-11-10):
A small but persistent group of developers has been asking for SQL Server Express to be released on media, most commonly from those folks who live in areas without broadband Internet (yes, there are still such areas) for whom downloading an 80 MB package can be an endurance challenge. One of the benefits of the new setup framework in SQL 2008 is that you can now order a DVD that will allow you to install SQL Server 2008 Express. Don't go looking for the SQL Server Express DVD though, because you...(truncated)...
Announcing the SQL Express 2008 Installation Package
(Indexed 2008-11-06):
The SQL Express 2008 Installation Package (Express Wrapper) is a new utility we've created to help customers who are installing SQL Express 2008 from the web. Following the lead of products such as the .NET Framework and Visual Studio Express, we've created a wrapper that will streamline installation of SQL Express from the web. If you just can't wait, you can jump to the SQL Express download page and get started right now. If you're interested in learning more, read on.OverviewThe Express Wrapp...(truncated)...
FAQ: Error creating a Service-based database in Visual Studio 2008 SP1
(Indexed 2008-10-03):
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 meantime. What's the problem? This issue occurs when you have Visual Studio 2008 SP1 (any edition) and SQL Server 2008 Express x64 installed. This won't happen if you have the 32bit version of SQL Express in...(truncated)...
FAQ: "Installing" the SQL Server 2008 Express ClickOnce Bootstrapper for Visual Studio 2008 SP1
(Indexed 2008-09-13):
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 that is applied to the non-Express versions. After noticing this, many of you have ask, "What's up with that?" The short answer is that it's just one of those things that happens when ...(truncated)...
Detailed information about installing SQL Express and it's prerequisites
(Indexed 2008-08-28):
There is a new posting in the PSS SQL Server blog that gives even more detail about installing the SQL Express editions including good information about the prerequisites. It's the same type of information posted here, but Bob Ward is a more advanced blogger than I am so he's included pictures and everything. This is great info; a big thanks to Bob for his efforts to put this post together. Be sure to poke around the PSS SQL blog post while your there, they cover a wide range of topics that othe...(truncated)...
FAQ: Switching between SQL Server 2008 edtions
(Indexed 2008-08-24):
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 when upgrading an existing instance to a different edition.Why did we do it?I don't have all the technical details here (I'm not a setup guy) but the basic deal is that the feature tree you see w...(truncated)...
The SQL Express 2008 family is getting bigger
(Indexed 2008-08-23):
We've released SQL Server 2008 Express with Tools (a new edition for 2008) and SQL Server 2008 Express with Advanced Services to the web. You can find information comparing the three editions of SQL Express in my recent blog post. You can find links to download any of the three editions of SQL Express from the Express web site. For those of you looking for Management Studio Express, you can install it from either SQL Express with Tools or SQL Express Advanced; there will not be a separet downloa...(truncated)...
SQL Server 2008 Express is now live!
(Indexed 2008-08-11):
I promised an update on SQL Express availability in my last post about the release of SQL Server 2008 so here it is. SQL Server 2008 Express is now available along with the release of the .NET Framework 3.5 SP1, which is a prerequisite and Visual Studio Express SP1. As I mentioned, there are two more editions of SQL Express on the way. There are a number of prerequisites for SQL Server 2008 that you will have to install on your own before installing SQL Express. Here is the list and basic instru...(truncated)...
What's up with SQL Server 2008 Express editions
(Indexed 2008-08-07):
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 is not actually there. Nothing to worry about, has a dependency on the .NET Framework 3.5 SP1 and we need to coordinate the release to the web for both of these which will take a few more days. I'll blog about it when we release it and you can watc...(truncated)...
SQL Server 2008 Express RC0
(Indexed 2008-06-10):
It's time for another release post, this time for RC0 of SQL Server 2008 Express and SQL Server 2008 Express with Advanced Services. Here is the information that everyone is waiting to hear about the SQL Express product line. (Note: If you're the impatient type you can skip to the end of this post to find the instructions for installing SQL Express.)Physical LimitationsSQL Express 2008 has the same physical limitations that existed in SQL Express 2005:1 CPU1 GB Memory4 GB of user data per databa...(truncated)...
BIDS or Bust: Writing reports in SQL Express 2008
(Indexed 2008-02-27):
I asked for your oppinions about a new Report Designer in one of my earlier posts in this blog. I wanted to thank everyone for taking the time to offer feedback and for those of you who even filed a bug or two. As you've probably already guessed from the title, our ultimate decision was to stick with Business Intellegence Developers Studio for report design in SQL Express with Advanced Services 2008. It's always a tough decision to make trade-offs between different scenarios and this case was no...(truncated)...
SQL Server Express and Hosting
(Indexed 2008-02-23):
Several questions have come up lately regarding whether SQL Server Express is an appropriate product to be used in a hosting environment. Here are the answers: User Instances (also known as RANU) available with SQL Server Express Edition, are NOT RECOMMENDED for hosting environments. Shared hosting: SQL Server Express Edition is NOT RECOMMENDED for shared (multi-tenant) hosting as the scale limits and memory handling do not allow it to meet the requirements of such an environm...(truncated)...
Understanding SQL Express behavior: Idle time resource usage, AUTO_CLOSE and User Instances
(Indexed 2008-02-23):
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 SQL Express, so I'll answer in general terms. SQL Express: It's SQL Server with a twist SQL Express is SQL Server. This may seem an odd thing to say, but many people get confused ...(truncated)...
Opinion Poll: Creating Reports in SQL Express 2008
(Indexed 2007-12-15):
The Reporting Services team is developing a new report designer tool that we're considering including in SQL Server Express 2008 with Advanced Services. This new report designer has a different user experience that is more geared toward information workers than developers. You can take a look at a preview of the new designer by downloading the SQL Server Developer 2008 November CTP. Once installed, you can find it at Start | All Programs | Microsoft SQL Server 2008 | Reporting Services | Report ...(truncated)...
What's New in SQL Express 2008 November CTP
(Indexed 2007-11-19):
SQL Server 2008 Express is now available as part of the November CTP - You can download it from the following link: http://www.microsoft.com/downloads/details.aspx?FamilyId=3BF...(truncated)... There is already a bunch of information out there about the new functionality available in SQL Server 2008, so I won't spend much time describing the features here. What I will do is document which of those new features will be available in the Express edition. The following new features are available in ...(truncated)...
DIY SQL Express SP2 Bootstrapper
(Indexed 2007-08-23):
I've waited far too long to communicate this disappointing news to everyone, so here it isI'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 some requirements arose that complicated an official release and priorities changed over time. If you work in the software industry you know how it goes. So that brings us toMy feeble backup planMost of the...(truncated)...
Backup and Restore with User Instances
(Indexed 2007-03-20):
Backup and Restore is an important part of any application, but when you're writing an application for an end-user, it becomes even more important that you do a good job of handling Backup and Restore in your code since you end-user will likely not know much about being a Database Administrator. Add to that the fact that we don't include SQL Agent or the Maintenance Plan wizard in SQL Express, and you have the perfect reason to roll your own solution for Backup and Restore. SQL Management Object...(truncated)...
SQL Express SP2 available on Microsoft Update
(Indexed 2007-03-07):
Just a quick not to let you know that the SP2 update for SQL Express, SQL Express with Advanced Services and SQL Express Toolkit are being published to Microsoft Update today. These are automatic updates and will apply to computers based on your Microsoft Update settings for automatic updates. (i.e. Notify, Download and Notify or Download and Install)The updates will also be part of WSUS so that IT Administrators have control over deployment of these updates throughout an Enterprise.When applied...(truncated)...
SQL Server 2005 SP2 has been released
(Indexed 2007-02-20):
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. As of this writing, we were having some problems with our publication system, so you may see that the page still says SP1, but the Download links themselves are updated and will actually download SP2. We'll get the page updated as soon as ...(truncated)...
SQL Server 2005 Compact Edition - Final Release available!
(Indexed 2007-01-15):
If you've been reading this blog or the SQL Express Forum you've undoubtably seen me write about SQL Server 2005 Compact Edition (SQL CE) as an alternative database for use when writing client applications that require local data storage. SQL CE is the evolution of SQL Mobile, with support added for Windows desktop operating systems. The SQL CE team has been working hard over the past months to do all the right things to make this a great product for desktop database development and they've just...(truncated)...
New benefits for Registration and new Absolute Beginners Videos
(Indexed 2007-01-05):
The SQL Express team has been working hard to increase the offerings the help you learn and use SQL Express. Be sure to check out these new offerings. Mike SQL Server Express Registration Benefits Update We recently update the 'Welcome' e-mail sent to SQL Server Express registered users to include many helpful new links and resources. In addition, we've refereshed the registration benefits to include an e-Book chapter from SQL Server 2005: Step by Step on how to develop SQL Server Express applic...(truncated)...
Inaccuracies in recent CNNMoney.com article about SQL Express and Windows Vista
(Indexed 2006-12-19):
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 Windows Vista.We have documented this level of support at a number of locations on the Microsoft web site, including the System Requirements page...(truncated)...
Connecting to SQL Express User Instances in Management Studio
(Indexed 2006-11-23):
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 better server developers creating ClickOnce applications in Visual Studio 2005. As long as you work completely within Visual Studio, you'll likely never even notice that a...(truncated)...
SQL Express SP2 and Windows Vista UAC
(Indexed 2006-11-16):
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 the BuiltinAdministrators group. This effectively limits your permission to connect to an manage SQL Server because we assign permissions based on membership in the BuiltinAdministrators group. To address...(truncated)...
Database Publishing Wizard - CTP2
(Indexed 2006-11-16):
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. - MikeToday, were excited to announce the release of the 2nd CTP of the SQL Server Hosting Toolkit! This CTP contains both a dramatically enhanced Database Publishing Wizard as well as the new Database Publishing Services. Major enhancements to the Database ...(truncated)...
SQL Express SP2 - November CTP now available
(Indexed 2006-11-07):
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 from the Microsoft Download Center:SQL Express SP2 CTPSQL Express with Advanced Services SP2 CTPSQL Express Toolkit SP2 CTPThese CTPs are not for production distribution, but you should ...(truncated)...
Getting things working on Vista (aka - Dealing with User Account Control)
(Indexed 2006-10-11):
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 way to go for those who can wait, but if you can't, deploying SP1 is supported. - Mike--------------------------------------------------------...(truncated)... of my co-workers called me the other ni...(truncated)...
"Windows is searching for devenv.exe" when launching BIDS
(Indexed 2006-09-27):
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. ResolutionRedirect the BIDS shortcut to the location where devenv.exe actually exists.From the Start menu, choose Search.Search for "devenv.exe"Record the location where you find it.On the Start menu, right-click the shortcut from BIDS.Enter the...(truncated)...
Configuring SQL Express During Installation
(Indexed 2006-09-20):
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 command line parameters that can configure many aspects of SQL Express directly during the installation process. The compressed installer file used by SQL Express (SQLEXPR_ADV.EXE for ...(truncated)...
Source code for Embedding Webcast (Finally)
(Indexed 2006-08-21):
At long last, I've posted the code for the embedding web cast. I've made a few changes to the code from what I showed in the webcast, here are some details about implementation and alternatives you can consider when thinking about this. Alternative Databases When I first put this webcast together, SQL Express was the primary database for creating end-user, data bound application in Visual Studio 2005. Since then, SQL Server 2005 Everywhere Edition has become available in CTP. For single user, lo...(truncated)...