Reporting errors I found during install process for the "Explore Azure Synapse Analytics" exercise

Question

I consistently get the errors below each time I run the "./setup.ps1" command in the "dp-203/Allfiles/labs/01" directory that is set up after running "git clone https://github.com/MicrosoftLearning/dp-203-azure-data-engineer dp-203". The errors appear to only affect the object creation on the Dedicated SQL Pool database "sqlxxxxxxx", as the database and systems objects exists, but no views or tables used in the exercise "Use a dedicated SQL Pool to query a data warehouse" are created.

All elements needed for the other exercises work perfectly after installation.

Consol text segment containing the errors:

Creating the sql20v5bin database...

sqlcmd: /home/eric/dp-203/Allfiles/labs/01/setup.ps1:208

Line |

208 | sqlcmd -S "$synapseWorkspace.sql.azuresynapse.net" -U $sqlUser -P $sq …

 |  ~~~~~~

 | **The term 'sqlcmd' is not recognized as a name of a cmdlet, function, script file, or executable program. Check the spelling of the name, or if a path was included, verify that the path is correct and try again.**

Loading data...

/home/eric/dp-203/Allfiles/labs/01/data/DimCurrency.txt

bcp: /home/eric/dp-203/Allfiles/labs/01/setup.ps1:217

Line |

217 | bcp dbo.$table in $file -S "$synapseWorkspace.sql.azuresynapse.ne …

 |      ~~~

 | **The term 'bcp' is not recognized as a name of a cmdlet, function, script file, or executable program. Check the spelling of the name, or if a path was included, verify that the path is correct and try again.**

/home/eric/dp-203/Allfiles/labs/01/data/DimCustomer.txt

bcp: /home/eric/dp-203/Allfiles/labs/01/setup.ps1:217

Line |

217 | bcp dbo.$table in $file -S "$synapseWorkspace.sql.azuresynapse.ne …

 |      ~~~

 | **The term 'bcp' is not recognized as a name of a cmdlet, function, script file, or executable program. Check the spelling of the name, or if a path was included, verify that the path is correct and try again.**

/home/eric/dp-203/Allfiles/labs/01/data/DimDate.txt

bcp: /home/eric/dp-203/Allfiles/labs/01/setup.ps1:217

Line |

217 | bcp dbo.$table in $file -S "$synapseWorkspace.sql.azuresynapse.ne …

 |      ~~~

 | **The term 'bcp' is not recognized as a name of a cmdlet, function, script file, or executable program. Check the spelling of the name, or if a path was included, verify that the path is correct and try again.**

/home/eric/dp-203/Allfiles/labs/01/data/DimGeography.txt

bcp: /home/eric/dp-203/Allfiles/labs/01/setup.ps1:217

Line |

217 | bcp dbo.$table in $file -S "$synapseWorkspace.sql.azuresynapse.ne …

 |      ~~~

 | **The term 'bcp' is not recognized as a name of a cmdlet, function, script file, or executable program. Check the spelling of the name, or if a path was included, verify that the path is correct and try again.**

/home/eric/dp-203/Allfiles/labs/01/data/DimProduct.txt

bcp: /home/eric/dp-203/Allfiles/labs/01/setup.ps1:217

Line |

217 | bcp dbo.$table in $file -S "$synapseWorkspace.sql.azuresynapse.ne …

 |      ~~~

 | **The term 'bcp' is not recognized as a name of a cmdlet, function, script file, or executable program. Check the spelling of the name, or if a path was included, verify that the path is correct and try again.**

/home/eric/dp-203/Allfiles/labs/01/data/DimProductCategory.txt

bcp: /home/eric/dp-203/Allfiles/labs/01/setup.ps1:217

Line |

217 | bcp dbo.$table in $file -S "$synapseWorkspace.sql.azuresynapse.ne …

 |      ~~~

 | **The term 'bcp' is not recognized as a name of a cmdlet, function, script file, or executable program. Check the spelling of the name, or if a path was included, verify that the path is correct and try again.**

/home/eric/dp-203/Allfiles/labs/01/data/DimProductSubCategory.txt

bcp: /home/eric/dp-203/Allfiles/labs/01/setup.ps1:217

Line |

217 | bcp dbo.$table in $file -S "$synapseWorkspace.sql.azuresynapse.ne …

 |      ~~~

 | **The term 'bcp' is not recognized as a name of a cmdlet, function, script file, or executable program. Check the spelling of the name, or if a path was included, verify that the path is correct and try again.**

/home/eric/dp-203/Allfiles/labs/01/data/DimPromotion.txt

bcp: /home/eric/dp-203/Allfiles/labs/01/setup.ps1:217

Line |

217 | bcp dbo.$table in $file -S "$synapseWorkspace.sql.azuresynapse.ne …

 |      ~~~

 | **The term 'bcp' is not recognized as a name of a cmdlet, function, script file, or executable program. Check the spelling of the name, or if a path was included, verify that the path is correct and try again.**

/home/eric/dp-203/Allfiles/labs/01/data/DimSalesTerritory.txt

bcp: /home/eric/dp-203/Allfiles/labs/01/setup.ps1:217

Line |

217 | bcp dbo.$table in $file -S "$synapseWorkspace.sql.azuresynapse.ne …

 |      ~~~

 | **The term 'bcp' is not recognized as a name of a cmdlet, function, script file, or executable program. Check the spelling of the name, or if a path was included, verify that the path is correct and try again.**

/home/eric/dp-203/Allfiles/labs/01/data/FactInternetSales.txt

bcp: /home/eric/dp-203/Allfiles/labs/01/setup.ps1:217

Line |

217 | bcp dbo.$table in $file -S "$synapseWorkspace.sql.azuresynapse.ne …

 |      ~~~

 | **The term 'bcp' is not recognized as a name of a cmdlet, function, script file, or executable program. Check the spelling of the name, or if a path was included, verify that the path is correct and try again.**

Pausing the sql20v5bin SQL Pool...

This question is related to the following Learning Module

Answer 1

Hi EricMackey-4121,

regarding the installation errors you encountered during the "Explore Azure Synapse Analytics" exercise. Here are some steps to help resolve the issue:

1.Administrative Access: Confirm that you have an Azure subscription with administrative-level access, which is essential for managing resources effectively.

2.Check Resource Groups: Please ensure that you delete any unwanted resource groups in your Azure portal to avoid potential conflicts. 

3.Register Resource Providers:

• Follow the instructions provided in the link below to register the required resource providers: Azure Resource Providers and Types
• Specifically, ensure that you register for Microsoft.Compute, as this is often necessary for virtual machine operations as shown in the below screenshot:

4.Retry the Exercise: After completing the above steps, please retry the exercise. This should help in resolving the installation errors you are facing.

We also tried it on our end and were able to get a positive result, as shown in the screenshot below:

5. Install sqlcmd: The error indicates that the sqlcmd utility is not recognized. You can install it by following the official Microsoft documentation here. 

6.Use Invoke-Sqlcmd as an Alternative: If sqlcmd is unavailable, consider using Invoke-Sqlcmd in PowerShell. Ensure the SqlServer module is installed by running:

Install-Module -Name SqlServer -Scope CurrentUser    Import-Module SqlServer

You can test the connection with:

Invoke-Sqlcmd -Query "SELECT @@VERSION" -ServerInstance "YourServer\Instance" 

7. Troubleshooting Connection Issues: If you face any network-related errors, please verify:

• The server instance name is correct.
• SQL Server is configured to allow remote connections.

If the information is helpful, please Accept Answer & Upvote so that it would be helpful to other community members.