I have a few NICs on a machine, so I told
Microsoft SQL Server 2005 - 9.00.3042.00 (Intel X86) not to bind on every interface but only one. So far so good.
Unfortunately I had the BAAAD idea to change this NIC IP Address. Old IP was 192.168.0.103, new IP is 192.168.6.65.
When I try to start the service with commandline
sqlservr.exe -sSQLEXPRESS where's what I get
Server failed to listen on 192.168.0.103 1433. Error: 0x2741. To proceed, notify your system administrator.
Standard useless error message. Ok, there must be this old address configured somewhere. In the registry, of course. Just searched throughout the whole registry and found:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.1\MSSQLServer\SuperSocketNetLib\Tcp
Here you'll find subkeys named
IP1 to
IPSomeNumber. If one refers to an unbindable address just set
Enabled or
Active to 0.
Owner login
