[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 201
  • Last Modified:

SQL Server listens to a second IP Address (from second adapter)

Hello,

we have different networks with several functions.
Our SQL Server (Instance) is currently configured to listen to one IP Address but now we've the demand to connect to another network which is connected with the second adapter (IP Address).
How to configure the SQL Server (Instance) that it listens to the second IP Address, too?
(in addition to the first IP Address)

Greetings develc
0
develc
Asked:
develc
  • 2
2 Solutions
 
illCommented:
afaik, after adding new IP to OS, SQL server automatically starts listening on second adress.
0
 
develcAuthor Commented:
that's what I thought first, too - but it doesn't works!

For more Information: on the SQL Server runs two Instances - and it is clustered.
0
 
imran_fastCommented:
which version of sql server you have for 2005
just go to computer managemnt ==> services and application ==> sql configuration ==> network ==> tcip protocol
here you can specify two ips.
0
 
develcAuthor Commented:
Hello,

no it isn't that easy way, as I already wrote: it's a clustered Server with two instances on.

We solved the problem together with Microsoft: Using the following KnowledgeBase Article!

244980: How to change the network IP addresses of SQL Server virtual servers
http://support.microsoft.com/kb/244980/en-us

But you have to change the cluster afterwards and back again - no it's works perfect.

Nevertheless thank you for your help.
Greetings
develc
0

Featured Post

Prep for the ITIL® Foundation Certification Exam

December’s Course of the Month is now available! Enroll to learn ITIL® Foundation best practices for delivering IT services effectively and efficiently.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now