how to connect sql server with ip address

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 2000 Forums

SQL Server Administration (2000)

how to connect sql server with ip address

Author

Topic

rajesha
Starting Member

36 Posts

Posted - 2002-06-01 : 12:44:06

how can i connect an sql server with its ip address
let it 10.72.15.65
i tried this in sql qurey analyser in place of name of the server
but it failed.
can anybody tell me?

jasper_smith
SQL Server MVP & SQLTeam MVY

846 Posts

Posted - 2002-06-01 : 21:11:42

Easiest way is to set up a TCP/IP client alias
Goto Start>Program Files>Microsoft SQL Server>Client Network Utility
and click on Alias>Add. Make sure TCP/IP radio button is selected, type the name you want to refer to the server by in the Server Alias box and the IP address into the Server name box and click on OK.
You should then be able to connect using the server name in QA.

You can also make sure your PC can resolve the IP address by adding it to your HOSTS and LMHOSTS files.

HTH
Jasper Smith

rajesha
Starting Member

36 Posts

Posted - 2002-06-02 : 05:33:44

i added ip address in client network utility both in server and client
and while iam trying to coonect the server it is showing

unable to connect \\10.72.15.64
server:Msg 17,level 16,state1
[microsoft][odbc sql server driver][named pipes]sql server doent exist or access denied

what is the problem?

robvolk
Most Valuable Yak

15732 Posts

Posted - 2002-06-02 : 06:54:48

quote:

Easiest way is to set up a TCP/IP client alias
Goto Start>Program Files>Microsoft SQL Server>Client Network Utility
and click on Alias>Add. Make sure TCP/IP radio button is selected, type the name you want to refer to the server by in the Server Alias box and the IP address into the Server name box and click on OK.
You should then be able to connect using the server name in QA.

You can also make sure your PC can resolve the IP address by adding it to your HOSTS and LMHOSTS files.

HTH
Jasper Smith

Please re-read the part highlighted in red.

jasper_smith
SQL Server MVP & SQLTeam MVY

846 Posts

Posted - 2002-06-02 : 08:02:51

quote:
unable to connect \\10.72.15.64

Also you need to specify the server name you set up in the alias NOT the IP address (which that isn't by the way "\\xxx.xxx.xxx.xxx" is not the IP address of your server and will confuse it - try JUST the ip address if you must - forget the \\ )

Say you set up yout TCP/IP alias called SERVER1 and add your ip address for the server name. Then when you open Query Analyzer just type SERVER1 into the box.

rajesha
Starting Member

36 Posts

Posted - 2002-06-03 : 00:19:19

very very thanks.i could connect server through ip address now.
i want to know how to to connect it through internet.when i typed the ip address error is coming.like
" the requested url cannot be retrieved"
can you tell that also?

jasper_smith
SQL Server MVP & SQLTeam MVY

846 Posts

Posted - 2002-06-03 : 09:17:53

How are you trying to connect ? You need to use QA or EM.

quote:
" the requested url cannot be retrieved"

Sounds like you are trying to connect via http ??

can you ping the IP address ?

HTH
Jasper Smith

monkeybite
Posting Yak Master

152 Posts

Posted - 2002-06-03 : 10:26:02

If I'm not mistaken, 10.72.15.65 is in a non-routable IP block, so you can't use this address over the internet.

-- monkey

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources