XMII Connection to MSSQL Database

[Former Member]

Hi,

I'm trying to connect a MSSQL database via the IDBC connector but have not been able to access any of the tables in the SQL database. When looking through the log I keep getting a "unable to create connection pool" message. After copying the standard data server settings all I changed was the url and the username and password. Is there any settings which need to be changed on SQL Server to allow the connection. Does anyone have any documentation on how to setup an IDBC connection.

Thanks,

Mahwish

Log Excerpt:

Unable to create connection pool: Fatal error while filling connection pool Receive timed out at java.net.PlainDatagramSocketImpl.receive(Native Method) at java.net.DatagramSocket.receive at com.inet.tds.TdsDriver.a(Unknown Source) at com.inet.tds.TdsDriver.connect(Unknown Source) at java.sql.DriverManager.getConnection at java.sql.DriverManager.getConnection at com.lighthammer.Illuminator.tools.database.ConnectionPool.createConnectionObject(Unknown Source) at com.lighthammer.Illuminator.tools.database.ConnectionPool.fill(Unknown Source)

[jamie_cawley]

What version/service pack level of sql server are you using? Is TCP/IP an enabled protocol? This driver does not support named pipes.

Regards,

Jamie

[Former Member]

I'm using Microsoft SQL Server Management Studio Express 9.00.2047.00

Currently I have the "Using both TCP/IP and named pipes" option but I tried with just TCP/IP option but it did not work.

[Former Member]

I think I have found the issue. The default TCP/IP port was not configured.

To configure I started the 'SQL Server Configuration Manager' , under protocols I right clicked on TCP/IP > Properties and set a port. I am able to connect after that and see the list of tables.

Thanks.