Cant install System Center 2012 R2 Configuration Manager
I've gone though half the steps to install System Center 2012 R2 Configuration Manager, but I cant get passed the SQL Server settings.
I can connect to the SQL Server in question via ODBC and Windows firewall is off on both servers. They are also on the same subnet, so no physical firewalls are in between.
Unfortunately that's only made things worse for me now. Since changing all the TCP Dynamic Ports be blank and configuring all the TCP ports in the...
SQL Server Configuration Manager > SQL Server Network Configuration > Protocols for Named_Instance > TCP/IP > IP addresses
... I now find that the 'SQL Server (Instance Name)' service doesn't start. At first it complained that the user did not have logon as a service right, so I change the account for 3 related services for the instance name and its now giving the following error in the event log.
'Event ID 7024:
The SQL Server (My Instance Name) service terminated with service-specific error Only one usage of each socket address (protocol/network address/port) is normally permitted..'
Here's how I have configured the TCP settings..
If I change the TCP settings back to the Dynamic values, the services then start, but only if I leave the services accounts with an account that has Logon as a service right. Changing back to the NT Service\MSSQL$Instance doesn't work now as well.