Smartstore icon indicating copy to clipboard operation
Smartstore copied to clipboard

Docker installation problems

Open Macka323 opened this issue 3 years ago • 6 comments

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

Macka323 avatar Sep 01 '22 21:09 Macka323

Servername mysql and sqlserver work for me.

zihniartar avatar Sep 06 '22 15:09 zihniartar

But do you host sql with docker or you install it on your operating system

Macka323 avatar Sep 07 '22 13:09 Macka323

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.

muratcakir avatar Sep 07 '22 21:09 muratcakir

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.

zihniartar avatar Sep 08 '22 12:09 zihniartar

yes they have been started

Macka323 avatar Sep 08 '22 12:09 Macka323

if you use our yml files, you can use the container_name as database server name, so mysql or sqlserver. Just tried it.

zihniartar avatar Sep 09 '22 11:09 zihniartar