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:
d329171f-c1fd-4060-862e-1a7f613ea8ce

 4)     Create your SQL Azure Server (and
databases)

 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
http://www.microsoft.com/DownLoads/details.aspx?familyid=08E52AC2-1D62-45F6-9A4A-4B76A8564A2B&displaylang=en

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:

http://www.microsoft.com/downloads/info.aspx?na=90&p=&SrcDisplayLang=en&SrcCategoryId=&SrcFamilyId=6ccb7e0d-8f1d-4b97-a397-47bcc8ba3806&u=http%3a%2f%2fdownload.microsoft.com%2fdownload%2f7%2f3%2f4%2f7345bb7d-0b07-40e8-9480-5b8c55b9c8b7%2fWindowsXP-KB926139-v2-x86-ENU.exe

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.

——————————
BUTTONS:

OK
——————————

Rebooted…

Deleted the PendingFileOperations Registry Key

Installed!

Tried to Connect:

ADO.NET:
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
ODBC:
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
OLE DB:
Provider=SQLNCLI10;Server=tcp:yitwxb6n0v.ctp.database.windows.net;Database=master;Uid=fiach;Pwd=myPasswor

TITLE: Connect to Server
——————————

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

——————————
ADDITIONAL INFORMATION:

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

——————————
BUTTONS:

OK
——————————

Fixed using this post:

http://social.msdn.microsoft.com/Forums/en-US/ssdsgetstarted/thread/9e5b6854-9e5a-4e7d-b771-313aa5683b72

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!

Advertisements
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 )

Google+ photo

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

Connecting to %s

%d bloggers like this: