-
Notifications
You must be signed in to change notification settings - Fork 750
New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
Issue Full-Text Search is not installed, or a full-text component cannot be loaded. on windows container #161
Comments
How did you add the full-text feature to your container? I am using image "microsoft/mssql-server-windows-developer" and this feature is not installed out of the box. I am struggling now on how I can add this feature for an existing instance. I know via GUI this can be done. There might be also some ways to install a new instance from command line whith specific options. But I don't know a way to add features from command line to an existing instance (installation). |
You would need to use the published Dockerfile and change the command line parameters to include the features you want and then build your own image. |
@twright-msft I managed to successfully change the command line parameters to include FullText for the Developer version. However, this does not work for the SQL Server Express version. Example Docker file: Any reason why this is? I had assumed that SQL Server Express supported Full Text search... |
Glad to hear that you got FTS working in the Developer Edition. Sorry, Express Edition doesnt have FTS in it. |
If anyone else ends up here, adding FTS to SQL Server on Linux seems a little easier as there's no need to edit and rebuild the
I guess you can do the same and modify the previous installation on Windows with the downloaded |
If you are trying to do this on Linux please use the full dockerfile example here: |
is this new for 2017? i'm pretty sure previous releases of express had fts. EDIT: yeah, the above quote from the Microsoft SQL Server program manager is clearly wrong: SQL Server with Advanced Services does include FTS. |
@twright-msft Would it be possible to tweak your Dockerfile with FTS to use SQL Server 2014 instead of 2017? I'm not sure what I should change! EDIT : Oh well... If I understand properly, only >= 2017 is supported... |
@electrotype - the Dockerfile you pointed to is only for SQL Server on Linux. SQL Server on Linux was first released in SQL Server 2017. You could try to tweak this Dockerfile and get FTS running on Windows containers. You would need to change the URL for the .box and .exe in the ENV variables at the top of the Dockerfile to point to the SQL Server 2014 versions of those files. |
I've revised the steps I posted above: apt-get update
apt-get install --yes curl apt-transport-https
curl --fail --silent --show-error --location https://packages.microsoft.com/keys/microsoft.asc | gpg --dearmor | tee /usr/share/keyrings/microsoft-archive-keyring.gpg > /dev/null
curl --fail --silent --show-error --location https://packages.microsoft.com/config/ubuntu/16.04/mssql-server-2017.list | sed "s@arch=amd64@arch=amd64 signed-by=/usr/share/keyrings/microsoft-archive-keyring.gpg@" | tee /etc/apt/sources.list.d/mssql-server.list > /dev/null
apt-get update
apt-get install --yes mssql-server-fts The difference between this and the |
Regarding the Linux image: Since Microsoft has changed how the Docker images are build, installing
And then
|
I've just added the full text search feature to the docker file install step, but then I had to follow these instructions: https://social.technet.microsoft.com/wiki/contents/articles/31786.sql-server-not-starting-after-fresh-installation.aspx |
I created a fork a while ago. Maybe this helps you: |
@pulla2908, it is interesting that you don't add the additional steps noted by the article. I wonder if it has to do with your use of server 2019 instead of 2016. |
@JesseKPhillips I immediately moved to 2019 because I wanted to have the latest version. Then I modified the setup to get full text index feature. Maybe this issue is connected to the windows server version but I have no further information about this. |
I am having the same problem with RHEL 7 and SQL Server 2019. fts is installed yet SQL Server doesn't recognize it: Full-Text Search is not installed, or a full-text component cannot be loaded. |
1> select @@Version Microsoft SQL Server 2019 (RTM) - 15.0.2000.5 (X64) (1 rows affected) |
@skinfrakkijm
|
Trying to deploy a WINDOWS based 2019 SQL Express docker container with FTS. |
@raviumishra don't know why it is not working for you but in case SQL Server 2017 is also an option for you then you can use my docker definition which you can find here. |
@pulla2908 Need to use SQL 2019 |
@raviumishra A while ago I was searching for box and env download URLs in order to move from SQL Server 2017 (Developer) to 2019 but I did not find them. If something can tell me how to get these URLs then I could update my docker definition. @raviumishra for you I don't know if e.g. Developer Edition is an option at all. However, I struggle with getting the URLs. |
Here is my solution with docker compose and sql 2019 express. I'm using the official image from ms (mcr.microsoft.com/mssql/server:2019-latest) and install mssql-server-fts by the Dockerfile. Works perfectly. docker-compose.yml: volumes: networks: Dockerfile: FROM mcr.microsoft.com/mssql/server:2019-latest USER root ;# Install curl since it is needed to get repo config RUN export DEBIAN_FRONTEND=noninteractive && ;# Install optional packages. Comment out the ones you don't need ;# Run SQL Server process |
i cant believe this issue is 7 years old... 🤦 |
@haras-unicorn see my post |
i dont care about random forks theres a bunch of those already on docker hub - id rather have my own dockerfile |
Hey Guy,
I found this error when I added full-text search to my container.
How can I solve it ??
Thank you in advance.
The text was updated successfully, but these errors were encountered: