Remote SQL Azure Database BCP Connection Problem
Posted on 2011-02-11
Hi, I'm trying to use BCP with my SQL Azure database. The following bcp call to get a format file is resulting in as error:
bcp databasename.dbo.tablename format nul -x -f c:/localstoragepath/FormatFileName.xml -n -S myservername.database.windows.net -Umyusername -Pmypassword -T
The error returned is:
Server name cannot be determined. It must appear as the first segment of the server's dns name (servername.database.windows.net). Some libraries do not send the server name, in which case the server name must be included as part of the user name (username@servername). SQLState=37000, NativeError = 40531
Can anyone point out the problem with my bcp command parameters? Thanks!