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 about sqlcmd is not recognized as the name of the cmdlet. This is way weird as Sitecore 9 Installation Guide does not mention anything about it.

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

While was waiting for the community, started dig in and googled “sql server 2016 sqlcmd download” with a hope to be able to easily install the sqlcmd without need the full SQL Server installed at 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 got both installed, it was just a matter to re-run the XP0 and get my Sitecore 9 Update 1 up & running smoothly!

Of course I posted this as an answer in Sitecore StackExchange, check out here! And as soon 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!