The data links for this page are invalid

[afast92]

Commands to load the data from links in the download folder sampleData give an error.

bcp Course in SampleCourseData -S server.database.windows.net -d database -U user -P password -q -c -t "," bcp Person in SamplePersonData -S server.database.windows.net -d database -U user -P password -q -c -t "," bcp Student in SampleStudentData -S server.database.windows.net -d database -U user -P password -q -c -t "," bcp Credit in SampleCreditData -S server.database.windows.net -d database -U user -P password -q -c -t ","

after replacing server, database, user, and password with my information, I get the following error:

SQLState = S1000, NativeError = 40532 Error = [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Cannot open server "example.com" requested by the login. The login failed.

where "example.com" is my Azure login email domain.

---

Document Details

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

• ID: f62711d0-fbed-bafa-8314-604266401b1b
• Version Independent ID: 7dc13ad2-ebb3-ffc1-e384-bc962dd0d038
• Content: Tutorial: Design your first relational database using SSMS - Azure SQL Database
• Content Source: azure-sql/database/design-first-database-tutorial.md
• Service: sql-database
• Sub-service: development
• GitHub Login: @dzsquared
• Microsoft Alias: drskwier

[dzsquared]

@afast92 can you login to your server from other tools on that machine?

[afast92]

Yes, I can access the server from Azure Data Studio and SSMS. I had previously configured the server for AD access only, but I created a new server that uses AD and SQL Server Authentication. I no longer get the invalid login error, but I get this instead

SQLState = S1000, NativeError = 0 Error = [Microsoft][ODBC Driver 17 for SQL Server]Unable to open BCP host data-file

I think my issue now is that the data file links redirect to `https://sqldbtutorial.blob.core.windows.net/tutorials/SampleCourseData

AuthorizationFailure This request is not authorized to perform this operation. RequestId:d2cb1903-601e-0036-32dc-40b3dc000000 Time:2023-02-15T01:27:39.3868496Z `

[MashaMSFT]

Hi @afast92 , thanks for bringing this to our attention! Just wanted to give you a brief update to let you know that we're working to restore access to the sample data. We apologize for the delay, and thank you for your patience as we address this issue.

Thanks! Masha from the SQL Docs team #assign:MashaMSFT

[MashaMSFT]

Hi @afast92 , thanks for contacting Microsoft and helping improve our documentation! We've processed a fix to rehost the data elsewhere which will be live later today :)

I'll go ahead and close out this Git Issue but please feel free to comment should you need anything further.

Thanks again and I hope you have a wonderful rest of your day! Masha from the SQL Docs team #please-close