getting error while connecting to DB

[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.

[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.

[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

[vinayvemula]

raising new ticket for this issue. This thread can be locked.

[scottwilkerson]

raising new ticket for this issue. This thread can be locked.

Locking thread