I'm out of thoughts. I tried to solve this issue on my own for two weeks but to no avail.
This is the case. I would like to use Teradata SQL on my laptop. Therefore I've installed VMware, Teradata Express, and an application to install SQL assistant.
First, I started VMware, gave the username and password root and root.
Started the teradatabase server through the command prompt in VMware. I checked if the database was running, it is. I checked my IP-address.
In ODBC I configured the database with IP-address, database name DBC and password.
When I try to connect to the database via teradatabase administrator. I get the error: " 10060 WSA E TimedOut: No Response received when attempting to connect to Teradata Server".
The internet told me to increase the login timeout, but it won't work. Others told me to increase the RAM amount to 4GB, but even 5.6GB RAM doesn't work.
I hope some of you would and could help me out.
Lots of thanks in advance,
please google search ,, with the error ..
Lots of articles will come
They will talk about different kind of solutions
You will have to find the one that works for you !!!
What os do you have on your laptop? --> OS: Windows 10
Also did you install vmware or vmware worstation? --> I installed VMware workstation 15 player
You say "I checked my IP-address." which ip address? --> In VMware workstation, I opened the command prompt, typed IFCONFIG then at the second line of eth0 it shows my IP adress with inet addr: 192.168.137.1
The network setting of VMware is NAT
Does the teradata have internet connection and can you ping it's ip address from your laptop? --> This video is great, thank you. I don't have a proper internet connection with firefox. I used the command netstat -r but it doesn't give me a default setting.
can you connect to teradatabase via any other user
can you create another user with admin privs ?? and then try to connect
.. another idea is to start from begining with everything uninstalled .. do this only in extreme case
pick up a user manual for installing and connecting and follow the user manual for installing
I created multiple users, but to no avail.
I did uninstall all the programs and reïnstalled them, but it didn't work...
That's why I don't know what's going on, it must be something with my IP-addres, but don't know what or how.
TDExpress1620_Sles11:~/Desktop # ping 192.168.137.1
PING 192.168.137.1 (192.168.137.1) 56(84) bytes of data.
64 bytes from 192.168.137.1: icmp_seq=1 ttl=64 time=0.040 ms
64 bytes from 192.168.137.1: icmp_seq=2 ttl=64 time=0.034 ms
64 bytes from 192.168.137.1: icmp_seq=3 ttl=64 time=0.079 ms
64 bytes from 192.168.137.1: icmp_seq=4 ttl=64 time=0.032 ms
64 bytes from 192.168.137.1: icmp_seq=5 ttl=64 time=0.079 ms
64 bytes from 192.168.137.1: icmp_seq=6 ttl=64 time=0.035 ms
64 bytes from 192.168.137.1: icmp_seq=7 ttl=64 time=0.079 ms
64 bytes from 192.168.137.1: icmp_seq=8 ttl=64 time=0.034 ms
64 bytes from 192.168.137.1: icmp_seq=9 ttl=64 time=0.036 ms
64 bytes from 192.168.137.1: icmp_seq=10 ttl=64 time=0.037 ms
64 bytes from 192.168.137.1: icmp_seq=11 ttl=64 time=0.028 ms
64 bytes from 192.168.137.1: icmp_seq=12 ttl=64 time=0.032 ms
64 bytes from 192.168.137.1: icmp_seq=13 ttl=64 time=0.080 ms
64 bytes from 192.168.137.1: icmp_seq=14 ttl=64 time=0.049 ms
64 bytes from 192.168.137.1: icmp_seq=15 ttl=64 time=0.069 ms
64 bytes from 192.168.137.1: icmp_seq=16 ttl=64 time=0.141 ms
64 bytes from 192.168.137.1: icmp_seq=17 ttl=64 time=0.079 ms
64 bytes from 192.168.137.1: icmp_seq=18 ttl=64 time=0.033 ms
64 bytes from 192.168.137.1: icmp_seq=19 ttl=64 time=0.059 ms
64 bytes from 192.168.137.1: icmp_seq=20 ttl=64 time=0.071 ms
64 bytes from 192.168.137.1: icmp_seq=21 ttl=64 time=0.083 ms
64 bytes from 192.168.137.1: icmp_seq=22 ttl=64 time=0.052 ms
64 bytes from 192.168.137.1: icmp_seq=23 ttl=64 time=0.063 ms
64 bytes from 192.168.137.1: icmp_seq=24 ttl=64 time=0.052 ms
64 bytes from 192.168.137.1: icmp_seq=25 ttl=64 time=0.031 ms
64 bytes from 192.168.137.1: icmp_seq=26 ttl=64 time=0.053 ms
64 bytes from 192.168.137.1: icmp_seq=27 ttl=64 time=0.035 ms
64 bytes from 192.168.137.1: icmp_seq=28 ttl=64 time=0.072 ms
64 bytes from 192.168.137.1: icmp_seq=29 ttl=64 time=0.039 ms
64 bytes from 192.168.137.1: icmp_seq=30 ttl=64 time=0.045 ms
^C
--- 192.168.137.1 ping statistics ---
30 packets transmitted, 30 received, 0% packet loss, time 29000ms
rtt min/avg/max/mdev = 0.028/0.055/0.141/0.024 ms
Anyways your issue is not with SQL Server or with teradata, it has to do with your network configurations. I would say research vmware networking configurations. You have NAT but that might not be what you want, or if it is you might have it configured wrong.
I wasn't allowed to use google .com in this forum because it's a link.
Forum: "Sorry, you can't include links in your posts."
But I did ping google and .com like you said
Thank you for the link!
I prefered the bridged network too, but he would tell me he failed to configure a network. I am enclosing a printscreen when I open VMware based on a bridged network version.
++++++++++++++
you could get professionals do it for YOU for a price remotely
++++++++++++++
how about getting into network FORUMS and try asking those guys .. !!!
+++++++++++++++
this might be going into a tangent ..
how about the listing the components involved and checking it one by one ...
As software developers these issues are very common
Example in t-sql
i have a query that does not work
select * from a where b join c and not in z
i first select * from a works
then add where b
select * from a where b works
then add join c
select * from a where b works join c works
+++++++++++++++++++++
