Solved

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

Posted on 2011-03-24
3
299 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
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

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

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

by Mark Wills Attending one of Rob Farley's seminars the other day, I heard the phrase "The Accidental DBA" and fell in love with it. It got me thinking about the plight of the newcomer to SQL Server...  So if you are the accidental DBA, or, simp…
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
This video explains how to create simple products associated to Magento configurable product and offers fast way of their generation with Store Manager for Magento tool.
This is a video describing the growing solar energy use in Utah. This is a topic that greatly interests me and so I decided to produce a video about it.

948 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

18 Experts available now in Live!

Get 1:1 Help Now