You are here

MS SQL Server Monitor Databases

3 posts / 0 new
Last post
adam.stanforth
adam.stanforth's picture
MS SQL Server Monitor Databases

Hi I am running Atom 5.0.2 and am trying to monitor MS SQL Server.

I have installed python-pymssql and a generic checks works ok e.g

-H $HOSTADDRESS$ -U '%MSSQLCREDENTIALS:1%' -P '%MSSQLCREDENTIALS:2%' -T '%MSSQLDATABASE%' -p 1433

Returns

Output: OK:Time to connect is 0.055s|Time_to_connect=0.055s;;;;

Errors:

Return code: 0

 

But as soon as I add a parameter to the end i.e. –datasize I get the following error.

Output: CRITICAL:Can access server but cannot query.

Errors:

Return code: 2

Can anyone help with this or at least steer me in the right direction?

 

Regards

Adam

 

 

RedwoodTechnologies
RedwoodTechnologies's picture
Had a similar issue. The

Had a similar issue. The below worked for me.

sudo apt-get purge python-pymssql
sudo apt-get purge freetds-bin
sudo apt-get purge freetds-common
sudo apt-get install freetds-dev
sudo apt-get install python-pip python-dev build-essential

pip install pymssql
adam.stanforth
adam.stanforth's picture
Thank you

Thank you, that's fixed it

Much appreciated

Adam