BCP - load data into SQLEXPRESS - localhost

[jimthereaper]

Hello,

I'm using powershell to upload data into a database which is on a localhost server (SQLEXPRESS). Can someone help me with the bcp command? I keep getting the below error:
SQLState = 08001, NativeError = -1
Error = [Microsoft][ODBC Driver 13 for SQL Server]SQL Server Network Interfaces: Error Locating Server/Instance Specified [xFFFFFFFF].
SQLState = 08001, NativeError = -1
Error = [Microsoft][ODBC Driver 13 for SQL Server]A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online.
SQLState = S1T00, NativeError = 0
Error = [Microsoft][ODBC Driver 13 for SQL Server]Login timeout expired

Thank you!

---

Document Details

⚠ Do not edit this section. It is required for docs.microsoft.com ➟ GitHub issue linking.

• ID: 5802ba59-8c08-7b41-7aec-2640cc287ae3
• Version Independent ID: 13c04835-76a2-96bc-01ad-1c0dcdf65cb0
• Content: Tutorial: Design your first Azure SQL database using SSMS
• Content Source: articles/sql-database/sql-database-design-first-database.md
• Service: sql-database
• GitHub Login: @CarlRabeler
• Microsoft Alias: carlrab

[Karishma-Tiwari-MSFT]

@anonymousReaper Thanks for your question. Can you please share the url, if there is a particular Azure doc you have been following?

[jimthereaper]

@Karishma-Tiwari-MSFT Hello Karishma, the MSFT documentation URL is https://docs.microsoft.com/en-us/azure/sql-database/sql-database-design-first-database#load-data-into-the-tables

The section which is named as Load data into the tables

[Karishma-Tiwari-MSFT]

@anonymousReaper Thank you for sharing the document. I have updated the issue with the doc details.
We are currently investigating and will update you shortly.

[CarlRabeler]

@anonymousReaper your question has nothing to do with this article. This said, I searched the internet and found this answer:

"You have to specify the Instance with SQL Express. It is installed by default into a named instance called Computername\SQLEXPRESS, or .\SQLEXPRESS or (local)\SQLEXPRESS, you probably have the point by now. So it makes alot of sense that when you do either of the following:

bcp eSpacePh1.dbo.UserProfile out UserProfile.txt -T -c -S localhost\sqlexpress
bcp eSpacePh1.dbo.UserProfile out UserProfile.txt -T -c -S mycomputername\sqlexpress"

I hope this helps.
Carl

[jimthereaper]

@CarlRabeler got it. Thanks!

[xunaphi7895]

@anonymousReaper your question has nothing to do with this article. This said, I searched the internet and found this answer:

"You have to specify the Instance with SQL Express. It is installed by default into a named instance called Computername\SQLEXPRESS, or .\SQLEXPRESS or (local)\SQLEXPRESS, you probably have the point by now. So it makes alot of sense that when you do either of the following:

bcp eSpacePh1.dbo.UserProfile out UserProfile.txt -T -c -S localhost\sqlexpress
bcp eSpacePh1.dbo.UserProfile out UserProfile.txt -T -c -S mycomputername\sqlexpress"

I hope this helps.
Carl

Thanks so much!