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

Posted on 2006-05-08
Last Modified: 2008-03-06

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
Question by:develc
    LVL 12

    Assisted Solution

    afaik, after adding new IP to OS, SQL server automatically starts listening on second adress.
    LVL 1

    Author Comment

    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.
    LVL 28

    Accepted Solution

    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.
    LVL 1

    Author Comment


    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

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

    Nevertheless thank you for your help.

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Join & Write a Comment

    In this article—a derivative of my blog post (—I will explore a few different perspectives on which week today's date falls within using Microsoft SQL Server. First, to frame this stu…
    Having an SQL database can be a big investment for a small company. Hardware, setup and of course, the price of software all add up to a big bill that some companies may not be able to absorb.  Luckily, there is a free version SQL Express, but does …
    Via a live example, show how to setup several different housekeeping processes for a SQL Server.
    Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

    755 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    22 Experts available now in Live!

    Get 1:1 Help Now