Solved

SQL Server 2005 with one default instance with two IP addresses?

Posted on 2011-03-24
3
309 Views
Last Modified: 2013-11-05
I have a SQL Server 2005 EE running the default instance.  Assuming I have an ip address of 192.168.1.1 already assigned on this server, is it possible to add a secondary IP address of 192.168.1.2 to this server, have have the same single instance listen on both IP.s?
0
Comment
Question by:infoservices
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 5

Expert Comment

by:bitref
ID: 35209957
Yes, you can. Also, you may use the computer name.
0
 
LVL 28

Accepted Solution

by:
Ryan McCauley earned 125 total points
ID: 35211017
Here's a walkthough on adding a second IP address to your server (assuming you don't have it already):

http://www.experts-exchange.com/OS/Microsoft_Operating_Systems/Server/2003_Server/Q_24191493.html

Once you have a second IP address, you can open "SQL Server Configuration Manager", go to the protocols for your database instance, open "TCP/IP", and on the second tab, you can see all the IP addresses on your server. Just enable the second IP, set the port (default is 1433), and then restart your SQL Server instance - now it will be listening on the second IP address in addition to the first.
0
 

Author Closing Comment

by:infoservices
ID: 35233495
Thanks for your assistance.  This was indeed the correct work around to add the second IP.
0

Featured Post

Get 15 Days FREE Full-Featured Trial

Benefit from a mission critical IT monitoring with Monitis Premium or get it FREE for your entry level monitoring needs.
-Over 200,000 users
-More than 300,000 websites monitored
-Used in 197 countries
-Recommended by 98% of users

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

INTRODUCTION: While tying your database objects into builds and your enterprise source control system takes a third-party product (like Visual Studio Database Edition or Red-Gate's SQL Source Control), you can achieve some protection using a sing…
In SQL Server, when rows are selected from a table, does it retrieve data in the order in which it is inserted?  Many believe this is the case. Let us try to examine for ourselves with an example. To get started, use the following script, wh…
In this brief tutorial Pawel from AdRem Software explains how you can quickly find out which services are running on your network, or what are the IP addresses of servers responsible for each service. Software used is freeware NetCrunch Tools (https…
This is my first video review of Microsoft Bookings, I will be doing a part two with a bit more information, but wanted to get this out to you folks.

726 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