Connect Dababase from Windows7 to windows 2008.
-
Windows 2008 server has ms-sql 2008. And my pc has windows7. I run cmd and input "telnet 192.111.111.11 1433" my pc can't connect But other pc(windows xp) can connect. How can i connect?
hi My english is a little. anyway, nice to meet you~~ and give me your advice anytime~
-
Windows 2008 server has ms-sql 2008. And my pc has windows7. I run cmd and input "telnet 192.111.111.11 1433" my pc can't connect But other pc(windows xp) can connect. How can i connect?
hi My english is a little. anyway, nice to meet you~~ and give me your advice anytime~
Hi, Why would you connect to SQL Server using telnet? Although you could make the connection, SQL Server is dropping you off immediately when something is sent. If you're trying to resolve connectivity issues, try using telnet against the telnet server port (typically 23) or simply ping to check that you can find the server.
The need to optimize rises from a bad design.My articles[^]
-
Hi, Why would you connect to SQL Server using telnet? Although you could make the connection, SQL Server is dropping you off immediately when something is sent. If you're trying to resolve connectivity issues, try using telnet against the telnet server port (typically 23) or simply ping to check that you can find the server.
The need to optimize rises from a bad design.My articles[^]
To test server, i Input telnet command. Database server ip is 198.1.1.123(example). Other two pc(windows xp) can connect database server, but only my pc can't connect by using telnet.
hi My english is a little. anyway, nice to meet you~~ and give me your advice anytime~
-
Windows 2008 server has ms-sql 2008. And my pc has windows7. I run cmd and input "telnet 192.111.111.11 1433" my pc can't connect But other pc(windows xp) can connect. How can i connect?
hi My english is a little. anyway, nice to meet you~~ and give me your advice anytime~
Could be caused by the firewall of Windows 7 - turn it completely off and try again. If it works, try to adjust your firewall such that it is still active but still allows the connection to SQL server. There could be other issues like domain membership, group policies etc. By the way, when trying
telneton my Win7 computer, I get a "command not found" message... -
To test server, i Input telnet command. Database server ip is 198.1.1.123(example). Other two pc(windows xp) can connect database server, but only my pc can't connect by using telnet.
hi My english is a little. anyway, nice to meet you~~ and give me your advice anytime~
Ok, so it's a connectivity issue. Try disabling the firewall in Windows 7. Also check that you are not blocked by any other firewalls, routers etc. You could also try pinging the server to see if it acts differently.
The need to optimize rises from a bad design.My articles[^]
-
Could be caused by the firewall of Windows 7 - turn it completely off and try again. If it works, try to adjust your firewall such that it is still active but still allows the connection to SQL server. There could be other issues like domain membership, group policies etc. By the way, when trying
telneton my Win7 computer, I get a "command not found" message...Bernhard Hiller wrote:
By the way, when trying
telneton my Win7 computer, I get a "command not found" message...You need to turn it on. Go to controlpanel, programs and features, turn windows features on or off.