Forums Read-only archive

Connect to SQL Server 2005 error....

2 posts · Brekeke SIP Server Forum

Eric Original post
1. Brekeke Product Name and version:
Brekeke SIP Server , Version 2.4.3.9 Evaluation
2. Java version:
JRE 1.6.0_20
3. OS type and the version:
Windows Server 2003 std
4. UA (phone), gateway or other hardware/software involved:

5. Select your network pattern from http://www.brekeke-sip.com/bbs/network/ ... terns.html :

6. Your problem:
I can't make a connect to sql server 2005 and the error is as the follow words:
2010-04-22 15:53:43,328 [http-18080-Processor23] ERROR (?:?) -
com.brekeke.net.sip.sv.registrar.RegisteredDBCanNotOpenException: Connection error jdbc:sqlserver://10.2.22.4:1433;DatabaseName=SIP; prop={user=sa, password=*****, url=jdbc:sqlserver://10.2.22.4:1433;DatabaseName=SIP, enabled=on, driver=com.microsoft.sqlserver.jdbc.SQLServerDriver, class=com.brekeke.net.sip.sv.registrar.plugins.RegisteredSqlDB}
at com.brekeke.net.sip.sv.registrar.plugins.RegisteredSqlDB.getConnection(Unknown Source)
at com.brekeke.net.sip.sv.registrar.plugins.RegisteredSqlDB.initConnection(Unknown Source)
at com.brekeke.net.sip.sv.registrar.plugins.RegisteredSqlDB.open(Unknown Source)
at com.brekeke.net.sip.sv.registrar.plugins.RegisteredSqlDB.<init>(Unknown Source)
at com.brekeke.sipadmin.SipAdminBase.initDatabase(Unknown Source)
at com.brekeke.sipadmin.SipAdminBase.startServer(Unknown Source)
at com.brekeke.sipadmin.web.ServerInvoker.exec(Unknown Source)
at com.brekeke.web.Bean.execMain(Unknown Source)
at com.brekeke.sipadmin.SipAdminBase.execMain(Unknown Source)
at com.brekeke.web.Bean.execute(Unknown Source)
at com.brekeke.web.Bean.go(Unknown Source)
at com.brekeke.web.Bean.startBean(Unknown Source)
at com.brekeke.web.GateServlet.performTask(Unknown Source)
at com.brekeke.web.GateServlet.doPost(Unknown Source)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:647)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:172)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:174)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:875)
at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528)
at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689)
at java.lang.Thread.run(Unknown Source)
hope
did you put Driver under webapps\proxy\WEB-INF\lib\?
is there any firewall at 10.2.22.4? you may need to set to let other pc connect to the db.
and does the db user sa have the privilage to access the db SIP?