Welcome to MSDN Blogs Sign in | Join | Help

July 2004 - Posts

SQL Express Beta 2 available now!

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.aspx Read More...
Posted Monday, July 26, 2004 2:26 PM by sqlexpress | 11 Comments
Filed under:

FAQ: How to connect to SQL Express from "downlevel clients"(Access 2003, VS 2003, VB 6, etc(basically anything that is not using .Net 2.0 or the new SQL Native Client))

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 Type the following Read More...
Posted Friday, July 23, 2004 1:09 AM by sqlexpress | 26 Comments
Filed under:

Various Downloads of Samples and Documentation for SQL Express

MSDN has a downloads page specific to express: http://www.microsoft.com/downloads/details.aspx?FamilyID=2adbc1a8-ae5c-497d-b584-eab6719300cd&displaylang=en -Euan Garden Product Unit Manager SQL Server Tools Read More...
Posted Thursday, July 22, 2004 2:00 AM by sqlexpress | 1 Comments
Filed under: ,

SQL Express Beta 2 coming soon

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, Read More...
Posted Wednesday, July 21, 2004 8:27 PM by sqlexpress | 20 Comments
Filed under: ,

SQL Server 2005 Express Edition won't install on my Brazilian Portuguese OS

The SQL Server Setup team has verified that this is a bug. We are currently investigating, but at this point we do not have a workaround. Further updates will be provided via this weblog as they become available. -Jeffrey Baker SQL Server Setup Developmen Read More...
Posted Tuesday, July 20, 2004 3:23 PM by sqlexpress | 2 Comments
Filed under:

Sample: VB.Net Express and SQL Express Music Manager on MSDN

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 Tools Read More...
Posted Monday, July 12, 2004 8:27 PM by sqlexpress | 11 Comments
Filed under:

FAQ: Why do I get warnings about IIS and COM+ during the install of SQL Express, is something wrong?

No nothing is wrong, the current builds SQL Server Express uses the same pre-requisite checks that the main SQL Server 2005 release does, except they are warnings instead of blocks. There is not problem in not having IIS for example. These checks will Read More...
Posted Thursday, July 08, 2004 2:21 AM by sqlexpress | 2 Comments
Filed under:

FAQ: SQL Server 2000 Reporting Services fails after installing SQL Server 2005

After installing any component of SQL Server 2005 Beta 2 or Visual Studio 2005 Beta 1 on a computer with an existing installation of SQL Server 2000 Reporting Services, Reporting Services may fail with the following error: The report server cannot decrypt Read More...
Posted Wednesday, July 07, 2004 7:10 PM by sqlexpress | 0 Comments
Filed under:

FAQ: Installing SQL Express side by side with SQL 2000 Enterprise Manager seems to break it, its still broken when I uninstall express, whats going on?

Because of changes in the SQL Server 2005 metadata we have updated SQLDMO, the new version is SQLDMO9, it should work with SQL Server 7/2000 and 2005. For backwards compatibility it is installed by SQL Express so that existing DMO apps should just work. Read More...
Posted Sunday, July 04, 2004 9:39 PM by sqlexpress | 7 Comments
Filed under:

FAQ: How do I write objects in Managed code, the beta 1 samples/docs on the web don't work with SQL Express?

The syntax for much of SQLCLR was changed between B1 and the current builds to make it more consistent. Building SQLCLR objects in Visual Studio 2005 is really easy as we have new project types, but the Express SKUs of VS do not include this project type Read More...
Posted Sunday, July 04, 2004 9:29 PM by sqlexpress | 9 Comments
Filed under: ,

FAQ: Can I redistribute SQL Express?

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/product Read More...
Posted Sunday, July 04, 2004 9:17 PM by sqlexpress | 7 Comments
Filed under:

FAQ: How do I start playing with data in SQL Express, there don't seem to be any sample databases

SQL Express currently does not ship with any sample databases to help keep the size down, we'll be making these formally available on the web in the future but the folks over at ASP.Net have a nice tutorial that includes using the pubs database, so they Read More...
Posted Sunday, July 04, 2004 9:15 PM by sqlexpress | 4 Comments
Filed under:

Introducing SQL Server Express Manager

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 Read More...
Posted Friday, July 02, 2004 11:46 PM by sqlexpress | 39 Comments
Filed under:

Networking is disabled by default

After seeing a number of issues about this, I realized that we needed to comment on this. For SQL Express, all networking protocols except shared memory are disabled by default. There is a command line setup switch called DISABLENETWORKPROTOCOLS which Read More...
Posted Friday, July 02, 2004 10:18 PM by sqlexpress | 4 Comments
Filed under: ,

The Installation Summary Log

I thought I'd let you know about the summary log file available to you from the installer. Summary.txt is a summary of the latest installation and can be found under %ProgramFiles%\Microsoft SQL Server\Setup Bootstrap\LOG . It will contain paths to all Read More...
Posted Thursday, July 01, 2004 8:55 PM by sqlexpress | 1 Comments

Licensing and Pricing for SQL Server Express

We just received a great question requesting information on the pricing and licensing for SQL Server Express when it RTMs. SQL Server Express will be free to use and redistribute. The only requirement that we have is that you register to redistribute Read More...
Posted Thursday, July 01, 2004 1:43 PM by sqlexpress | 6 Comments
Filed under:

Difference between SQL Server Express and MSDE

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: SQL Server Read More...
Posted Thursday, July 01, 2004 1:09 PM by sqlexpress | 16 Comments
Filed under:

Welcome to the SQL Server Express Blog

Welcome to our team blog for SQL Server Express. In this blog we post answers, to frequently asked questions from our newsgroup (see below) and try to address any general questions or issues from the community. Newsgroup: http://communities.microsoft.com/newsgroups/default.asp?icp=sqlserver2005&slcid=us Read More...
Posted Thursday, July 01, 2004 12:05 PM by sqlexpress | 0 Comments
Filed under:
 
Page view tracker