Solved

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

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

Backup Solution for AWS

Read about how CloudBerry Backup fully integrates your backups with Amazon S3 and Amazon Glacier to provide military-grade encryption and dramatically cut storage costs on any platform.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Incremental load example 2 57
Help with SQL joins 9 58
My Query is not giving correct result. Please help 5 55
Sql query 107 88
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…
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…
In an interesting question (https://www.experts-exchange.com/questions/29008360/) here at Experts Exchange, a member asked how to split a single image into multiple images. The primary usage for this is to place many photographs on a flatbed scanner…

730 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