locked
SSMA unable to connect to Azure DB RRS feed

  • Question

  • I am currently in the processes of converting an access 2003 (mdb) database to SQL Azure.  I am using their SQL Server Migration Assistant 2008 for access ((32 bit) since my access is also 32 bit)).

     

    My issue arrises when I try to connect to the database named: "Test Database".  

    An error occurs stating: " Connection to SQL Azure failed.

    Cannot open database "[test database]" requested by the login.  The login failed.

    Login failed for user '***********'

    This session has been assigned a tracing ID of '******'.  Provide this tracing ID to customer support when you need assistance"

     

    I am able to connect to the test database from SSMS and query/create tables, but yet SSMA does not seem to connect, UNLESS i choose 'Master' database.  Oddly enough I can connect to the 'master' database and perform the migration setup, but it fails since master is not where these tables are supposed to go.

     

    If anyone has had these types of issues or has any advice I would love to hear what you did to solve this.  I am in contact with microsoft trying to resolve this question as well.

     

    THINGS TO NOTE:

    I have setup the firewall rules correctly on the management portal and locally for my own router's firewall/computer firewall.

    I can connect fine from SSMS to both 'master' and 'test database' without any issues.

    Tuesday, January 11, 2011 10:14 PM

Answers

  • hello,

    I tryed and get same error.

    I rearched and I got a result.
    This problem is bug.
    Because when I changed connectin to database changed from 'Test Database' to 'test' , I got success connection.

    so, SSMA cant't support database name is incled to space.

    • Proposed as answer by Raymond-Lee Friday, January 14, 2011 9:15 AM
    • Marked as answer by Raymond-Lee Thursday, January 20, 2011 8:13 AM
    Wednesday, January 12, 2011 10:53 AM