Can not open third party database - SQL server 2005

[adimgankema]

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

[janP]

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 .

[adimgankema]

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

[janP]

I'm glad to know it