I would like to be informed about what exactly I need to fill in the fields (I am using SQL server windows Authentication, metabase on docker). I am getting the following msg: error in connecting to server.
Host ( is it localhost:3000 ? )
Port (where do I get this from?)
Database name ( is it the name of the database where my table of data exists? I am using master in my case)
Database instance name (is it what I find after machine\ on the sql server info)?
Database username (is it my windows username)
Database password ( is it windows password)
Database username and Database password is the authentication. So it could be your Windows credentials, but if you’ve created logins (see the first link), then you would use those.
Thank you very much. I entered all fields as required but I am still getting: server connection error. I believe it might have to do with “opening firewall rules to allow connections” you mentioned in your reply.
The Docker host IP is my local machine but what is the metabase container host ? Is it localhost:3000 and where do I need to connect the two hosts on firewall settings (is it: Specify the computers between which secured connections will be established using IPsec)? can you send me a snapshot? thanks
Your Docker host IP is usually a different IP from your local physical machine.
And the Metabase container will also have it’s own IP. localhost is a system controlled name, which normally refers to 127.0.0.1
I don’t know your setup. You need to read a lot more about Docker and how to manage that.
Otherwise try using the JAR-file instead, if that’s easier.