Welcome!

Related Topics: Cloud Expo, SOA & WOA, .NET

Cloud Expo: Blog Feed Post

SQL Server 2008 R2 Nov CTP Installs Easily on Windows 7

I had problems installing on Windows XP SP3 but it was very easy on Windows 7 Ultimate Evaluation copy
By Jayaram Krishnaswamy
Article Rating:
November 27, 2009 10:45 AM EST
Reads:
 958

Microsoft Developer

I had problems installing on Windows XP SP3 but it was very easy on Windows 7 Ultimate Evaluation copy (build 7100). If you have Visual Studio 2008 you may need to apply SP1 before you complete installation on Windows 7.

I installed a named instance Hodentek\KUMORI (ver 10.50.1352) which is a minor upgrade to SQL Server 2008 RTM. If you want to work with a database in the cloud
(SQL Azure) you need SQL Server 2008 R2 Nov-CTP.

SSMS treates Cloud based database like a second cousin by not offering the full
support like it does for the on the premises database. Well, well the SQL Azure looks like it is still 10.25. Is it becasuse I used the October CTP?

Notice the missing green color. For the ground based databases it provides the
full GUI but for the Cloud based database you get mostly script support that means
sharpen up your TSQL scripting skills.

Users options for Cloud based database


 

 

 

 

 

Click New User.. and you don't get a GUI window but a script template like this:







But this is a great improvement over the previous version of SQL Server 2008.

Read the original blog entry...

Published November 27, 2009 – Reads 958
Copyright © 2009 SYS-CON Media, Inc. — All Rights Reserved.
Syndicated stories and blog feeds, all rights reserved by the author.

More Stories By Jayaram Krishnaswamy

Jayaram Krishnaswamy is a technical writer, mostly writing articles that are related to the web and databases. He is the author of SQL Server Integration Services published by Packt Publishers in the UK. His recent book, 'Learn SQL Server Reporting Services 2008' was also published by Packt Publishers Inc, Birmingham. He writes articles on several topics to many sites.