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)
 Setting SQL server to work on 1 ip only!

Author  Topic 

InSightering
Starting Member

1 Post

Posted - 2006-11-28 : 16:12:03
Hi all... i have a dedicated server with 3 external ip + 1 internal..
when someone is trying to coonect with the 3 ip's he can do it but i want to make that the sql server allows only connect to 1 ip.. that i will choose....
that is my pic of connections
http://rotter.name/User_files/nor/456c0661604417cb.jpg
can i do it?

harsh_athalye
Master Smack Fu Yak Hacker

5581 Posts

Posted - 2006-11-28 : 23:12:38
Check discussions here:

[url]http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=72128[/url]
[url]http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=21128[/url]

Harsh Athalye
India.
"Nothing is Impossible"
Go to Top of Page

Westley
Posting Yak Master

229 Posts

Posted - 2006-11-28 : 23:29:55
You can take those IP out from the server? So SQL will only listen to only 1 IP and that port number, that should be what you are after?
Go to Top of Page
   

- Advertisement -