How to add an IP Address when we Add new NIC to node where SQLServer2005 instance is running.
Posted by Karthick P.K on April 14, 2009
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
Top SQL Server blogs from MSSQLWIKI « MSSQLWIKI said
[…] How to add an IP Address when we Add new NIC to node where SQLServer2005 instance is running. […]
รับเพิ่มไลค์ said
Wonderful post however I was wanting to know if
you could write a litte more on this subject?
I’d be very thankful if you could elaborate a little
bit further. Kudos!
online tarot course said
We are a gaggle of volunteers and opening a new scheme in our community.
Your site offered us with useful information to work on. You’ve performed an impressive process and our
whole community will probably be grateful to you.
motorcycle helmets for sale said
Hello just wanted to give you a brief heads up and let
you know a few of the pictures aren’t loading correctly.
I’m not sure why but I think its a linking issue.
I’ve tried it in two different internet browsers and both
show the same results.