Docker installation problems
Hello, I am tiring to install Smartstore with MS SQL, but I get this error
Setup failed: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: TCP Provider, error: 40 - Could not open a connection to SQL Server: Could not open a connection to SQL Server)
I have also tried with MySQL and same result. I have tried to connect to the database with SSMS, and it connects. I have installed another verion of SQL from the Docker marketplace, and i have connected to it with SSMS, but couldn`t with smartstore/install
I am following this guide here
Servername mysql and sqlserver work for me.
But do you host sql with docker or you install it on your operating system
We have observed a few times, that localhost fails for Docker network address resolution. But using the IP address will always work. You can obtain the database container's IP address by running docker inspect in the console. See this post for more information.
But do you host sql with docker or you install it on your operating system
you said that you use this guide : https://smartstore.atlassian.net/wiki/spaces/SMNET50/pages/1956119258/Running+Smartstore+and+Database+together+as+Docker+Containers
And there the database servers are started right away as containers.
yes they have been started
if you use our yml files, you can use the container_name as database server name, so mysql or sqlserver. Just tried it.