Welcome Serena Central users! CLICK HERE
The migration of the Serena Central community is currently underway. Be sure to read THIS MESSAGE to get your new login set up to access your account.
Anonymous_User Absent Member.
Absent Member.
1115 views

Linux NOC to MS-SQL


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
------------------------------------------------------------------------
sys1kmt's Profile: http://forums.novell.com/member.php?userid=94263
View this thread: http://forums.novell.com/showthread.php?t=452528

Labels (1)
0 Likes
3 Replies
Anonymous_User Absent Member.
Absent Member.

Re: Linux NOC to MS-SQL


Typically you would choose to create a new database connection, then
select SQL Server as the type. You would need to enter the machine
name in the Hostname field, or IP address if it doesn't resolve. Port,
Database, user, etc are all required. Keep in mind, by default, the
JDBC driver requires the native SQL Server connection and it will not
use the Windows Authentication method.

If you have a default install of SQL, it is not set up for sql types of
user access, it is also most likely not sitting on a known port (ie:
1433).

We are looking at how we can enhance the JDBC connection to allow
windows authentication.


--
tisenberg
------------------------------------------------------------------------
tisenberg's Profile: http://forums.novell.com/member.php?userid=56548
View this thread: http://forums.novell.com/showthread.php?t=452528

0 Likes
Anonymous_User Absent Member.
Absent Member.

Re: Linux NOC to MS-SQL


I'm wondering if part of the problem is that we run multiple instances
running on the same node. You connect with the instance name, but all
Instances respond from the same port. What are the proper ways to fill
out the hostname/database fields for a setup like this? We normally
connect like: SQLD1-LD000.xxx.xxx.com\LD000


We were successful if we used jtds, using
jdbc:jtds:sqlserver://sqld1-ld000.xxx.xxx.com:1433/our_db;instance=ld000


--
sys1kmt
------------------------------------------------------------------------
sys1kmt's Profile: http://forums.novell.com/member.php?userid=94263
View this thread: http://forums.novell.com/showthread.php?t=452528

0 Likes
Anonymous_User Absent Member.
Absent Member.

Re: Linux NOC to MS-SQL


I *think* you can add the instance to the database setting. So in the
database field, enter: our_db;instance=ld000


--
tisenberg
------------------------------------------------------------------------
tisenberg's Profile: http://forums.novell.com/member.php?userid=56548
View this thread: http://forums.novell.com/showthread.php?t=452528

0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.