Ad Widget

Collapse

Zabbix and MSSQL Server

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Sn0wF0x
    Junior Member
    • Jul 2024
    • 1

    #1

    Zabbix and MSSQL Server

    Hello,

    Me and My Buddy tried to use Zabbix.

    We have a MSSQL Server 2019 on Windows Server 2022 and tried to make zabbix read the databases

    following was used as settings:

    {$MSSQL.INSTANCE} MSSQL$MSSQLSERVER
    {$MSSQL.PASSWORD} <password>
    {$MSSQL.PORT} 1433
    {$MSSQL.URI} mssql://<servername>:1433
    {$MSSQL.USER} <the user we assigned for this>

    We use the template:

    MSSQL by Zabbix agent 2

    The Error is:

    The TCP port of the MSSQL Server service is currently unavailable.

    I tried the following:

    - Changing the User for the db
    - Double/Tripple Checked the Permissions
    - Tried to install odbc driver on zabbix (without success I think)
    - created exceptions in the windows firewall for all ports that are nessesary

    Please Help I am really in a despair
Working...