Brekeke Forum Index » Brekeke SIP Server Forum

Post new topic   Reply to topic
Connect to SQL Server 2005 error....
Author Message
Eric
Brekeke Newbie


Joined: 22 Apr 2010
Posts: 1
Location: Taiwan

PostPosted: Thu Apr 22, 2010 1:08 am    Post subject: Connect to SQL Server 2005 error.... Reply with quote

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/networkpatterns.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 (?Confused) -
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)
Back to top
View user's profile
hope
Brekeke Master Guru


Joined: 15 Jan 2008
Posts: 862

PostPosted: Thu Apr 22, 2010 11:43 am    Post subject: Reply with quote

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?
Back to top
View user's profile
Display posts from previous:   
Post new topic   Reply to topic    Brekeke Forum Index » Brekeke SIP Server Forum All times are GMT - 7 Hours
Page 1 of 1