Sql Server 2005 October CTP Upgrade

When I upgraded my installation of beta 2 of Sql Server 2005 to the October CTP bits, I repaved my system and started over.  I had a copy of the database tables and was able to re-attach them.  I have not seen any ill-effects of doing this.

I was just reading through the Release Notes for this build and there were two things that caught my eye.

  • You can not restore a Beta 2 backup to the October CTP bits.
  • Beta 2 clients are unable to connect to a machine running the October CTP bits.

I don't think that either issue is bad, just something that you need to watch out for.

Note: Bobb @ Developmentor says that he is able to connect from a beta 2 client to an October CTP server.

Correction: the problem occurs when the beta2 app is running on the same machine with the database.

Wally

5 Comments

  • Hmmm...



    I can connect from a Beta2 client (on a Beta2 machine) to a machine running October CTP SQL Server using either ADO.NET, SNAC OLE DB or ODBC.



    Do you/they mean on a single machine after you've done an upgrade? I installed CTP on fresh machine. Or something else?



    Otherwise, works for me.

    Bob

  • Bob,



    Good response. I was just reading this and the two issues caught my eye.



    Wally

  • I believe the problem will be local to local since the two versions require different versions FX which you can't have on the same host. Don't see the problem?



    QARA, an application Lloyd Sheen wrote so the bridge for SSX, was based on B2 and is thus a B2 client. If you install the CTP, QARA breaks. And not just a little.



    And right now, he doesn't have a way of fixing it either, since he's only using the VBExpress bits. More about that problem in my Blog.

  • Ahh, never would have deduced that from the wording.



    "cannot connect to a machine running..."



    would be cleared if it had said



    "clients compiled under beta2 of the .NET runtime cannot run on a machine that has CTP version of the runtime installed"



    In certain earlier versions, the network protocol had changed in such a way that you couldn't *connect*, which is what this wording implies.

  • Clarity is both a skill and an opportunity. Many writers have the first but not the second.

Comments have been disabled for this content.