标题: 麻烦各位高手帮我看下,QC连接sqlserver失败,谢谢! [打印本页] 作者: xiangwei3280122 时间: 2011-2-25 15:02 标题: 麻烦各位高手帮我看下,QC连接sqlserver失败,谢谢! Failed to Add DBServers;
Failed to add database server 'default_实例_db';
Failed to check database version with jdbc url jdbc:mercury:sqlserver://localhost:1433 and admin sa;
[Mercury][SQLServer JDBC Driver]Error establishing socket to host and port: localhost:1433. Reason: Connection refused;
Stack Trace:
java.sql.SQLException: [Mercury][SQLServer JDBC Driver]Error establishing socket to host and port: localhost:1433. Reason: Connection refused
at com.mercury.jdbc.base.BaseExceptions.createException(Unknown Source)
at com.mercury.jdbc.base.BaseExceptions.getException(Unknown Source)
at com.mercury.jdbc.sqlserver.tds.TDSConnection.<init>(Unknown Source)
at com.mercury.jdbc.sqlserver.SQLServerImplConnection.open(Unknown Source)
at com.mercury.jdbc.base.BaseConnection.connect(Unknown Source)
at com.mercury.jdbc.base.BaseConnection.setupImplConnection(Unknown Source)
at com.mercury.jdbc.base.BaseConnection.open(Unknown Source)
at com.mercury.jdbc.base.BaseDriver.connect(Unknown Source)
at java.sql.DriverManager.getConnection(DriverManager.java:525)
at java.sql.DriverManager.getConnection(DriverManager.java:140)
at com.mercury.optane.core.db.CTdDriverManager.getConnection(CTdDriverManager.java:81)
wrapped in com.mercury.optane.core.CTdException:
at com.mercury.optane.core.db.CTdDriverManager.getConnection(CTdDriverManager.java:88)
at com.mercury.optane.core.db.CConnectionPool.newConnection(CConnectionPool.java:795)
at com.mercury.optane.core.db.CConnectionPool.tryToGetConnection(CConnectionPool.java:582)
at com.mercury.optane.core.db.CConnectionPool.getConnection(CConnectionPool.java:350)
at com.mercury.optane.core.db.CConnectionManager.getNotTransactedConnection(CConnectionManager.java:302)
at com.mercury.optane.core.db.CConnectionManager.getConnection(CConnectionManager.java:276)
at com.mercury.optane.core.db.CTdDatabaseMetaData.<init>(CTdDatabaseMetaData.java:42)
at com.mercury.optane.core.db.utils.CDbGeneralFunctions.isDbVersionSupported(CDbGeneralFunctions.java:2073)
wrapped in com.mercury.optane.core.CTdException: Failed to check database version with jdbc url jdbc:mercury:sqlserver://localhost:1433 and admin sa
at com.mercury.optane.core.db.utils.CDbGeneralFunctions.isDbVersionSupported(CDbGeneralFunctions.java:2089)
at com.mercury.td.saserver.api.logics.CDbServerLogic.addDbServer(CDbServerLogic.java:280)
wrapped in com.mercury.optane.core.CTdException: Failed to add database server 'default_实例_db'
at com.mercury.td.saserver.api.logics.CDbServerLogic.addDbServer(CDbServerLogic.java:352)
at com.mercury.td.saserver.requests.AddDBServers.execute(AddDBServers.java:26)
at com.mercury.optane.core.web.RequestsDispatcher.execute(RequestsDispatcher.java:91)
wrapped in com.mercury.optane.core.CTdException: Failed to Add DBServers
at com.mercury.optane.core.web.RequestsDispatcher.execute(RequestsDispatcher.java:98)
at com.mercury.td.web.CAbsServlet.executeFunction(CAbsServlet.java:436)
at com.mercury.td.web.CAbsServlet.processRequest(CAbsServlet.java:428)
at com.mercury.td.web.CAbsServlet.doPost(CAbsServlet.java:324)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at com.hp.qc.core.utils.gzipfilter.GZIPFilter.doFilter(GZIPFilter.java:30)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:81)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
at org.jboss.web.tomcat.security.CustomPrincipalValve.invoke(CustomPrincipalValve.java:39)
at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:153)
at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:59)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
at org.apache.catalina.valves.FastCommonAccessLogValve.invoke(FastCommonAccessLogValve.java:481)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:856)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:744)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
at org.apache.tomcat.util.net.MasterSlaveWorkerThread.run(MasterSlaveWorkerThread.java:112)
at java.lang.Thread.run(Thread.java:595)