[SOLVED] Sitecore 9 update 1 XP0 topology ‘sqlcmd’ is not recognized error

A week ago, I was trying to provision a Sitecore 9 Update 1 XP0 topology and everything was great, until the step

CreateShardApplicationDatabaseServerLoginSqlCmd

As you can see, it complains that sqlcmd is not recognized as the name of the cmdlet. This is quite odd, as the Sitecore 9 Installation Guide does not mention anything about it.

I wasn’t convinced that it would be sqlcmd, so I posted a question on the Sitecore StackExchange – as usual, when you get stuck after a couple of attempts… you should also try whenever you find yourself stuck (don’t be shy :))

While waiting for the community, I started digging in and googled “sql server 2016 sqlcmd download” hoping to easily install the sqlcmd without needing the full SQL Server installed on the web server, right?

I found that two things would be necessary

• Microsoft ODBC Driver 13 for SQL Server
• Microsoft Command Line Utilities 13 for SQL Server

Once I had both installed, it was simply a matter of re-running the XP0 and getting my Sitecore 9 Update 1 up & running smoothly!

Of course I posted this as an answer on Sitecore StackExchange, check out here! And as soon as the answer was there, a Sitecore employee – Kieran Marron – commented saying that

“Unfortunately this was missed off the docs for update 1. We’re aiming to have this corrected soon.”

Thanks for your reply Kieran, really appreciate it! So, stay tuned to see a fix for that anytime soon.

I hope you liked it, and thanks for reading!

And I’ll see you on my next post!