Changing TCP/IP IP addresses under Protocols for SQLExpress

SQL Server Configuraton Manager,

Protocols for sqlexpress,

TCP/IP

When I initially installed SQL Server 2005 Express, it automatically picked up all the IP addresses (60 of them) I had on the server, and filled them in under TCP/IP - IP adresses Tab.

I recently took those IPs off the server and replaced them with 30 new IP addresses. Is there a way to have SQL Server 2005 Express read the Network configuration on the server and take the old IPs off the TCP/IP - IP addresses tab and put the new one's there?

Thanks,

Bill

You have to reinstall your SQL Server to pick the new IP addresses. Are you listening on each IP address seperately or listening on IPALL? Those IPs does not matter if your server listens on IPALL.|||

Thanks a lot Xinwei, I reinstalled SQL Server and everything went fine.

Bill

Changing IP Addresses of a cluster

I will be relocating a SQL 2000 cluster onto a new subnet of a corporate network and will need to change the 'public' IP address of the cluster nodes as well as the virtual IP address. In doing this, I want to make sure that I have the proper process dow
n correctly.
1. Change the IP addresses of each node as referenced in KB 230356
2. Change the IP addresses of the virtual cluster as referenced in KB 244980
Is this correct? Am I missing anything?
Thanks in advance for your assistance!
Replace IP ONLY and ONLY through SQL setup with remove option
rgds
Sinisa Perovic
|||

Quote:

Originally posted by DBADave
I will be relocating a SQL 2000 cluster onto a new subnet of a corporate network and will need to change the 'public' IP address of the cluster nodes as well as the virtual IP address. In doing this, I want to make sure that I have the proper process dow
n correctly.
1. Change the IP addresses of each node as referenced in KB 230356
2. Change the IP addresses of the virtual cluster as referenced in KB 244980
Is this correct? Am I missing anything?
Thanks in advance for your assistance!

Dave, did this work out smoothly? I'll have to do the exact same thing. Did it work after changing node IPs then using SQL setup to change the virtual SQL server IP?
Thanks,
Matt.

Changing IP addresses

We are planning on changing IP addresses on two database
servers that have SQL transactional replication between
them. Before I get into any trouble, do you see any
problem that could occur regarding the replication
communication between the servers. My plan is to change
the IP addresses and reboot the servers. I won't know
until I do this if the replication will start back up
successfully.
replication is insensitive to IP address changes.
there are some caveats
1) if you are using the client network utility to associate the IP address with the machine name you will have to update the ip addresses
2) if you are using a hosts file for name lookup s to associate the IP address with the machine name you will have to update the ip addresses in this file
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"Jeff Steinweber" wrote:

> We are planning on changing IP addresses on two database
> servers that have SQL transactional replication between
> them. Before I get into any trouble, do you see any
> problem that could occur regarding the replication
> communication between the servers. My plan is to change
> the IP addresses and reboot the servers. I won't know
> until I do this if the replication will start back up
> successfully.
>