Configuring SQL Server 2012 Gestore della configurazione per SCCM 2012 R2.
- Login to your system with SQL Server;
2. Vai a All programs and start SQL Server 2012 Gestore della configurazione; 3. In the opened console go to SQL Server Network Configuration\Protocols for <your instance name> (nel mio caso SCCM);
4. Aprire Proprietà of TCP/IP;
5. Vai a IP Addresses In IP1 clear TCP Dynamic Ports e inserisci il tuo SQL porta (nel mio caso 14331) A Porte TCP, repeat the action for IP2, IP3 (all interfaces with an IP address), and IPALL. You must enter the port, that you early open in Windows Firewall.
Quando completo, clic OK;
6. In the pop-up window click OK;
7. Vai a SQL Server Services, selezionare SQL Server (<your instance name>) and restart it;
8. Restarting begins;
9. When complete – close the Console di Configuration Manager.
