Connecting to MSSQL 2000
20 October, 2009
This maybe a silly question but how do I create a connection to MSSQL 2000 database? I installed the MSSQL 2000 JDBC driver thinking this might add it to the list of JDBC drivers in Yellowfin but with no luck.
You'll have to use the net.sourceforge.jtds.jdbc.Driver.
The URL for this driver is of the form:
jdbc:jtds:://[:][/][;=[;...]]
For example:
jdbc:jtds:sqlserver://localhost:1433/master
The default port for SQL Server is 1433.
You can find more info on the driver at http://jtds.sourceforge.net/
If you are using only Windows Authentication (ie not sa authentication) on your instance of SQL Server you will have to add the following to your URL: ;domain=
Then you put the windows username and password in the username/password box.
The URL for this driver is of the form:
jdbc:jtds:://[:][/][;=[;...]]
For example:
jdbc:jtds:sqlserver://localhost:1433/master
The default port for SQL Server is 1433.
You can find more info on the driver at http://jtds.sourceforge.net/
If you are using only Windows Authentication (ie not sa authentication) on your instance of SQL Server you will have to add the following to your URL: ;domain=
Then you put the windows username and password in the username/password box.