Home > Uncategorized > Setting up SQL server Azure

Setting up SQL server Azure

This is my experience with setting up SQL server Azure (2008), pretty difficult, and very buggy, to be honest,
my feeling is to stay away from the CTP, but here’s my ‘walkthrough’

I got this email a few days ago:

Welcome to the SQL Azure CTP!  We are excited to have you join us.  Below are
some steps to get you started, as well as links to helpful resources. 


 Getting Started

1)     Visit https://sql.azure.com

2)     Sign in with a valid Windows LiveID

3)     Enter your invitation code

 Your invitation code is:

 4)     Create your SQL Azure Server (and

 So I stepped through the process, and set up an Azure database, then I found that I needed SQL server 2008 to connect to it,

I downloaded  SQLManagementStudio_x86_ENU.exe from

During Install, said that I needed to reboot… when I had, so a work around was:

# Open Regedit
# Find the key "HKEY_LOCAL_MACHINESYSTEMCurrentControlSetControlSession Manager"
# Rename the "PendingFileRenameOperations" value to "PendingFileRenameOperations2"
# Re-Run the checks

Downloaded powershell:


Uninstalled SQL server management studio express

Uninstalled Visual studio 2008

It then crashed with this error:

TITLE: SQL Server Setup failure.

SQL Server Setup has encountered the following error:

Unable to generate a temporary class (result=1).
error CS0006: Metadata file ‘C:WINDOWSassemblyGAC_MSILMSClusterLib1.0.0.0__89845dcd8080cc91MSClusterLib.dll’ could not be found

Error code 0x84B10001.




Deleted the PendingFileOperations Registry Key


Tried to Connect:

Server=tcp:yitwxb6n0v.ctp.database.windows.net;Database=master;User ID=fiach;Password=myPassword;Trusted_Connection=False; Server=tcp:yitwxb6n0v.ctp.database.windows.net;Database=;User ID=fiach;Password=myPassword;Trusted_Connection=False; Copy to clipboard
Driver={SQL Server};Server=tcp:yitwxb6n0v.ctp.database.windows.net;Database=master;Uid=fiach;Pwd=myPassword; Driver={SQL Server};Server=tcp:yitwxb6n0v.ctp.database.windows.net;Database=;Uid=fiach;Pwd=myPassword; Copy to clipboard

TITLE: Connect to Server

Cannot connect to yitwxb6n0v.ctp.database.windows.net.


An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)


Invalid object name ‘sys.configurations’. (Microsoft SQL Server, Error: 208)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.00.9006&EvtSrc=MSSQLServer&EvtID=208&LinkId=20476



Fixed using this post:


1. cancel out of the first connection dialog that pops up.
2. click on the New Query button from the toolbar (upper left)
3. entered
       Server name: full servername
       Login: just the username (no @…)
4. Under Options, Connect to Database, (type your database here)
5. Hit connect.

And I got in… after an hour.

Now to figure out how to copy the databases!

Categories: Uncategorized
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: