SQL Connector to SQL 2005 Server instance

[Former Member]

Hi,

I need to make a SQL connector to one of the instances on SQL Server 2005.

There is no issue with the connector pointing to the SQL Server 2005. when we try connector to one of the instances on the same server we get errors.

error mainly says server instance cannot be found.

any information in this regard will be of great help.

Thanks and Regards

Prashant Kiran

[jamie_cawley]

Are you using the 2005 driver? If not you'll need it. Search on the forums for more information. It has been posted many times.

Jamie

[Former Member]

Hi Jamie,

If the Drivers are not proper even the connector to the 2005 server should also fail. but they work fine. I have problem when I try to make a connector to Instance on the server.

Any ways I will check the Drivers.

Regards,

Prashant Kiran

[Former Member]

Prashant,

Please post the summary information for the connection

[Former Member]

Here is the summary Information

Connector IDBC

ConnectorType SQL

DatePrefix '

DateSuffix '

Description Illuminator test Database

Enabled true

InitCommand

InternalDateFormat yyyy-MM-dd HH:mm:ss

JDBCDriver com.microsoft.sqlserver.jdbc.SQLServerDriver

Name SQL_test

PoolMax 100

PoolSize 1

ServerPackage com.lighthammer.Illuminator.connectors.IDBC

ServerURL jdbc:sqlserver://Servername\Instancename:1433?:database=test_db&sql7=true

Timeout 15

UseCount 256

UserName User

ValidationQuery SELECT GETDATE()

WaitTime 30

And the error i get is

Unable to create connection pool for SQL_test: Fatal error while filling connection pool for jdbc:sqlserver://Servername\Instancename:1433?:database=test_db&sql7=true

Regards,

A Prashant Kiran

[jamie_cawley]

Looks like your URL has an error after the port. You also don't need the last item.

try

jdbc:sqlserver://Servername\Instancename:1433;database=test_db

[Former Member]

Hi,

The Problem was with the url.

below url works for me.

jdbc:sqlserver://<ServerName>;instanceName=<Instancename>;portName=1433;database=<test>

Please note that

<ServerName> should be replaced by your servername. tagging <> is not required.

similarly instance and database names.

Regards,

A Prashant Kiran