locked
Not able to upload SQL Server database to SQL Azure RRS feed

  • Question

  • hi,
    We have been trying to create our database in SQL Azure using SQLAzureWM exe ver 3.1 but it throws some exception when trying to connect.
    Our Server is tcp:sokqguf6d4.database.windows.net

    Please do let us know how can we resolve this issue.


    Thursday, December 31, 2009 10:32 AM

Answers

  • Hi, 
          Did you enable access from your IP address by setting SQL Azure firewall? If you have already do it, can you please try SSMS (SQL Server 2008 R2 Nov CTP), and/or let us know the detailed error message? It would help us to narrow down the problem.

    Thank you!

    Gary
    Thursday, January 7, 2010 9:07 AM

All replies

  • There is another way to create database. You could script your database after choosing the target as SQL Azure in Options | Tools and run the script on your SQL Azure.

    I guess you have no problem connecting to SQL Azure.
    mysorian
    Friday, January 1, 2010 6:22 AM
  • Although SQLAzureMW is not an official Microsoft project (CodePlex tools are supported as sample code and may not work in every situation), it shouldn't fail to connect.  What is the error message you get when you try to connect with SQLAzureMW?  Can you connect with Management Studio or other applications?

    Evan
    Sunday, January 3, 2010 10:46 PM
  • Hi, 
          Did you enable access from your IP address by setting SQL Azure firewall? If you have already do it, can you please try SSMS (SQL Server 2008 R2 Nov CTP), and/or let us know the detailed error message? It would help us to narrow down the problem.

    Thank you!

    Gary
    Thursday, January 7, 2010 9:07 AM