How to add an IP Address when we Add new NIC to node where SQLServer2005 instance is running.

  • Article

The only possible way to add an IP to SQLServer2005 after adding new NIC to the
node where SQLServer2005 is installed (or) After adding second ip address to
existing NIC is to either manually edit the registry or run Service pack/Hotfix setup again.

 

The only possible way to add an IP to SQLServer2005 after adding new NIC to the
node where SQLServer2005 is installed (or) After adding second ip address to
existing NIC is

Option1

Manually edit the registry

1. Add a new registry key under
HKLM\software\microsoft\microsoftSQLServer\mssql.1\mssqlserver\supersocketnetlib\tcp
for IP2

simplest way to make it is export the Key

HKLM\software\microsoft\microsoftSQLServer\mssql.1\mssqlserver\supersocketnetlib\tcp
,

Open the exported file using the notepad and Copy the Following string ,make
required changes(Modify the IPAddress,IPn.. Ie: n stands for number of IP and MSSQL.N Ie nstands for instance ID )

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL
Server\MSSQL.X\MSSQLServer\SuperSocketNetLib\Tcp\IPn]
"Enabled"=dword:00000000
"Active"=dword:00000001
"TcpPort"=""
"TcpDynamicPorts"=""
"DisplayName"="Specific IP Address"
"IpAddress"="65.52.17.19"

2. Import the registry again.

3..Now the new ip is listed in SQLServer configuration manager for editing.

 

Option2

Install the service pack again.

1. After the installatin of Service packs/HotFIx SQLServer recognize the new NIC but
Assings wrong IPaddresses to SQLserver.it makes SQLServer Listen on wrong ip's and
so the SQLServer might fail to start with error

"Error: 17120, Severity: 16, State: 1.
2007-08-25 00:27:10.83 Server SQL Server could not spawn FRunCM thread.

Check the SQL Server error log and the Windows event logs for information about
possible related problems."

2. We can find duplicate IP in SSCM(SQLServer Configuration manager). we can edit
 the IP addresses in SQLserver configuration manager to fix right IP and start the SQLServer.

 

Regards

Karthick P.K