Page 2 of 2
Re: getting error while connecting to DB
Posted: Mon Aug 24, 2020 5:55 am
by vinayvemula
We have made below entry in tds file for custom port 2058 but still getting the same error
[MSSQLServer1]
host = sqlserver
port = 2058
tds version = 7.3
encryption = require
Could you please let us know if we have make any other changes after this.
Re: getting error while connecting to DB
Posted: Mon Aug 24, 2020 7:16 am
by vinayvemula
We have made below entry in tds file for custom port 2058 but still getting the same error
[MSSQLServer1]
host = sqlserver
port = 2058
tds version = 7.3
encryption = require
Could you please let us know if we have make any other changes after this.
Re: getting error while connecting to DB
Posted: Tue Aug 25, 2020 9:49 am
by jbrunkow
You will need to make sure that the host name or IP address passed to the
-H option in the check command matches the entry for
host = in your configuration file.
That means that if you are specifying
sqlhost in the command, your configuration should probably look like the following.
Code: Select all
[sqlhost]
host = sqlserver
port = 2058
tds version = 7.3
encryption = require
You could also test the configuration by submitting the following command. It should rely on that same host name configuration; if that works the check should work.
Code: Select all
tsql -S sqlhost -U username -P password -L -v
Re: getting error while connecting to DB
Posted: Tue Aug 25, 2020 12:58 pm
by vinayvemula
raising new ticket for this issue. This thread can be locked.
Re: getting error while connecting to DB
Posted: Tue Aug 25, 2020 1:24 pm
by scottwilkerson
vinayvemula wrote:raising new ticket for this issue. This thread can be locked.
Locking thread