I've read through the different posts in here, and done everything that peaople suggest. Apparently I'm not the only one with this problem.
When adding MSSQL monitoring in OpManager 6.0 I do not get a response from the server when testing them. I've started the SQLAgent service that has been suggested.