not able to telnet sql port 1433 remotly

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

SQL Server 2008 Forums

Other SQL Server 2008 Topics

not able to telnet sql port 1433 remotly

Author

Topic

kediacommodity1
Starting Member

9 Posts

Posted - 2009-03-09 : 12:11:36

i am using windows 2003 server and sql 2000
when i telnet locally its working and when i am trying to do telnet from remotely its not work.

i am check in sql logs 1433 port in listening

vijay kedia
kediacommodity1@yahoo.co.in

guptam
Posting Yak Master

161 Posts

Posted - 2009-03-09 : 20:16:45

Check to make sure that your SQL Server allows remote connections and there is no firewall between server and your remote host. Thanks.

--
Mohit K. Gupta
B.Sc. CS, Minor Japanese
MCITP: Database Administrator
MCTS: SQL Server 2005
http://sqllearnings.blogspot.com/

kediacommodity1
Starting Member

9 Posts

Posted - 2009-03-12 : 03:15:49

Dear Sir,

i am checked i am useing firewall but i exclude the sql serv and ports/

kediacommodity1
Starting Member

9 Posts

Posted - 2009-03-12 : 03:19:07

locally i am able to do telnet and in in sql logs i am getting that port 1433 listning.
only problem is that from remote i am not able to telnet.

REgards

quote:
Originally posted by kediacommodity1

i am using windows 2003 server and sql 2000
when i telnet locally its working and when i am trying to do telnet from remotely its not work.

i am check in sql logs 1433 port in listening

vijay kedia
kediacommodity1@yahoo.co.in

guptam
Posting Yak Master

161 Posts

Posted - 2009-03-12 : 06:39:06

I need you to check that firewall allows port port 1433 through? And you can check the remote setting on sql server with following script:

sp_configure "remote access"

Can you paste the error message?

--
Mohit K. Gupta
B.Sc. CS, Minor Japanese
MCITP: Database Administrator
MCTS: SQL Server 2005
http://sqllearnings.blogspot.com/

kediacommodity1
Starting Member

9 Posts

Posted - 2009-03-12 : 13:52:54

Dear

I again checked the firewall i added the tcp and udp port 1433 in exemption list.

when i use telnet xxx.xx.xx.xx 1433 blace screen comes and disappere.

when i verify ODBC Data source i get error:

Connection Failed:
SQL Stata :01000
Sql server Error :10060
{microsoft][odbcsql server driver][tcp/ip Socket] ConnectionOpen (connect)
Connection Failed
sql stata :08001
sql server error :17
{microsoft][odbcsql server driver] (tcp/ip socket) sql server does not exist or acess dinied.

Please find some solution

Regards

vijay and mail a copy to me on kediacommodity1@yahoo.co.in

quote:
Originally posted by guptam

I need you to check that firewall allows port port 1433 through? And you can check the remote setting on sql server with following script:

sp_configure "remote access"

Can you paste the error message?

--
Mohit K. Gupta
B.Sc. CS, Minor Japanese
MCITP: Database Administrator
MCTS: SQL Server 2005
http://sqllearnings.blogspot.com/

guptam
Posting Yak Master

161 Posts

Posted - 2009-03-12 : 14:04:22

Hmm are your protocol enabled?

Go to SQL Server Configuration Manager on the server

Then go to SQL Server 2005 Network Configuration

And check to make sure you have at least one of TCP/IP or Named pipes enabled.

Thanks.

--
Mohit K. Gupta
B.Sc. CS, Minor Japanese
MCITP: Database Administrator
MCTS: SQL Server 2005
http://sqllearnings.blogspot.com/

kediacommodity1
Starting Member

9 Posts

Posted - 2009-03-13 : 02:05:10

Dear Sir,

i checked tcp/ip and name pipe are enabled.

Regards
vijay

quote:
Originally posted by guptam

Hmm are your protocol enabled?

Go to SQL Server Configuration Manager on the server

Then go to SQL Server 2005 Network Configuration

And check to make sure you have at least one of TCP/IP or Named pipes enabled.

Thanks.

--
Mohit K. Gupta
B.Sc. CS, Minor Japanese
MCITP: Database Administrator
MCTS: SQL Server 2005
http://sqllearnings.blogspot.com/

guptam
Posting Yak Master

161 Posts

Posted - 2009-03-13 : 02:09:50

Did you check run ...

sp_configure 'remote access'

On the server? That is the only other thing I can think of.. Firewall good, Protocols Good ... Then it must not allow remote connections on the server; check SQL Server logs and event logs on the server to see if there is anything.

Try pinging SQL Server from your other computer to see if Ping goes through...
Thanks.

--
Mohit K. Gupta
B.Sc. CS, Minor Japanese
MCITP: Database Administrator
MCTS: SQL Server 2005
http://sqllearnings.blogspot.com/

kediacommodity1
Starting Member

9 Posts

Posted - 2009-03-13 : 08:19:16

dEAR sIR,

I AM NOT ABLE TO OPEN SP_CONFIGURE "REMOTE ACCESS" CAN SEND ME THE DETAILS

HOW I CAN DO

REGARDS

quote:
Originally posted by guptam

Did you check run ...

sp_configure 'remote access'

On the server? That is the only other thing I can think of.. Firewall good, Protocols Good ... Then it must not allow remote connections on the server; check SQL Server logs and event logs on the server to see if there is anything.

Try pinging SQL Server from your other computer to see if Ping goes through...
Thanks.

--
Mohit K. Gupta
B.Sc. CS, Minor Japanese
MCITP: Database Administrator
MCTS: SQL Server 2005
http://sqllearnings.blogspot.com/

guptam
Posting Yak Master

161 Posts

Posted - 2009-03-13 : 11:44:08

On the SQL Server in question ..
Launch SSMS and Connect to server.
Start a New Query
Type in "sp_configure 'remote access'"
Press F5 (run).

Alternatively...

On The SQL Server in Question
Launch SSMS and Connect to server.
Right click on server go to Properties.
Click Connections.
Select "Allow remote connections on server".
Click OK.

--
Mohit K. Gupta
B.Sc. CS, Minor Japanese
MCITP: Database Administrator
MCTS: SQL Server 2005
http://sqllearnings.blogspot.com/

kediacommodity1
Starting Member

9 Posts

Posted - 2009-03-13 : 12:56:43

the valu of remote access (mimimum=0, maximum=1, Configer value=1, run value =1)

please suggest if any change

Regrda

quote:
Originally posted by guptam

On the SQL Server in question ..
Launch SSMS and Connect to server.
Start a New Query
Type in "sp_configure 'remote access'"
Press F5 (run).

Alternatively...

On The SQL Server in Question
Launch SSMS and Connect to server.
Right click on server go to Properties.
Click Connections.
Select "Allow remote connections on server".
Click OK.

--
Mohit K. Gupta
B.Sc. CS, Minor Japanese
MCITP: Database Administrator
MCTS: SQL Server 2005
http://sqllearnings.blogspot.com/

guptam
Posting Yak Master

161 Posts

Posted - 2009-03-13 : 13:09:00

Those are correct; did you try connecting to your server using SSMS? Instead of using Telnet? All settings seem correct now...

--
Mohit K. Gupta
B.Sc. CS, Minor Japanese
MCITP: Database Administrator
MCTS: SQL Server 2005
http://sqllearnings.blogspot.com/

kediacommodity1
Starting Member

9 Posts

Posted - 2009-03-13 : 13:27:05

i would like to connect databast useing odbc

can you give me your contact number.

regards

quote:
Originally posted by guptam

Those are correct; did you try connecting to your server using SSMS? Instead of using Telnet? All settings seem correct now...

--
Mohit K. Gupta
B.Sc. CS, Minor Japanese
MCITP: Database Administrator
MCTS: SQL Server 2005
http://sqllearnings.blogspot.com/

guptam
Posting Yak Master

161 Posts

Posted - 2009-03-13 : 14:22:36

Okay run odbc manager..

Start->Run->odbcad32
Click on System - > Add
Scroll the list find "SQL Native Client", Select it.
Click Finish.
Enter Name "TestODBC", Description "Blank"
Server "yourServerName", click Next
If your server is on domain leave "Integrated WIndows Authentication", Click Next.
(.... If you can talk to your server here your good to go :).)
Select Change the default database to: Look in list find db you need; select it.
Click Next.
Click Finish.
Click Test Data Source... Confirm and click OK.
And Click Ok.

Thanks.

--
Mohit K. Gupta
B.Sc. CS, Minor Japanese
MCITP: Database Administrator
MCTS: SQL Server 2005
http://sqllearnings.blogspot.com/

kediacommodity1
Starting Member

9 Posts

Posted - 2009-03-19 : 07:25:03

same problem

quote:
Originally posted by guptam

Okay run odbc manager..

Start->Run->odbcad32
Click on System - > Add
Scroll the list find "SQL Native Client", Select it.
Click Finish.
Enter Name "TestODBC", Description "Blank"
Server "yourServerName", click Next
If your server is on domain leave "Integrated WIndows Authentication", Click Next.
(.... If you can talk to your server here your good to go :).)
Select Change the default database to: Look in list find db you need; select it.
Click Next.
Click Finish.
Click Test Data Source... Confirm and click OK.
And Click Ok.

Thanks.

--
Mohit K. Gupta
B.Sc. CS, Minor Japanese
MCITP: Database Administrator
MCTS: SQL Server 2005
http://sqllearnings.blogspot.com/

guptam
Posting Yak Master

161 Posts

Posted - 2009-03-19 : 14:21:03

Okay this is not making sense ..

1) Your confirmed SQL Server allows remote connections.
2) You confirmed firewall allows port 1433.
3) You confirmed TCP/IP and Named Pipes Protocols are enabled.

Found intersecting article that might be of help:
http://blogs.msdn.com/sql_protocols/archive/2005/12/19/505372.aspx (look at point #3)
http://support.microsoft.com/kb/888228 (Not a cluster or named instance right???)
http://support.microsoft.com/kb/328306 (lists whole hosts of things that can cause issue, have a quick scan through this)....

Thanks.

--
Mohit K. Gupta
B.Sc. CS, Minor Japanese
MCITP: Database Administrator
MCTS: SQL Server 2005
http://sqllearnings.blogspot.com/

jmozko
Starting Member

1 Post

Posted - 2014-07-01 : 01:26:10

Hi:

Here is the solution [url]http://stackoverflow.com/questions/9478957/unable-to-access-an-instance-of-sql-server-2008-r2-remotely[/url]

Regards

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources