Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Connectivity

Author  Topic 

omamiiiiii
Starting Member

3 Posts

Posted - 2006-07-13 : 11:52:53
Hello everybody.
I am connecting my computer to the internet and when i see the ip address of my computer i try:

telnet ipaddress 1433 but it says 'connection failed'.

this happens even when i try to access my sql server from another computer through the internet.

I have installed service pack 4,configured the server connectivity by adding the tcp/ip protocol and checked the port:it is 1433.

Also checked the firewalls ,but no results.

please help

SreenivasBora
Posting Yak Master

164 Posts

Posted - 2006-07-13 : 14:44:12
1. Check your connection string in your Internet appliation
2. Ping the server and try with sql
3. Check U have permission on the sqlbx or not

With Regards
BSR
Go to Top of Page

jen
Master Smack Fu Yak Hacker

4110 Posts

Posted - 2006-07-13 : 21:52:55
1. how are you exactly doing this and where?
2. are you in a domain, standalone, at home?
3. you can try local in your sql connection, if it's a different computer, else verify #2

do you obtain your ip address automatically or is it set? verify if the ip address is the same when you go out into the net

hope this helps...

--------------------
keeping it simple...
Go to Top of Page

PSamsig
Constraint Violating Yak Guru

384 Posts

Posted - 2006-07-14 : 01:10:29
When you get it to work then you should change the port to something non-standard, you will get quite a bit of unwarnted traffic on 1433/1434.

-- This one's tricky. You have to use calculus and imaginary numbers for this. You know, eleventeen, thirty-twelve and all those.
Go to Top of Page

omamiiiiii
Starting Member

3 Posts

Posted - 2006-07-14 : 03:33:48
I connect to the internet using dial-up and i obtain an ip-address automatically.
I have checked Server Network Utility and all firewalls,they are ok.
I have Windows Xp SP2.

When i try telnet localhost 1433 it opens.When i connect to the internet and try telnet ipaddress 1433 it doesnt'connect.I am doing this because i want to connect to this server remotely from the internet and i was making this try.
Go to Top of Page
   

- Advertisement -