MSSQLWIKI

Karthick P.K on SQL Server

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

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

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

  2. 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!

  3. 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.

  4. 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.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

 
%d bloggers like this: