<div>
Fantastic answer Lowfatspread! Thank you so very much!
</div>


Fantastic answer Lowfatspread! Thank you so very much!

<div>
<div class="content wysiwyg-content">
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:<br />
<br />
bcp databasename.dbo.tablename<wbr /> format nul -x -f c:/localstoragepath/Format<wbr />FileName.x<wbr />ml -n -S myservername.database.wind<wbr />ows.net -Umyusername -Pmypassword -T<br />
<br />
The error returned is:<br />
Server name cannot be determined. It must appear as the first segment of the server's dns name (servername.database.windo<wbr />ws.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<br />
<br />
Can anyone point out the problem with my bcp command parameters? Thanks!
</div>
</div>


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!

Remote SQL Azure Database BCP Connection Problem

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.

Microsoft SQL Server 2008

Microsoft Azure is a cloud computing platform and infrastructure for building, deploying and managing applications and services through datacenters. It provides both platform-as-a-service (PaaS) and infrastructure-as-a-service (IaaS) services and supports many different programming languages, tools and frameworks, including both Microsoft-specific and third-party software and systems. Cloud Services is a PaaS environment and can be used to create scalable applications and services; there are specific software development kits (SDKs) provided by Microsoft for Python, Java, Node.js and .NET. Azure also has file and storage services, data management, analytics and DNS services.