For Data Science, SQL Server 17 has optional built in R functionality.
It also has the ability to call R Studio from within SQL Server.
The prerequisite is reliable connectivity between SQL Server and R Studio.
Here are the steps to configure SQL Server and R to work with each other.
After a simple installation of SQL Server 17, on my Windows 10 laptop, I now have three different names for my host machine. And two different names for my SQL Server.
These have caused me a lot of grief and wasted time.
Here are some methods to identify the different names and help troubleshoot.