Jump to content

How do you connect to a SQLServer Instance.


Recommended Posts

  • 4 months later...

Try either TIBCO provided driver or SQL server driver.

driver - com.microsoft.sqlserver.jdbc.SQLServerDriver

URL - jdbc:sqlserver://:;databaseName=

driver - tibcosoftwareinc.jdbc.sqlserver.SQLServerDriver

URL - jdbc:tibcosoftwareinc:sqlserver://:;databaseName=

Link to comment
Share on other sites

  • 3 years later...

A few years too late but maybe this will help someone else.

 

When connecting to a SQL Server instance (I'm assuming you have more than one instance on a machine) the instances are running on different ports. So instead of using the standard 1433 port you will need to use the port number you setup for the sql server.

The easiest way to find it is

USE master

GO

xp_readerrorlog 0, 1, N'Server is listening on'

GO

Link to comment
Share on other sites

×
×
  • Create New...