Hi,
I am new to nopCommerce and trying my hands at it. I am able to get the docker environment up ad running along with the store and admin site. However, i am unable to connect to the sql server using the management studio installed on the host ?
Has anyone faced this issue ? as the site is running fine i am sure that the database is up and running and the website container is also able to connect to it.
I am using windows 10 machine and have installed the management studio standalone.
Unable to connect to SQL
- 1
- 2
MVP
Certified Developer
- 579
- 4849
- 10/23/2015
- United States
it could be any number of things, assuming you are trying to connect with the same values in the connection string from the webDOTconfig file, go through the checklist here to get started: https://stackoverflow.com/questions/12774827/cant-connect-to-localhost-on-sql-server-express-2012-2016
when you say you are using Windows 10, is that the OS of the server or are you trying to connect to the server remotely from a Windows 10 machine?
when you say you are using Windows 10, is that the OS of the server or are you trying to connect to the server remotely from a Windows 10 machine?
MVP
Gold Solution Partner
Certified Developer
- 2139
- 22181
- 7/23/2009
- India
I will recommend you to go through mssql docker guide first. You might be doing something wrong!
- 10
- 60
- 6/1/2020
- United Arab Emirates
af1racing wrote:
I am using a windows 10 client machine as a host with docker containers for the sql server and nop web store.
it could be any number of things, assuming you are trying to connect with the same values in the connection string from the webDOTconfig file, go through the checklist here to get started: https://stackoverflow.com/questions/12774827/cant-connect-to-localhost-on-sql-server-express-2012-2016
when you say you are using Windows 10, is that the OS of the server or are you trying to connect to the server remotely from a Windows 10 machine?
when you say you are using Windows 10, is that the OS of the server or are you trying to connect to the server remotely from a Windows 10 machine?
I am using a windows 10 client machine as a host with docker containers for the sql server and nop web store.
- 10
- 60
- 6/1/2020
- United Arab Emirates
santoshkmrsingh wrote:
Thanks for sharing the link but i believe that this link refers to SQL on a windows server and not a linux container.
it could be any number of things, assuming you are trying to connect with the same values in the connection string from the webDOTconfig file, go through the checklist here to get started: https://stackoverflow.com/questions/12774827/cant-connect-to-localhost-on-sql-server-express-2012-2016
when you say you are using Windows 10, is that the OS of the server or are you trying to connect to the server remotely from a Windows 10 machine?
I am using a windows 10 client machine as a host with docker containers for the sql server and nop web store.
when you say you are using Windows 10, is that the OS of the server or are you trying to connect to the server remotely from a Windows 10 machine?
I am using a windows 10 client machine as a host with docker containers for the sql server and nop web store.
Thanks for sharing the link but i believe that this link refers to SQL on a windows server and not a linux container.
MVP
Gold Solution Partner
Certified Developer
- 2139
- 22181
- 7/23/2009
- India
santoshkmrsingh wrote:
Most probably it might be related to port mapping/unavailable, firewall or wrong hostname. Your website is inside same docker or same network in docker, so it can access database but your management studio is not!
Hi,
I am new to nopCommerce and trying my hands at it. I am able to get the docker environment up ad running along with the store and admin site. However, i am unable to connect to the sql server using the management studio installed on the host ?
Has anyone faced this issue ? as the site is running fine i am sure that the database is up and running and the website container is also able to connect to it.
I am using windows 10 machine and have installed the management studio standalone.
I am new to nopCommerce and trying my hands at it. I am able to get the docker environment up ad running along with the store and admin site. However, i am unable to connect to the sql server using the management studio installed on the host ?
Has anyone faced this issue ? as the site is running fine i am sure that the database is up and running and the website container is also able to connect to it.
I am using windows 10 machine and have installed the management studio standalone.
Most probably it might be related to port mapping/unavailable, firewall or wrong hostname. Your website is inside same docker or same network in docker, so it can access database but your management studio is not!
- 10
- 60
- 6/1/2020
- United Arab Emirates
nopAccelerate.com wrote:
true enough the firewall was on, i switched off the firewall and restarted the laptop to no luck. still having the same issue.
Hi,
I am new to nopCommerce and trying my hands at it. I am able to get the docker environment up ad running along with the store and admin site. However, i am unable to connect to the sql server using the management studio installed on the host ?
Has anyone faced this issue ? as the site is running fine i am sure that the database is up and running and the website container is also able to connect to it.
I am using windows 10 machine and have installed the management studio standalone.
Most probably it might be related to port mapping/unavailable, firewall or wrong hostname. Your website is inside same docker or same network in docker, so it can access database but your management studio is not!
I am new to nopCommerce and trying my hands at it. I am able to get the docker environment up ad running along with the store and admin site. However, i am unable to connect to the sql server using the management studio installed on the host ?
Has anyone faced this issue ? as the site is running fine i am sure that the database is up and running and the website container is also able to connect to it.
I am using windows 10 machine and have installed the management studio standalone.
Most probably it might be related to port mapping/unavailable, firewall or wrong hostname. Your website is inside same docker or same network in docker, so it can access database but your management studio is not!
true enough the firewall was on, i switched off the firewall and restarted the laptop to no luck. still having the same issue.
- 1
- 2