Summary
You received the following error message in IMSS:
The configuration of the AdminConnection\TCP protocol in the SQL instance IMSS_SSEINSTANCE is not valid.
Details
This issue happens when there is a change in the SQL database administration used in IMSS.
To resolve the issue, change the value of TcpDynamicPorts to 1433 for SQL communication with the instance using Windows Registry.
Do the following:
- Open the Windows Registry Editor (regedit.exe).
Important: Making incorrect changes to your registry can cause serious system problems. Always back it up before making any changes. Should issues occur with your system, refer to the "Restore the registry" help topic in regedit.exe or regedt32.exe.
- Go to the following hive:
64-bit Windows: [HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\Microsoft SQL Server\MSSQL.1\MSSQLServer\SuperSocketNetLib\AdminConnection\Tcp]32-bit Windows: [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.1\MSSQLServer\SuperSocketNetLib\AdminConnection\Tcp]
- Change the value for TcpDynamicPorts to"1433".
- Change the value for DisplayName to "TCP/IP" (if needed).