Cannot succesfully get our Linux NOC to connect to a MS-SQL instance for
Data Integration.

1) Tried to create a database definition using the type "Microsoft SQL
Server", Schema "Extrenal" and cannot get a successful connection.

so we tried:

2) Created a DB connection by using the type "Other", and setting up
the jdbc driver class & url. Also added the sqljdbc4.jar to /classes/ext
for the Database Driver. This was successful for the DB defintion, but
this DB connection isn't exposed when using the Data Integrator to map
out the data.

So, what is the proper procedure for having a Linux NOC connect to a
MS-SQL DB for BDI purposes?

sys1kmt's Profile:
View this thread: