Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Shaun E on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Controlling IP Address Binding

Status
Not open for further replies.
a6m1n0

a6m1n0

Programmer
Mar 7, 2005
233
US
Hello,
Is it possible to bind the SQL Server Service to a specific IP Address, or better yet to IP Addresses of my choosing? If so how? I need the server to only bind to localhost (127.0.0.1), but currently it is binding to all of my servers IP addresses (10.1.1.0/16) including localhost.

SQL Server 2000 Enterprise (ActionPak)
SP4+HotFix Rollup

Thanks

-a6m1n0

Curiosity only kills cats.
 
Sort by date Sort by votes
Problem Solved. Since there will be no remote connections to the SQL server, I disabled the networking protocols.

-a6m1n0

Curiosity only kills cats.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Triacona
  • Locked
  • Question
How to broadcast data from a SQL server to an IP an Port 2
Replies
5
Views
531
fisheromacse
fisheromacse
katekis
  • Locked
  • Question
Remote Connection using both TCP/IP and named pipes
Replies
0
Views
67
katekis
katekis
19972003
  • Locked
  • Question
unable to connect to sql server via internal IP internally
Replies
2
Views
135
19972003
19972003
RichardParry
  • Locked
  • Question
Restricting SA Account to IP Address List
Replies
4
Views
174
mrdenny
mrdenny
micang
  • Locked
  • Question
"Controlling " transaction log files
Replies
2
Views
68
micang
micang

Part and Inventory Search

Sponsor

Back
Top