SQL Server 2005 June CTP and Visual Studio 2005 Beta 2
Got to install the latest updates to both SQL Server 2005 June CTP and Visual Studio 2005 Beta 2. Initially, I was apprehensive that the two will not work together, since I had heard through the grapevines that they are not compatible. However, if you are creating a new virtual PC image for installing these applications or are starting afresh on a new machine, the recommended order is as follows:
- Install SQL Server 2005 June CTP
- Install Visual Studio 2005 Beta 2
This order will ensure that the two applications will work together. The main difference to note for is that the .NET Framework 2.0 version number is different.
If you have an existing VPC containing older versions of SQL Server 2005 (for example, the April CTP), you can then use the information provided in the following link: Installing SQL 2005 June CTP on a computer with VS 2005 Beta 2.
One caveat that I found when I installed the June CTP of SQL Server 2005 was that my service broker applications did not work by default. When I checked the sys.transmission_queue system table, I had an error that said that the “session keys for the database could not be accessed...”. On poking around the readme, I found that you had to run this statement in the database where you are testing:
CREATE MASTER KEY ENCRYPTION BY PASSWORD = '<password>'.
Post this, everything started working. If you do not want to do this, you will need to set ENCRYPTION=OFF in all your dialogs. Anyways, the June CTP looks cooll with some new features (especially the new reports that are accessible in the summary page) etc.
Will be playing around with these builds for sometime now, since I heard and read that the next CTP of VS 2005 will not be compatible with the June CTP! Better use my time constructively :-)