Author |
Message |
adimgankema Brekeke Newbie
Joined: 24 Jun 2008 Posts: 3
Location: Germany
|
Posted: Tue Jun 24, 2008 11:00 am Post subject: Can not open third party database - SQL server 2005 |
|
|
1. Brekeke Product Name and version:
SIP server 2.1 Trial Version (!)
2. Java version:
Java SE JRE 5.0 update 15
3. OS type and the version:
Windows XP SP3
4. UA (phone), gateway or other hardware/software involved:
Microsoft SQL Server 2005 - 9.00.1399.00
Microsoft SQL Server 2005 JDBC Driver - sqljdbc_1.2
5. Select your network pattern from http://www.brekeke-sip.com/bbs/network/networkpatterns.html :
6. Your problem:
Hello,
I am trying to connect to a third party database - MS SQL server 2005.
The error message is 'Can not open the registered-DB.. etc'.
First I have copied the sqljdbc.jar file in the following directory:
C:\Program Files\Brekeke\proxy\webapps\proxy\WEB-INF\lib
just as mentioned in the 'Using a Third-Party Database Tutorial'.
Afterwards I have tried numerous combinations of Database URL's and Database Drivers, here just a few:
jdbc:sqlserver://localhost/Bingo
com.microsoft.sqlserver.jdbc.SQLServerDriver
jdbc:sqlserver://localhost:1433;DatabaseName=Bingo
com.microsoft.sqlserver.jdbc.SQLServerDriver
jdbc:sqlserver://localhost;DatabaseName=Bingo
com.microsoft.sqlserver.jdbc.SQLServerDriver
(Bingo is the name of the database)
Does the problem has to do with the Trial Version or is it something else, any suggestions?
Thank you on beforehand.
Adim Mark |
|
Back to top |
|
janP Brekeke Master Guru
Joined: 25 Nov 2007 Posts: 336
|
Posted: Fri Jun 27, 2008 3:47 pm Post subject: |
|
|
At first.. Did you restart the server?
If you are using a firewall (e.g. Norton), you need to open the database port there, or disable the firewall . |
|
Back to top |
|
adimgankema Brekeke Newbie
Joined: 24 Jun 2008 Posts: 3
Location: Germany
|
Posted: Sat Jun 28, 2008 12:37 am Post subject: |
|
|
Hello Jan, thank you for your reply.
I tried all of your suggestions, these were not the issue, however you brought me to look again and try a few things, and it works now!
To cut the story short, in my case the Service SQL server Browser needs to be running. It seems it has to do with remote connections.
(start -> control panel -> Administrative Tools -> Services -> SQL Server Browser)
The Microsoft error description page that helped me out:
http://www.microsoft.com/products/ee/transform.aspx?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=-1
Thanks again, enjoy |
|
Back to top |
|
janP Brekeke Master Guru
Joined: 25 Nov 2007 Posts: 336
|
Posted: Thu Jul 03, 2008 7:09 pm Post subject: |
|
|
I'm glad to know it |
|
Back to top |
|
|