We had a number of questions about this at TechEd. Here's the official word:

You CAN use VSTS Beta 2 to develop with SQL Server 2005 June CTP. However, it does not work as the backend for Team Foundation Beta 2. You still need to use SQL Server 2005 April CTP for that and it was included in the Visual Studio 2005 Beta 2 DVD pack.