Skip to content
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

Can't connect to MS SQL Server 2019 by Docker #334

Closed
NilkOne opened this issue Feb 15, 2022 · 1 comment
Closed

Can't connect to MS SQL Server 2019 by Docker #334

NilkOne opened this issue Feb 15, 2022 · 1 comment
Labels
bug Something isn't working

Comments

@NilkOne
Copy link

NilkOne commented Feb 15, 2022

What happened

Hello,

I try to use TLBS but I get errors,
How to params the query connection ?

User: bob
Password: secret
Server #1 Host: SRV-DEV-TEST
Server #2 Host: localhost
Server#2 with instance name : SQL_ABC_19

Connection to Server #1 :

docker run ghcr.io/k1low/tbls doc sqlserver://bob:secret@SRV-DEV-TEST:1433

invalid DSN: parse sqlserver://bob:secret@SRV-DEV-TEST:1433 -> &dburl.URL{URL:url.URL{Scheme:"sqlserver", Opaque:"", User:(*url.Userinfo)(0xc0004bc180), Host:"SRV-DEV-TEST:1433", Path:"", RawPath:"", ForceQuery:false, RawQuery:"", Fragment:"", RawFragment:""}, OriginalScheme:"sqlserver", Transport:"tcp", Driver:"sqlserver", Unaliased:"sqlserver", DSN:"Password=secret;Port=1433;Server=SRV-DEV-TEST;User ID=bob", hostPortDB:[]string{"SRV-DEV-TEST", "1433", ""}}

Connection to Server #2 :

docker run ghcr.io/k1low/tbls doc sqlserver://bob:secret@localhost:1433/SQL_ABC_19

C:\Users\kevin>docker run ghcr.io/k1low/tbls doc sqlserver://bob:secret@localhost:1433/SQL_ABC_19
unable to open tcp connection with host 'localhost:1433': dial tcp 127.0.0.1:1433: connect: connection refused

I precise that I can connect to servers by using SQL Service Management Studio

Environment

  • tbls version v1.54.2
  • Database version : Microsoft SQL Server 2019 - 15.0.2080.9 (X64)
  • OS : Windows 10
  • Shell : bash
@NilkOne NilkOne added the bug Something isn't working label Feb 15, 2022
@k1LoW
Copy link
Owner

k1LoW commented Feb 16, 2022

This is a duplicate of #237 (comment), so I'll close it.

@k1LoW k1LoW closed this as completed Feb 16, 2022
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working
Projects
None yet
Development

No branches or pull requests

2 participants