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.
Technology Tips and News
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.
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.