AppInsight for SQL - Applicatio​n 'MSSQLSERV​ER' has state: Unknown

bmakhmutov

All SQL Servers under monitoring show:

------

Node is Up.
AppInsight for SQL: Applicatio​n 'MSSQLSERV​ER' has state: Unknown.

------

AppInsight for SQL - I don't know how to solve it(((

Did you come across with that problem before? 

I provided all required permissions.

USE master;GRANT VIEW SERVER STATE TO [AppInsightUser];GRANT VIEW ANY DEFINITION TO [AppInsightUser];GRANT VIEW ANY DATABASE TO [AppInsightUser];EXEC sp_adduser @loginame = 'AppInsightUser', @name_in_db = 'AppInsightUser';GRANT EXECUTE ON xp_readerrorlog TO [AppInsightUser];USE msdb;EXEC sp_adduser @loginame = 'AppInsightUser', @name_in_db = 'AppInsightUser';EXEC sp_addrolemember N'db_datareader', N'AppInsightUser';

Nothing helped.

Seashore

If you go into edit application on the appinisight for SQL and press the test button, does that work? If not what info does it give you?

Have you assigned the "AppInsightUser" credentials there? Do you have the correct port configured, the one SQL is listening to?