All Forums Analytics
jquinn2 1 post Joined 11/11
10 Mar 2012
Connecting remotely through TeradataR with LDAP Authentication


Hi All-


I have a puzzling situation. I've been using the TeradataR package in R to connect to my company's teradata databases for a while now, but I can't seem to figure out why I can't connect remotely. I thought when I originally started using teradataR, I could connect remotely, but I can't any more.

It seems that if I'm at work, logged in through our company's authenticated network (which requires my LDAP username and password), I have no problem connecting, but if I'm at home, I boot up my VPN and can access any other restricted site for my company, but I can't connect to teradata.


I tried including my domain in my username 


tdConnection <- dbConnect(drv, st,user = "domain\username" , password = "password")


But that doesn't seem to help at all. I continue to only get the error code below:



Error in .jcall(drv@jdrv, "Ljava/sql/Connection;", "connect", as.character(url)[1],  : 

  com.teradata.jdbc.jdbc_4.util.JDBCException: [Teradata JDBC Driver] [TeraJDBC] [Error 1000] [SQLState 08S01] Login failure for Connection to [DSN address] Sat Mar 10 16:02:20 CST 2012 socket orig=[DSN address] cid=3959199 sess=0 Permission denied: connect



Is there something I'm missing in the connection process that needs additional information?



You must sign in to leave a comment.