Page 1 of 1

How to test connection to MSSQL DB from SSH

PostPosted: 27/04/2015, 18:56
by eugenio.chernolyev@wildix.com
From the shell of PBX you can use the tool "tsql" to test the connection to a database installed on Mssql server.
These are the steps :

- connect to PBX via ssh
- select menu 11 (shell)
- launch the following command :
tsql -S <server> -U <user> -P <password> -D <database>
For example :

tsql -S 192.168.1.1 -U user -P password -D test

you can specify the name of the instance the following way :
tsql -S 192.168.1.1\<INSTANCE>