Unable to connect to Local host/dbc

Connectivity

Unable to connect to Local host/dbc

Hi Every one , I'm a new seed in the teradata & interested very much in it .Hence I Installed Teradata Studio Express Version: 14.02.0.201302060123  and JDK and trying to create and connect new data Base and getting the below Error : 

Could not connect to localhost.

Error creating SQL Model Connection connection to localhost. (Error: [Teradata JDBC Driver] [TeraJDBC 14.00.00.21] [Error 1000] [SQLState 08S01] Login failure for Connection to localhost Wed Jul 17 21:23:54 IST 2013 socket orig=localhost cid=7dfed370 sess=0 java.net.ConnectException: Connection refused: connect   at java.net.DualStackPlainSocketImpl.waitForConnect(Native Method)   at java.net.DualStackPlainSocketImpl.socketConnect(Unknown Source)   at java.net.AbstractPlainSocketImpl.doConnect(Unknown Source)   at java.net.AbstractPlainSocketImpl.connectToAddress(Unknown Source)   at java.net.AbstractPlainSocketImpl.connect(Unknown Source)   at java.net.PlainSocketImpl.connect(Unknown Source)   at java.net.SocksSocketImpl.connect(Unknown Source)   at java.net.Socket.connect(Unknown Source)   at com.teradata.jdbc.jdbc_4.io.TDNetworkIOIF$ConnectThread.run(TDNetworkIOIF.java:969)  )

[Teradata JDBC Driver] [TeraJDBC 14.00.00.21] [Error 1000] [SQLState 08S01] Login failure for Connection to localhost Wed Jul 17 21:23:54 IST 2013 socket orig=localhost cid=7dfed370 sess=0 java.net.ConnectException: Connection refused: connect   at java.net.DualStackPlainSocketImpl.waitForConnect(Native Method)   at java.net.DualStackPlainSocketImpl.socketConnect(Unknown Source)   at java.net.AbstractPlainSocketImpl.doConnect(Unknown Source)   at java.net.AbstractPlainSocketImpl.connectToAddress(Unknown Source)   at java.net.AbstractPlainSocketImpl.connect(Unknown Source)   at java.net.PlainSocketImpl.connect(Unknown Source)   at java.net.SocksSocketImpl.connect(Unknown Source)   at java.net.Socket.connect(Unknown Source)   at com.teradata.jdbc.jdbc_4.io.TDNetworkIOIF$ConnectThread.run(TDNetworkIOIF.java:969)  

Error creating Teradata Database connection to localhost. (Error: [Teradata JDBC Driver] [TeraJDBC 14.00.00.21] [Error 1000] [SQLState 08S01] Login failure for Connection to localhost Wed Jul 17 21:23:56 IST 2013 socket orig=localhost cid=ded424c sess=0 java.net.ConnectException: Connection refused: connect   at java.net.DualStackPlainSocketImpl.waitForConnect(Native Method)   at java.net.DualStackPlainSocketImpl.socketConnect(Unknown Source)   at java.net.AbstractPlainSocketImpl.doConnect(Unknown Source)   at java.net.AbstractPlainSocketImpl.connectToAddress(Unknown Source)   at java.net.AbstractPlainSocketImpl.connect(Unknown Source)   at java.net.PlainSocketImpl.connect(Unknown Source)   at java.net.SocksSocketImpl.connect(Unknown Source)   at java.net.Socket.connect(Unknown Source)   at com.teradata.jdbc.jdbc_4.io.TDNetworkIOIF$ConnectThread.run(TDNetworkIOIF.java:969)  )

[Teradata JDBC Driver] [TeraJDBC 14.00.00.21] [Error 1000] [SQLState 08S01] Login failure for Connection to localhost Wed Jul 17 21:23:56 IST 2013 socket orig=localhost cid=ded424c sess=0 java.net.ConnectException: Connection refused: connect   at java.net.DualStackPlainSocketImpl.waitForConnect(Native Method)   at java.net.DualStackPlainSocketImpl.socketConnect(Unknown Source)   at java.net.AbstractPlainSocketImpl.doConnect(Unknown Source)   at java.net.AbstractPlainSocketImpl.connectToAddress(Unknown Source)   at java.net.AbstractPlainSocketImpl.connect(Unknown Source)   at java.net.PlainSocketImpl.connect(Unknown Source)   at java.net.SocksSocketImpl.connect(Unknown Source)   at java.net.Socket.connect(Unknown Source)   at com.teradata.jdbc.jdbc_4.io.TDNetworkIOIF$ConnectThread.run(TDNetworkIOIF.java:969)  

DB Details : DataBase Server Name  : localhost

                    User Name : dbc

                    Password : dbc

                    data base : localhost

Please help me, I know I'm missing something but I don't  know what it is ? 

6 REPLIES
Teradata Employee

Re: Unable to connect to Local host/dbc

Teradata Studio [Express] is a client tool. You'll need a Teradata database server also. Install Teradata Express for VMWare on your PC, if you don't have access to an actual Teradata system.

N/A

Re: Unable to connect to Local host/dbc

I am also going through same problem where I have installed server successfully but still problem as faced by @sankmar

Could not connect to Local Teradata Database.

Error creating SQL Model Connection connection to Local Teradata Database. (Error: [Teradata JDBC Driver] [TeraJDBC 15.00.00.09] [Error 1000] [SQLState 08S01] Login failure for Connection to localhost Mon Dec 28 23:28:17 EST 2015 socket orig=localhost cid=ac13b15 sess=0 java.net.ConnectException: Connection refused  at java.net.PlainSocketImpl.socketConnect(Native Method)  at java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:351)  at java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:213)  at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:200)  at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:366)  at java.net.Socket.connect(Socket.java:529)  at com.teradata.jdbc.jdbc_4.io.TDNetworkIOIF$ConnectThread.run(TDNetworkIOIF.java:1186) )

[Teradata JDBC Driver] [TeraJDBC 15.00.00.09] [Error 1000] [SQLState 08S01] Login failure for Connection to localhost Mon Dec 28 23:28:17 EST 2015 socket orig=localhost cid=ac13b15 sess=0 java.net.ConnectException: Connection refused  at java.net.PlainSocketImpl.socketConnect(Native Method)  at java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:351)  at java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:213)  at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:200)  at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:366)  at java.net.Socket.connect(Socket.java:529)  at com.teradata.jdbc.jdbc_4.io.TDNetworkIOIF$ConnectThread.run(TDNetworkIOIF.java:1186)

Error creating Teradata Database connection to Local Teradata Database. (Error: [Teradata JDBC Driver] [TeraJDBC 15.00.00.09] [Error 1000] [SQLState 08S01] Login failure for Connection to localhost Mon Dec 28 23:28:17 EST 2015 socket orig=localhost cid=1e0ed5b2 sess=0 java.net.ConnectException: Connection refused  at java.net.PlainSocketImpl.socketConnect(Native Method)  at java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:351)  at java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:213)  at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:

Re: Unable to connect to Local host/dbc

Hi,

I have the same problem. Is it possible to install Teradata Express for VMWare in windows 10 platform?

Junior Contributor

Re: Unable to connect to Local host/dbc

Of course, it's supported on any platform running VMWare.

But don't try to connect to localhost, you need the VM's ip-address: open a Terminal window in the VM and run ifconfig eth0 to find it out.

Re: Unable to connect to Local host/dbc

I tried to create new connection profile using Teradata studio Express and filled with following details.

Database Server Name: Ip address of VM.

User Name[Domain]: root

Password: root

Is this correct credentials?  root is login credentials of my VM. 

I got Ping failed exception when we use the mentioned login credentials. 

And also How to ensure server is running for VM?

 

Junior Contributor

Re: Unable to connect to Local host/dbc

Did you read the links found on the download site?

E.g. Introduction to Teradata Express for VMware Player

 

user: dbc

password: dbc