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
Manually edit the registry 1. Add a new registry key under HKLM\software\microsoft\microsoftSQLServer\mssql.1\mssqlserver\supersocketnetlib\tcpfor IP2
simplest way to make it is export the Key
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"="18.104.22.168"
2. Import the registry again.
3..Now the new ip is listed in SQLServer configuration manager for editing.
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.
PingBack from http://www.anith.com/?p=28286
learn another new thing today, thanks..
I'm thankful to the one who wrote this passage. I always read and write this style of articles. Also, as a daily writer, I present my respects to the all writers. Lately, I have watched a video resembling that in <a href="http://www.youtubeizleyin.net" title="youtube">youtube</a>. I research in all areas.
In my opinion, people should research first and write then.
<a href="http://www.jerseys-shopping.com/tennessee-titans-c-123.html">Tennessee">http://www.jerseys-shopping.com/tennessee-titans-c-123.html">Tennessee Titans jersey </a>[url=http://www.jerseys-shopping.com/tennessee-titans-c-123.html]Tennessee Titans jersey[/url]
Nice article,<a href="http://www.caipuwu.com.cn" rel="dofollow">caipu</a>