how do you connect to Azure from SQL Server Studio

Question

i am trying to connect to Azure via the SQL Server studio but get this message:

"Cannot connect to xxxxx4kmq.database.windows.net '

additional information

Login failed for user 'mrme'.

the session has been assigned a tracing id of '35552474-0863-4fda-95bf-47b02-863576b'

Answer 1

Hello.

Did you add your IP address to SQL Azure firewall?

Check this for complete walkthrough:

http://geekswithblogs.net/ranganh/archive/2009/11/04/sql-azure-connection-error-ldquocannot-connect-to-ltservernamegtquot-client-with.aspx

Answer 2

Login failed for user 'mrme'.

Hello,

In SQL Azure portal you can copy the suggested connection string for your SQL Azure database; use this one to connect. You will see as login name the username + @dbname is used => mrme@xxxxx4kmq

 

---

Olaf Helper
* cogito ergo sum * errare humanum est * quote erat demonstrandum *
Wenn ich denke, ist das ein Fehler und das beweise ich täglich
Blog Xing