am.mssql.databaseserver.config Error when attempting to create a MSSQL monitor
I'm attempting to create a MSSQL monitor for a named SQL Server instance, using SQL Server Authentication. The 'Test Credential' button returns a cryptic '
Failed. am.mssql.databaseserver.config' error. I have numerous other SQL Server monitors that I've configured successfully using identical methods. Cannot find a clue what the issue is by checking SQL Server Error or Windows Event logs. I also checked the Appmanager stderr logs - I do see the following error messages immediately after testing the 'Test Credential' button:
[03 Dec 2013 12:16:26:049] SYS_ERR: java.sql.SQLException: Network error IOException: Connection refused: connect
[03 Dec 2013 12:16:26:049] SYS_ERR:
at net.sourceforge.jtds.jdbc.ConnectionJDBC2.<init>(ConnectionJDBC2.java:385)
[03 Dec 2013 12:16:26:049] SYS_ERR:
at net.sourceforge.jtds.jdbc.ConnectionJDBC3.<init>(ConnectionJDBC3.java:50)
[03 Dec 2013 12:16:26:049] SYS_ERR:
at net.sourceforge.jtds.jdbc.Driver.connect(Driver.java:182)
[03 Dec 2013 12:16:26:049] SYS_ERR:
at com.adventnet.appmanager.server.mssql.datacollection.ScheduleMsSQLDataCollection.CheckAuthentication(ScheduleMsSQLDataCollection.java:157)
[03 Dec 2013 12:16:26:049] SYS_ERR:
at com.adventnet.appmanager.struts.actions.NewMonitorConf.getAuthResultAsPerResourceType(NewMonitorConf.java:2362)
[03 Dec 2013 12:16:26:049] SYS_ERR:
at com.adventnet.appmanager.struts.actions.TestCredentials.testCredentialForConfMonitors(TestCredentials.java:40)
[03 Dec 2013 12:16:26:049] SYS_ERR:
at sun.reflect.GeneratedMethodAccessor282.invoke(Unknown Source)
[03 Dec 2013 12:16:26:049] SYS_ERR:
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
[03 Dec 2013 12:16:26:049] SYS_ERR:
at java.lang.reflect.Method.invoke(Unknown Source)
[03 Dec 2013 12:16:26:049] SYS_ERR:
at org.apache.struts.actions.DispatchAction.dispatchMethod(DispatchAction.java:280)
[03 Dec 2013 12:16:26:050] SYS_ERR:
at org.apache.struts.actions.DispatchAction.execute(DispatchAction.java:216)
[03 Dec 2013 12:16:26:050] SYS_ERR:
at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484)
[03 Dec 2013 12:16:26:050] SYS_ERR:
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274)
[03 Dec 2013 12:16:26:050] SYS_ERR:
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482)
[03 Dec 2013 12:16:26:050] SYS_ERR:
at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:525)
[03 Dec 2013 12:16:26:050] SYS_ERR:
at javax.servlet.http.HttpServlet.service(HttpServlet.java:641)
[03 Dec 2013 12:16:26:050] SYS_ERR:
at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
[03 Dec 2013 12:16:26:050] SYS_ERR:
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:304)
[03 Dec 2013 12:16:26:050] SYS_ERR:
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
[03 Dec 2013 12:16:26:050] SYS_ERR:
at com.adventnet.appmanager.filter.ExtProdIntegFilter.doFilter(ExtProdIntegFilter.java:98)
[03 Dec 2013 12:16:26:050] SYS_ERR:
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
[03 Dec 2013 12:16:26:050] SYS_ERR:
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
[03 Dec 2013 12:16:26:050] SYS_ERR:
at com.adventnet.appmanager.filter.AAMFilter.doFilter(AAMFilter.java:96)
[03 Dec 2013 12:16:26:050] SYS_ERR:
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
[03 Dec 2013 12:16:26:050] SYS_ERR:
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
[03 Dec 2013 12:16:26:050] SYS_ERR:
at com.adventnet.appmanager.filter.UriCollector.doFilter(UriCollector.java:537)
[03 Dec 2013 12:16:26:050] SYS_ERR:
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
[03 Dec 2013 12:16:26:050] SYS_ERR:
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
[03 Dec 2013 12:16:26:050] SYS_ERR:
at com.adventnet.appmanager.filter.LoadTimeCalculator.doFilter(LoadTimeCalculator.java:41)
[03 Dec 2013 12:16:26:050] SYS_ERR:
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
[03 Dec 2013 12:16:26:050] SYS_ERR:
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
[03 Dec 2013 12:16:26:050] SYS_ERR:
at com.adventnet.appmanager.filter.SessionFilter.doFilter(SessionFilter.java:153)
[03 Dec 2013 12:16:26:050] SYS_ERR:
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
[03 Dec 2013 12:16:26:050] SYS_ERR:
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
[03 Dec 2013 12:16:26:050] SYS_ERR:
at com.adventnet.nms.webclient.i18n.EncodingFilter.doFilter(EncodingFilter.java:70)
[03 Dec 2013 12:16:26:050] SYS_ERR:
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
[03 Dec 2013 12:16:26:050] SYS_ERR:
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
[03 Dec 2013 12:16:26:050] SYS_ERR:
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:224)
[03 Dec 2013 12:16:26:050] SYS_ERR:
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:185)
[03 Dec 2013 12:16:26:050] SYS_ERR:
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472)
[03 Dec 2013 12:16:26:050] SYS_ERR:
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:151)
[03 Dec 2013 12:16:26:050] SYS_ERR:
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:100)
[03 Dec 2013 12:16:26:050] SYS_ERR:
at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:929)
[03 Dec 2013 12:16:26:050] SYS_ERR:
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
[03 Dec 2013 12:16:26:050] SYS_ERR:
at com.adventnet.appmanager.tomcatagent.ver5.valve.AdventNetHostValve.invoke(AdventNetHostValve.java:63)
[03 Dec 2013 12:16:26:050] SYS_ERR:
at com.adventnet.appmanager.tomcatagent.ver5.valve.BadInputFilterValve.invoke(BadInputFilterValve.java:128)
[03 Dec 2013 12:16:26:050] SYS_ERR:
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:405)
[03 Dec 2013 12:16:26:050] SYS_ERR:
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:269)
[03 Dec 2013 12:16:26:050] SYS_ERR:
at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:515)
[03 Dec 2013 12:16:26:050] SYS_ERR:
at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:300)
[03 Dec 2013 12:16:26:051] SYS_ERR:
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source)
[03 Dec 2013 12:16:26:051] SYS_ERR:
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
[03 Dec 2013 12:16:26:051] SYS_ERR:
at java.lang.Thread.run(Unknown Source)
[03 Dec 2013 12:16:26:051] SYS_ERR: Caused by: java.net.ConnectException: Connection refused: connect
[03 Dec 2013 12:16:26:051] SYS_ERR:
at java.net.PlainSocketImpl.socketConnect(Native Method)
[03 Dec 2013 12:16:26:051] SYS_ERR:
at java.net.PlainSocketImpl.doConnect(Unknown Source)
[03 Dec 2013 12:16:26:051] SYS_ERR:
at java.net.PlainSocketImpl.connectToAddress(Unknown Source)
[03 Dec 2013 12:16:26:051] SYS_ERR:
at java.net.PlainSocketImpl.connect(Unknown Source)
[03 Dec 2013 12:16:26:051] SYS_ERR:
at java.net.SocksSocketImpl.connect(Unknown Source)
[03 Dec 2013 12:16:26:051] SYS_ERR:
at java.net.Socket.connect(Unknown Source)
[03 Dec 2013 12:16:26:051] SYS_ERR:
at sun.reflect.GeneratedMethodAccessor83.invoke(Unknown Source)
[03 Dec 2013 12:16:26:051] SYS_ERR:
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
[03 Dec 2013 12:16:26:051] SYS_ERR:
at java.lang.reflect.Method.invoke(Unknown Source)
[03 Dec 2013 12:16:26:051] SYS_ERR:
at net.sourceforge.jtds.jdbc.SharedSocket.createSocketForJDBC3(SharedSocket.java:304)
[03 Dec 2013 12:16:26:051] SYS_ERR:
at net.sourceforge.jtds.jdbc.SharedSocket.<init>(SharedSocket.java:255)
[03 Dec 2013 12:16:26:051] SYS_ERR:
at net.sourceforge.jtds.jdbc.ConnectionJDBC2.<init>(ConnectionJDBC2.java:310)
[03 Dec 2013 12:16:26:051] SYS_ERR:
... 52 more
I've verified that I am using the correct credentials and that the login has appropriate permissions. I've tried using the IP instead of the DNS name. The Windows Firewall is off. I am able to connect to SQL Server using the same credentials via SSMS.
What is the problem here?