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
LVL 1
develcAsked:
Who is Participating?
 
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
 
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
 
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.