SQL Azure login

Question

When using BCP to upload/download data from our SQL Azure environments.  I've noticed that no matter what you put in for you endpoint (as long as it points to a valid SQL Azure instance) that it will log you into whatever instance is valid for the login credentials you provided.

for example:

bcp MYDB.dbo.MyTable out dbo.MyTable.bcp -c -S tcp:<instance name 1>.database.windows.net -U mylogin@<instance name 2> -P "MyPassword"

The above will actually log me into the instance at <instance name 2> instead of throwing a login failure or logging me into <instance name 1>.

Answer 1

Hi 

That's good catch

I am also able to replicate it If Both SQL Azure server are in Same Data Center, having Same Database Name and having same tables, with Same User Name and Password

Its not working for 2 servers across 2 different Data Center.

---

Arunraj Chandrasekaran, MCTS, Author: SQLXpertise.com
If you found this post useful, let us know by clicking "Vote as Helpful".