Starting with SQL Server 2008 R2, SQL Server Management Studio can connect directly to SQL Azure. Minimum install to do is SQL Server Management Studio Express Edition; however any version of SQL Server (except SQL Server Express) that includes SQL Server Management Studio will work.
Here’s how to use SQL Server Management Studio to attach to SQL Azure:
1. Figure out your server name, go to SQL Azure Portal. 2. Login with your Windows Live Id 3. Click your project name. 4. You should be at Server Administration page. 5. Highlight server name in browser and copy (Ctrl-C) in your clipboard. 6. Now open SQL Server Management Studio 2008 R2. By default it’ll open Connect to Server dialog. 7. Paste in full DNS of the server stored in clipboard into Server Name. 8. In login box enter Administrator username for SQL Azure, this was on Server Administration page where you got full DNS of server from. 9. password is your SQL Azure password. 10. Click on Options >> 11. This’ll take you to Connection Properties tab, check Encrypt connection box. You should always encrypt your connection. 12. Press Connect button.