I added a new IP address to my server (Windows 2016). But I'm unable to see this new Ip address in SQL Server Network Configuration. Restarting SQL services didn't solve anything. I guess rebooting the server would work, but is there any way around it?
Sql server does not recognize new IPs in any way. I thought a reboot would solve that. I was wrong. I found the answer here: [https://mssqlwiki.com/tag/how-to-add-new-ip-to-sql-server/] In short
- You need to reinstall
- You can edit register manually. Add new IPs here:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.X\MSSQLServer\SuperSocketNetLib\Tcp\IPn
I chose the second way.