Just in case you hadn't heard, VS 2005 Beta 2 is now LIVE!  It became available late Friday for MSDN Subscribers to download.  (If you aren't an MSDN Subscriber ... WHY NOT???)  The SQL Server 2005 April CTP is also live on MSDN Subscribers download and synch'd with the VS 2005 Beta 2 build. 

I downloaded it myself on Saturday morning ... this seems to have been a good time to do it as my download speed was between 100 KB/s and an amazing 290 KB/s!  And with my brand-spanking-new Plextor DVD burner (http://www.plextor.com/english/products/716SA.htm), I burned myself a DVD in about 6 minutes.  The SQL Server 2005 CTP DVD takes about 1:30.  SWEET! 

Of course, I've also installed it.  DUH!  The VS install was smooth and sweet ... I've installed it on 2 physical boxes and a VPC as well.  No problems at all.  (Don't ask about uninstall ... I haven't done that yet and don't plan to do it anytime soon.)  And yes, before you ask, all the cool toyz with VSTS are in there.  However, when installing the April SQL Server 2005 CTP after the VS install, there are no SQL Server tools.  Now, I don't know about you, but I like to play with the big boy's toyz, so that was a bummer. 

I did, however, find a workaround if you have the same install order that I had.  It seems that the installation of the SQL Server Express tools by the default VS 2005 installation is what caused the SQL Server installer to refuse to install the workstation components ... it says that they are already installed.  So, without further ado, here's what you do if you installed VS 2005 Beta 2 before the SQL Server April CTP. 

  1. Go to Add/Remove Programs.
  2. Find Microsoft SQL Server 2005 Tools Express Edition CTP in the list. 
  3. Remove.  Yes.  Remove that puppy.  That's the problem.
  4. Go to your SQL Server 2005 CTP DVD (or ISO or whatever).
  5. Find SQLRun_Tools.msi (in the Setup folder).
  6. Double-click and install all of the Client Components
  7. Enjoy all the big-boy toyz that come with SQL Server 2005! 

Now, you might be tempted (as I was) to skip the first 3 steps and go right to the tools msi.  It won't work.  It will, instead, complain that it doesn't support upgrades.  I do hope that this is resolved by RTM time (SQL Server team ... are you listening??).  I'm also guessing that if you install the SQL Server April CTP first, you won't have this issue, though I've not done this yet. 

So ... there it is.  Happy installing!