SSMA for Access - Connection to SQL Access failed

In the management portal use the link named "View SQL Database connection strings..."

Then use the connection string for ADO.NET in the "additional connection parameters" at the "Connect to Server" dialog in SSMS.

January 31st, 2015 4:56am

Hi All,

Uber noob here, I tried to use the SQL server migration for access to migrate my database over to SQL Azure. I created a database in Azure and when use SSMA, I get an error of Connection to SQL Azure failed. Username / PWD is invalid.

I used the same login for azure so don't see why that is an issued.

Do I need to add another user login for SQL Azure?

Thanks.

Free Windows Admin Tool Kit Click here and download it now
January 31st, 2015 6:19am

NVM this answered it. https://social.msdn.microsoft.com/Forums/en-US/9e46c1d8-2d4d-41c2-8bf2-adace3a8bd24/failed-to-establish-connection-to-database?forum=ssdsgetstarted
  • Marked as answer by Tomato13 12 hours 9 minutes ago
January 31st, 2015 3:00pm

NVM this answered it. https://social.msdn.microsoft.com/Forums/en-US/9e46c1d8-2d4d-41c2-8bf2-adace3a8bd24/failed-to-establish-connection-to-database?forum=ssdsgetstarted
  • Marked as answer by Tomato13 Saturday, January 31, 2015 7:58 PM
January 31st, 2015 10:58pm

NVM this answered it. https://social.msdn.microsoft.com/Forums/en-US/9e46c1d8-2d4d-41c2-8bf2-adace3a8bd24/failed-to-establish-connection-to-database?forum=ssdsgetstarted
  • Marked as answer by Tomato13 Saturday, January 31, 2015 7:58 PM
Free Windows Admin Tool Kit Click here and download it now
January 31st, 2015 10:58pm

NVM this answered it. https://social.msdn.microsoft.com/Forums/en-US/9e46c1d8-2d4d-41c2-8bf2-adace3a8bd24/failed-to-establish-connection-to-database?forum=ssdsgetstarted
  • Marked as answer by Tomato13 Saturday, January 31, 2015 7:58 PM
January 31st, 2015 10:58pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics