I've created a basic SQL sensor to run a query and check the response. As soon as I start the sensor I get a timeout error.
Steps I've taken:
- create a windows user with DB read access mapping for Database X within MS SQL server. - create a simple "select" query and the output is "4" - logon into SQL server and login with DB read user and run the query, the output shows "4". - create a basic SQL Sensor for DB X and type in the same select query. Authentication type: Windows authentication. - Select credentials: a user account with domain admin membership. - OS: Windows W2K12 and SQL 2008 Server.
I Saved the sensor, wait for a minute and then shows a timeout error.
Is it something I'm overlooking here?