Installing Tensorflow package in ML services - SQL Server 2019

Kushal Guraza 1 Reputation point
2021-02-25T18:52:25.203+00:00

Hello, I am trying to install tensorflow library in my SQL Server 2019 as I use ML services.

windows 10 : python version 3.7.3 : Tensorflow latest.

  1. I tried installing a few libraries through sqlmlutils which works fine, but in case of tensorflow it fails. Found this link that supports the above. [https://learn.microsoft.com/en-us/sql/machine-learning/troubleshooting/known-issues-for-sql-server-machine-learning-services?view=sql-server-ver15#9-cannot-install-tensorflow-package-using-sqlmlutils]
  2. The document also suggest to work around using a command prompt in administrator mode, run the following command ( "C:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\PYTHON_SERVICES\python.exe" -m pip install --upgrade tensorflow ) by replacing "MSSQLSERVER" with the name of your SQL instance. In this case the tensorflow package does not reflect in my SQL Server (guessing its some path issue that has to be dealt).

Is there any other possible way to install the library or solve this nightmare?

Please help, Thank you in advance.

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,690 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Cris Zhan-MSFT 6,601 Reputation points
    2021-02-26T07:46:43.863+00:00

    Hi,

    Please check the doc. The Python package tensorflow cannot be installed using sqlmlutils.

    I successfully ran the cmd command in the link above and prompted that tensorflow was successfully installed. And I can find the related entries of tensorflow if search the folder C:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\PYTHON_SERVICES .

    Did you get any errors when you ran this command?

    > In this case the tensorflow package does not reflect in my SQL Server

    Would you please explain this a little bit, maybe someone can help.

    Sorry I am not familiar with SQL Server machine learning. Not sure if you need to manually add the Python package to the SQL instance after installing tensorflow using the cmd command.

    0 comments